Call Macros that are not in the current or any open workbook

obiron

Active Member
Joined
Jan 22, 2010
Messages
469
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.
 

Some videos you may like

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

Watch MrExcel Video

Forum statistics

Threads
1,099,113
Messages
5,466,746
Members
406,495
Latest member
Arlind Elezi

This Week's Hot Topics

Top