Linking Workbooks

[JamesPW]

Apologies if this is a duplicate

I have one workbook getting data from another- FileB (destination) imports data from FileA (source). Both files are in the same folder. This works fine EXCEPT when I make a copy of FileA using Save As to a different folder with a new Filename. Save As to NewFolder with NewFilename done by VBA.

FileA (source) Path:My Excel:FileA.xlsm
FileB (destination) Path:My Excel:FileB.xlsm
Copy of FileA is saved to Path:My Excel:Backups:FileA 12-5-18.xlsm. This part works fine EXCEPT-

The links in FileB change to the Path and Filename of the copy. I want them to stay the original path and filename.

Any ideas?

 

[Mentor82]

Hi,
Why don't you save the file at the main directory MyExcel and then copy it to the backup one?

Regards,
Sebastian

 

[JamesPW]

Hi,
Why don't you save the file at the main directory MyExcel and then copy it to the backup one?

Regards,
Sebastian

Doh! Should've thought of that. Works great, thanks

 

[Mentor82]

My pleasure!☺