G Guest Dec 8, 2004 #1 I want to run a macro which I have written on about 67 excel files in one folder automatically. Is this possible? HOw?
I want to run a macro which I have written on about 67 excel files in one folder automatically. Is this possible? HOw?
D Dick Kusleika Dec 8, 2004 #2 Chris You can open each file in the folder using the Dir function. See here http://www.dicks-blog.com/archives/2004/04/15/the-dir-function/ Then run the macro and close the file.
Chris You can open each file in the folder using the Dir function. See here http://www.dicks-blog.com/archives/2004/04/15/the-dir-function/ Then run the macro and close the file.
