Thread: run macro for all files in directory - error in my code
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
cass calculator cass calculator is offline
external usenet poster
  
Posts: 42
Default 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

Reply With QuoteReply With Quote