View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default Changing references in a batch of files?

References are always to "another file". Depending on the type reference, ie
file, it might be easy, unreliable, or impossible. Describe "another file".

Regards,
Peter T

"Gustaf" wrote in message
...
Hi all,

I got a large number of Excel files, all with a reference (in the VBA
editor) to another file. I wonder if it's possible to programmatically
change the reference in all files, to save the repetitive work of changing
each manually?

Gustaf