Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with file links changing
Good day all. Excel 2007.
I have a number of workbooks in memory some having file links referencing a data file also in memory. I have code which firstly saves the current data file (constantly updating) at month end run and then "Saves As" to another directory with a different file name. It then closes the new file and re-opens the original so that processing can continue for the new month. However, my problem is that all files with links to the original data file have now changed to reference the Saved As file!! e.g. VLookup and HLookup. I have tried various avenues but cannot get the links to remain as refrence to the current file. If anyone can help with this problem it will be greatly appreciated. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with file links changing
Edit Links (on data tab) and Change Source.
-- Regards Dave Hawley www.ozgrid.com "Wes_A" wrote in message ... Good day all. Excel 2007. I have a number of workbooks in memory some having file links referencing a data file also in memory. I have code which firstly saves the current data file (constantly updating) at month end run and then "Saves As" to another directory with a different file name. It then closes the new file and re-opens the original so that processing can continue for the new month. However, my problem is that all files with links to the original data file have now changed to reference the Saved As file!! e.g. VLookup and HLookup. I have tried various avenues but cannot get the links to remain as refrence to the current file. If anyone can help with this problem it will be greatly appreciated. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with file links changing
Ok, is there any way to automate that so that the correct source is
maintained or updated? "ozgrid.com" wrote: Edit Links (on data tab) and Change Source. -- Regards Dave Hawley www.ozgrid.com "Wes_A" wrote in message ... Good day all. Excel 2007. I have a number of workbooks in memory some having file links referencing a data file also in memory. I have code which firstly saves the current data file (constantly updating) at month end run and then "Saves As" to another directory with a different file name. It then closes the new file and re-opens the original so that processing can continue for the new month. However, my problem is that all files with links to the original data file have now changed to reference the Saved As file!! e.g. VLookup and HLookup. I have tried various avenues but cannot get the links to remain as refrence to the current file. If anyone can help with this problem it will be greatly appreciated. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with file links changing
Not that I know of.
-- Regards Dave Hawley www.ozgrid.com "Wes_A" wrote in message ... Ok, is there any way to automate that so that the correct source is maintained or updated? "ozgrid.com" wrote: Edit Links (on data tab) and Change Source. -- Regards Dave Hawley www.ozgrid.com "Wes_A" wrote in message ... Good day all. Excel 2007. I have a number of workbooks in memory some having file links referencing a data file also in memory. I have code which firstly saves the current data file (constantly updating) at month end run and then "Saves As" to another directory with a different file name. It then closes the new file and re-opens the original so that processing can continue for the new month. However, my problem is that all files with links to the original data file have now changed to reference the Saved As file!! e.g. VLookup and HLookup. I have tried various avenues but cannot get the links to remain as refrence to the current file. If anyone can help with this problem it will be greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with links form a word file to excel graphs | Links and Linking in Excel | |||
Problem opening excel file with links | Excel Discussion (Misc queries) | |||
Automatically Changing File Links | Excel Discussion (Misc queries) | |||
Edit Links: Changing links on a protected worksheet | Excel Discussion (Misc queries) | |||
Problem changing open file from R/0 to R/W | Excel Programming |