Have a look at Chip Pearson's site (
http://www.cpearson.com/excel/vbe.aspx).
He has got some good clues on programing at the vbe editor level. There is
definitely an .addreferences method in the VBE command set. You may be able
to set up a loop that programmatically opens each file then redefines the
reference.
--
Ken
"Using Dbase dialects since 82"
"Started with Visicalc in the same year"
"Patrick Molloy" wrote:
I don't think its possible because the compiler would break.
Why not just rename the original referenced file -- as backup- and rename
the new file with the original file referenced name?
"Gustaf" wrote:
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
.