Macro that opens file from location, strips links and saves to new location

Hi,

I currently have a macro button in a load of files that when clicked, cements the links in the file and then saves to 3 separate locations with varying filenames.

I need to create a macro which when ran, will open the file and run said prior macro.

It's the initial opening and running that i am struggling with, as i can get my macro to open a file, but then i still have to run the macro on each sheet individually.


Any help or pointers i how to open and run a macro on that opened file would be greatly appreciated.


Alex

Bump .