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

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - VBA Syntax to :select" or activate a module in Project Explorer (https://www.excelbanter.com/excel-programming/379496-vba-syntax-select-activate-module-project-explorer.html)

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

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

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

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

Dennis wrote:
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