macro to update another document's macro

R

raj

Is it possible to alter a macro of an another document/current document through a macro available in current document?
 
J

Jonathan West

raj said:
Is it possible to alter a macro of an another document/current document
Click to expand...
through a macro available in current document?

Hi Raj

Yes, it is possible. There are two relatively common methods

1. By using the OrganizerCopy method to copy a module or other project item
between documents.

2. By setting a reference in your project to Microsoft Visual Basic for
Applications Extensibility and manipulating the objects within the VBE
object hierarchy.
 
Top