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.
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.
Bookmarks