How to copy macro to another workbook with VBA

[mcp21x]

Hi,

I am trying to write VBA routine from workbook "A" which will copy the VBA subroutines to a workbook "B" (Module 2 in my code). I then want to create a button in Workbook B and assign one of the macro's copied over to this button.

I currently have the following code which does almost everything I want, but it uses the macro from the original (workbook A) module.

Please Login or Register  to view this content.

How do i get the macro button to use the local module, not the original module? Note, the new workbook is created dynamically so its name will vary (Stored in "outputWB" in my code).

Thanks in advance for any assistance.

[venkat1926]

one way of doing it is parking the macro in personal.xls file which always opens but hidden whehever an excel file is opned. In that macro regarding the workbook(file)name you put an input box to specify the filename whenever you use the macro in ANY file or workbook. do you get me.