Prev: Find and Replace using a Loop won't stop
Next: Autofilter question
From: Bill on 26 Apr 2010 15:51
I know this is easy and I hope I am close. I want to open several files from
different folders. I kow the names of the files so this is what I have.

Workbooks.Open Filename:="Y:\folder\filename.xlsm"

When I run the macro it says file not found. Do I have to use the following
to change folders each time I am using a different folder?

ChDir "Y:\folder"


 | 
Pages: 1
Prev: Find and Replace using a Loop won't stop
Next: Autofilter question