save and closing when hyperlink accessed

[Ouka]

Hi all,

I have a master spreadsheet that creates formated .xls sheets from a
hidden and read-only .xls master template by opening the template, save
as, and closeing the file.

On the mastersheet, a hyperlink is created to the newly created page.

I want to add a save and close action when the hyperlink is clicked on,
such that the master sheet is saved and closed, and the linked xls file
is opened.

Haven't had much luck in doing this yet however. Tried a variety of
methods, none of which have worked for me.

Anyone know of a way to make this work?

 

[Ouka]

anyone? This is driving me bonkers!

Or, is there way to pass the value of a variable between workbooks? I
think I could come up with a round-about means of acheiving what I want
to happen.

(basically thinking of doing a on workbook activate, change the active
workbook back to the master, save and close it. But that would require
a variable to be passed first elsewise the user will experience an error
if they open the hyperlinked file directly from windows)