Excel:Template with links, automate break link

[Larft]

I have an Excel workbook that I have automated with macros to copy two of the sheets out to a new workbook and then break the link and remove some formatting to retain just the data as a copy of the results in the parent workbook. All was fine until I set it up as a template on the network (which is necessary to share it simultaneously). When the macro runs I get errors for just about everything. I think this is all due to the state things are in at the moment, template opens as new workbook and any references to the original on the network are no longer valid.

Any help anyone has will be greatly appreciated.

Thanks in advance!

 

[SkipVought]

"When the macro runs I get errors for just about everything"

Sounds like this is a CODE question. Please post in VBA Visual Basic for Applications (Microsoft) forum707

Skip,

_[red][/red]