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.

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.

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.

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.