Background:
I generate a lot of spreadsheets by exporting from Reporting Services reports with bookmarks. (The project to deploy Reporting services has been delayed but I still need to send out the reports....)
These reports start with a navigation page with hyperlinks to different worksheets. However when SSRS exports the reports each worksheet is simply called sheet1, sheet2, sheet3 ...
Objective;
I want to have a macro that changes the names of the worksheets to reflect the text of the hyperlinks. I want to store this macro in a 'master' workbook (or module or bas file) but I don't want to have to open the master or include the bas in the generated file. Is this possible.
(I'm not looking for help on writing the macro - yet) just an understanding of how to run a remote macro without embedding it.
I generate a lot of spreadsheets by exporting from Reporting Services reports with bookmarks. (The project to deploy Reporting services has been delayed but I still need to send out the reports....)
These reports start with a navigation page with hyperlinks to different worksheets. However when SSRS exports the reports each worksheet is simply called sheet1, sheet2, sheet3 ...
Objective;
I want to have a macro that changes the names of the worksheets to reflect the text of the hyperlinks. I want to store this macro in a 'master' workbook (or module or bas file) but I don't want to have to open the master or include the bas in the generated file. Is this possible.
(I'm not looking for help on writing the macro - yet) just an understanding of how to run a remote macro without embedding it.
