How do I break links on workbook after saved in subfolder

[tweacle]

Hi

I was given this macro and ive amended but just trying to finish off.


It saves the active workbook as a copy called summary1.xls in a new subfolder created. What im trying to do is break the links in the new summary1.xls after it saved to new location.


Can this be done?

Please Login or Register  to view this content.

[Richard Buttrey]

Hi

Data------Edit Links-----Break Links

Incidentally, would you add your Location and Software versions. It's often helpful when we need to consider stuff like regional settings and date formats.

[MatrixMan]

Try:

Please Login or Register  to view this content.

where FullPathAndFileName is the path & file name of the file you reference ... so T:\Passenger ... etc etc ... plus the \filename.

MM.