Vba Vbe export

[Coby]

Does anyone know how to remove the entire vba project (vbe) from one
workbook?

Then, load it into another workbook on its workbook open event?

Thanks for any help you could give me.

Coby.

 

[Gord Dibben]

The VBAProject is the workbook and I don't believe you can remove a workbook
from a workbook.

You could remove Modules from the VBAProject then add them to another workbook.

Chip, or is it Chuck<g> Pearson has instructions for adding/deleting modules.

http://www.cpearson.com/excel/vbe.aspx


Gord Dibben MS Excel MVP

 

[Coby]

Does anyone know how to remove the entire vba project (vbe) from one
workbook?

Then, load it into another workbook on its workbook open event?

Thanks for any help you could give me.

Coby.

O.k. that is a wealth of information and I appreciate it.
Thanks,

Coby.