ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Vba Vbe export (https://www.excelbanter.com/excel-programming/404893-vba-vbe-export.html)

Coby

Vba Vbe export
 
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

Vba Vbe export
 
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

On Wed, 23 Jan 2008 14:33:21 -0800 (PST), Coby
wrote:

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.



Coby

Vba Vbe export
 
On Jan 23, 2:33*pm, Coby wrote:
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.


All times are GMT +1. The time now is 08:50 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com