Search results for query: *

Hi, There is a function 'filelist' on the web in Excel macro but I am looking for a similar func with VBS, which can be run in Window Explorer. Thanks in advance. Here is the Excel macro/function 'FILELIST'. Function FileList(fldr As String, Optional fltr As String = "*.*") As Variant...

Hi, I recorded a macro that can convert a text file into an Excel workbook. But the code looks messy with quite some redundant statements. I tried to streamline it but with no success. Like the Arrays, do we need that many arrays? Besides, what if I have more than 30 fields? That being the...

Hello folks, I have an AccessDB with a size of abound 30 MG. There are tons of macros in it. I am responsible for running some production jobs at the beginning of a month. A few associates did the similar thing a few days ago. As I took over, I found none of the butotns, back up by some macros...

Hello, I cannot figure out what's wrong with the syntax on the SQL statements. It's not a complicated process, is it? All I want is to check out if the input dataset has been updated. So I can run my process if it has. The query that I ran was in Excel ADO. But the dataset resides in MS...

Hi, Is there any way of combining the following two Subs into one? Or it looks messay. Thanks. Sub SumByGroup(keyfield As String, datacol As Integer, destcol As Integer) 'keyfield: the field of key, datacol: Offset number, if keyfield is "a" then datacol=2 means data in field "c" 'destcol...

Hi, Not sure if the subject is more like supposed to be in the fields of Access forum but the destination is in Excel. Please forgive me if I came to the wrong site. I copied a part of the code from Youtube but I need to set up a query to output a small subset of data from an Access table (the...

Hello folks, Long time no talk. Hope all is well with you! I have about 100 Word files listed on an Excel spreadsheet. I don't want to go through the pain to search for some strings in each Word doc by opening and closing it if I find nothing. I have a Word macro to find a particular string...

Hello, I tried to do what I have to do to fulfill what the subject specified but not quite satisfied with what I got. I have about 5 workbooks for each model. I was asked to copy all the tabs in each book and place them in a single workbook. However, we have 10 to 20% of the tabs have the same...

Hello, I've embedded a shape (or icon) in on a spreadsheet by a macro. But the icon won't show the image of the item until the book is saved and reopened. What's the refresh statements to make it present itself right after the embedding is done? Thanks in advance.

Hello, Somehow I screwed up the layout of those windows but tried to make them come back where they were and failed. Is there any shortcut to get the thing done? I read some posts before and I'm not the only one who has the issues. I remember I figure out a way of doing it but I forgot again, an...

Hello, I recorded a macro to do what's on the Subject line but each time I have to select a particular file from a folder. What I want is to have a macro with a do loop that can embed multiple file in a series of designated cells, with no need for the user to pick from a folder. Here is the...

Hello, Hope you all doing well and staying far far away from COVID 19. What i'm trying to do is to copy all the tabs of all the workbooks in a folder into a single workbook. But I have 2 errors : one is from the statement: Set nusheet = Workbooks(basebook).Worksheets.Add. But if I take...

Hello, Would you happen to have some ready-made code to do the task in the Subject line? I copied some code from Google.com but most of them are not working. Like the following: the bug comes form the statements of "objFILE.Copy objEND": object required... Dim objFSO Dim objSTR, objEND, objTYP...

Hello, I guess the subject has made myself clear. If not please let me know what info needed. Thanks in advance.

Hello, I need you guys to help me with some ADO messages. I have a snapshot attached. I do not understand what's wrong with the name of the table. I ran a few procedures with very similar table name without any issues until now. you can see the SQL statement in the query cannot be simpler than...

Hello guys, A quick question. Haven't created Excel macros for a while. I guess I did it before but unable to find a solution. I know for ActiveX, this is not a problem. But for Form, it is number by default. One more question. The reason why I use Form to insert shapes, instead of ActiveX, is...

Hello, I am trying to xcopy some folders and files with specific suffix to a destination folder but I always get message like '0 files copied' or 'parameters not recognized'. What I did was goto Start window and typed 'cmd' at the bottome of the window, which brought me to a black screen like a...

Hello, Sometimes I need to change system date on a Windows 7 system. Or I need to make the changes manually. Can someone help me out there? Do I need help from API? I doubt it. Many Thanks In Advance. Regards.

Hello folks, Long time no talk. Hope you're all doing well. I have a workbook with a few tabs. I want to check first to see if the summary column is already there or not. If it is there, then exit sub or run another sub to create that column. The code is like the following: Sub FindNCO()...

Hello folks, Long time no talk. Hope you're all doing well. I have a workbook with a few tabs. I want to check first to see if the summary column is already there or not. If it is there, then exit sub or run another sub to create that column. The code is like the following: Sub FindNCO()...