| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
run macro for all files in directory - error in my code
On May 11, 4:27 pm, David Sisson wrote:
On May 11, 12:58 pm, cass calculator wrote: Looks like you dropped this line off when merging the two files. Sub ChangeLinks() Set wbk = Workbooks("GrossAdds.xls") <<<--- yeah I did that because the first macro only words for a specific file and that line desginates the file. The second macro should set the workbook to whatever file is open in the for loop |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro - Open all word files in a directory | Excel Worksheet Functions | |||
| How do you run a macro on all files in a directory? | Excel Programming | |||
| Macro to move files from one directory to another | Excel Programming | |||
| Macro to enumerate subdirs and files in a directory! | Excel Programming | |||
| run macro for all files in the directory | Excel Programming | |||
Threaded Mode
