Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
Leo Leo is offline
external usenet poster
 
Posts: 2
Default 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 !
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7,247
Default 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 !



  #3   Report Post  
Posted to microsoft.public.excel.programming
Leo Leo is offline
external usenet poster
 
Posts: 3
Default 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 !



.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
exporting from SAP to Excel Monique Excel Discussion (Misc queries) 0 July 29th 08 06:36 PM
exporting from Excel PAG Excel Discussion (Misc queries) 2 November 12th 07 02:54 PM
Error Code 1004 when exporting from VB app to Excel 2007 sue mac Excel Discussion (Misc queries) 0 September 11th 07 08:10 AM
Exporting from ASP to excel Chris Excel Discussion (Misc queries) 0 August 22nd 06 02:36 PM
Exporting to Excel Grady Excel Discussion (Misc queries) 1 December 27th 05 07:24 AM


All times are GMT +1. The time now is 09:52 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"