Hi,
I have the following code which works fine if run when the file is open:
It copies 2 sheets out of the source workbook and breaks links thus removing external references. However when I run this via an auto-open macro the break link doesn't work.
I would be eternally grateful if anyone could shed any light on why and what I can do about it?
ActiveWorkbook.Save
MyFile = ThisWorkbook.FullName
Sheets(Array("DENOMINATION - VOLUME SUMMARY", "DENOMINATION - VALUE SUMMARY")). _
Select
Sheets("DENOMINATION - VALUE SUMMARY").Activate
Sheets(Array("DENOMINATION - VOLUME SUMMARY", "DENOMINATION - VALUE SUMMARY")). _
Copy
ActiveWorkbook.BreakLink Name:= _
MyFile _
, Type:=xlExcelLinks
Yours in anticipation,
Ickle Lynnie
I have the following code which works fine if run when the file is open:
It copies 2 sheets out of the source workbook and breaks links thus removing external references. However when I run this via an auto-open macro the break link doesn't work.
I would be eternally grateful if anyone could shed any light on why and what I can do about it?
ActiveWorkbook.Save
MyFile = ThisWorkbook.FullName
Sheets(Array("DENOMINATION - VOLUME SUMMARY", "DENOMINATION - VALUE SUMMARY")). _
Select
Sheets("DENOMINATION - VALUE SUMMARY").Activate
Sheets(Array("DENOMINATION - VOLUME SUMMARY", "DENOMINATION - VALUE SUMMARY")). _
Copy
ActiveWorkbook.BreakLink Name:= _
MyFile _
, Type:=xlExcelLinks
Yours in anticipation,
Ickle Lynnie