Thread: Universal open
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Geri Geri is offline
external usenet poster
 
Posts: 3
Default 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?