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

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

Top