Problem with file links changing

W

Wes_A

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.
 
W

Wes_A

Ok, is there any way to automate that so that the correct source is
maintained or updated?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Embedded Excel into Word with Tables 0
Working outlook via vba code with xlsx - error 0
Create a dynamic master file 1
Format change in merge data - Bold formatting after a comma 0
Word 365 is saving great to Dropbox, but upon rebooting next day, Word does not show the file I last saved. 0
Images are pixelated when saving to PDF 0
Sub projects added as read only in Master file which are saved on sharepoint 1
New computer, how do i move outlook 365 ENTIRELY? 0

Top