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

Excel 2003 - VBA to get a list of Module names in the project 4
Changing Codename in VBA 5
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Cannot display Add-in Macro list without going to VBA/Project 5
Programmaticlly sign and password protect a VBA Project in Excel 2 6
Syntax to address ThisWorkbook.BuiltinDocumentProperties via Access Automation? 2
How with VBA, can I activate one of many modules in a VBAProject? 1
How to show slide objects in the VBA Editor 2

Top