I have a VBA Word Project, which opens another Word document and exports a module from one project to another. When I run the macro while within the VBE (i.e., by clicking Run Sub/User Form button), it works fine, but when I try to run the same macro from the Tool >Macro>Macros.., the export/import method doesn’t work properly – it does not export the module. The same happens, when I assign my macro to a command button located on the Word document and clicked that button.
Obviously, the “Trust access to Visual Basic Project” is checked and all required references are included (mainly, Microsoft Visual Basic for Application Extensibility).
Does anybody have any idea what is going on?
Thanks,
Chartar 0 Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.