itchymonkey
-
Posts
2 -
Joined
-
Last visited
Content Type
Profiles
Forums
Events
Posts posted by itchymonkey
-
-
hi,
i'm very new to macro express.
would like to ask
If i have 10 files in a folder.
one.xls
two.xls
three.xls..... so on
I would like to find a way to repeat the process (using excel to open):- to open the 1st file and type some text, save, continue with the 2nd file. (i wan the mouse to know which file i have copied and continue the next one till all files have been done.)
Thanks in advance for any help.
loop files in a folder
in Macro Express 3.x
Posted
hi thanks for the response.
actually what i want is to know how to write a macro that can loop through the files in a directory.
"open file window" to get file name and continue with other macro steps.
(the part which mouse cursor move up and down in open file window and stop macro when everything finished.)
--------------------------------------
I've tried 'repeat folder' codes.
It will loop through all files but its more like a a screenie of all files.
I would like to run one file each time.