VBA Syntax to :select" or activate a module in Project Explorer

D

Dennis

2003

Using a macro to save certain modules displayed in Project Explorer.

Yey I cannot figure out the VBA code to "activate" those different
ThisWorkBook modules so that I can issuse the command hisWorkBook.Save
= all done with VBA.

TIA

EagleOne
 
D

Dennis

For those wishing to save your .xla files using VBE, the following
worked for me:

Workbooks("YourAddin.xla").Activate
Workbooks("YourAddin.xla").IsAddin = False
Workbooks("YourAddin.xla").Save
Workbooks("YourAddin.xla").IsAddin = True

Dennis
 

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

Similar Threads

VBA word change keys 0
Excel 2003 - VBA to get a list of Module names in the project 4
VBA Editor Window(s) size challenge 9
Excel 2007 - VBA Password Input shows after Excel is closed 3
How to show slide objects in the VBA Editor 2
Changing Codename in VBA 3
closing a vba project - dumb question 2
Cannot display Add-in Macro list without going to VBA/Project 5

Top