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

Hi Joe

See
http://www.cpearson.com/excel/vbe.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Joe HM" wrote in message oups.com...
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

Great ... Thanks!

Joe