ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Exporting Excel VB code (https://www.excelbanter.com/excel-programming/284318-exporting-excel-vbulletin-code.html)

Leo

Exporting Excel VB code
 
Is there a simple way (through code) to export all VB code
in a given project (in excel 2000) ? I have a lot of
sheets and modules which have code and exporting them one
by one via VB editor is very time consuming. HELP !

Chip Pearson

Exporting Excel VB code
 
Leo,

See www.cpearson.com/excel/vbe.htm

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Leo" wrote in message
...
Is there a simple way (through code) to export all VB code
in a given project (in excel 2000) ? I have a lot of
sheets and modules which have code and exporting them one
by one via VB editor is very time consuming. HELP !




Leo

Exporting Excel VB code
 
Mr. Pearson

Thank you for your help. Much appreciated and an eye
opener (great !) site that you have.

Leo

-----Original Message-----
Leo,

See www.cpearson.com/excel/vbe.htm

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Leo" wrote in message
...
Is there a simple way (through code) to export all VB

code
in a given project (in excel 2000) ? I have a lot of
sheets and modules which have code and exporting them

one
by one via VB editor is very time consuming. HELP !



.



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

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