Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Running macro on multiple files
I posted this earlier on an old thread, but I guess it doesn't bump the old
thread for people to see. I hope I'm not breaking any rules or whatever, so please ignore this post if I am. Thanks, Matt Alok, I've tried your code on one of my macros, but I cannot seem to get it to work. I have tons of runlogs that are generated and would like to implement your code. The runlogs are incremented by *.L0, *.L1, *.L2, etc. where the number could be anywhere between 0 to 10. What did I do wrong in the code below? If I step through the code, it just goes right over the While loop, even if I do change a few files to *.xls. I made sure that C:\Temp\Temp1 is where my files are. Thanks, <3 Matt Sub ProcessAllFiles() Dim sFile$ Const path = "C:\Temp\Temp1\" sFile = Dir(path & "*.*") Do While sFile < "" Workbooks.Open (path & sFile) HELO_Macro ActiveWorkbook.Close savechanges:=True sFile = Dir Loop End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Running Macro on many files | Excel Programming | |||
Files won't open after running a macro | Excel Programming | |||
Running a macro on mulitple files | Excel Programming | |||
opening multiple files using VB and running a mcaro in excel | Excel Programming | |||
Import multiple files macro can't find files | Excel Programming |