ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Referenced File (https://www.excelbanter.com/excel-programming/372620-referenced-file.html)

Shawn

Referenced File
 
Is it possible to write a code that will map one .xls file to another .xls
file by referencing it? I have a file that references another file but it
sometimes becomes "unreferenced". Others use this file, too. I would like a
code that would re-establish the reference?????



--
Thanks
Shawn

Tom Ogilvy

Referenced File
 
http://support.microsoft.com/kb/213529/en-us
how to programmatically create a reference

--
Regards,
Tom Ogilvy


"Shawn" wrote:

Is it possible to write a code that will map one .xls file to another .xls
file by referencing it? I have a file that references another file but it
sometimes becomes "unreferenced". Others use this file, too. I would like a
code that would re-establish the reference?????



--
Thanks
Shawn


NickHK

Referenced File
 
Shawn,
Do you mean the files are "linked" ?
If so, go to EditLinks.. and see the options there.

NickHK

"Shawn" wrote in message
...
Is it possible to write a code that will map one .xls file to another .xls
file by referencing it? I have a file that references another file but it
sometimes becomes "unreferenced". Others use this file, too. I would

like a
code that would re-establish the reference?????



--
Thanks
Shawn





All times are GMT +1. The time now is 01:51 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com