How to update Macros from Master Macro?

  • Thread starter Thread starter Joe HM
  • Start date Start date
J

Joe HM

Hello -

I was wondering if there is a way to write a macro that imports updated
macros into the current Workbook?

I have played with VBProject.VBComponent as follows ...

lWB.VBProject.VBProject.VBComponents.Import YYY

The WWW file I created by exporting the code from Sheet1 of my Master
Macro.

Whenever I do the Import it adds the code under Class Modules instead
of replacing the code under Microsoft Excel Objects/Sheet1.

Is there a way that I can actually load a macro to be in the Sheets or
ThisWorkbook or will I have to move all of my code to a Module and put
"call Module1.XXX" calls in the X_Click() event handlers of my Sheet?

Thanks,
Joe

Thanks,
Joe
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

OnTime Change_Event macro AND copy to sheet2 macro trouble 7
Run Macro on All Sheets Q 8
Run two macros for two different sheets 11
Re: Reference must be to a macro sheet? 0
Macro to delete macro? 4
i need 1 macro button in master file to refresh data from all files 0
Macro to Combine Data from Multiple Sheets with Cell References 4
How to Run a Macro From WB1 in WB2 Against WB2 5

Back
Top