Universal open
Inside a folder, I have several workbooks that are linked. I have
recorded a macro to open them in sequence and it works fine, but I
does not work if I move the whole folder.
The code I use is -
Workbooks.Open Filename:= _
"xxx:xxx.xls"
How can I fix this? Is there a solution that will travel with the
location of the folder?
|