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 Outputing Excel Module Codes

Is there a easy way (code) to output all the codes in a
given project to a file (for Excel 2000) ? I am presently
doing it semi-manually via the "file export" command
available in Excel visual basic editor with the help of a
sendkey code ! Still not effective and clean.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7,247
Default Outputing Excel Module Codes

Leo,

See the "Exporting All File In A Project" section at
http://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 easy way (code) to output all the codes in a
given project to a file (for Excel 2000) ? I am presently
doing it semi-manually via the "file export" command
available in Excel visual basic editor with the help of a
sendkey code ! Still not effective and clean.



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
Map module in Excel Richard Charts and Charting in Excel 4 November 11th 09 03:25 AM
CLASS MODULE & SIMPLE MODULE FARAZ QURESHI Excel Discussion (Misc queries) 1 September 7th 07 09:32 AM
How do I unlock a module in Excel? frustrated nun Excel Discussion (Misc queries) 2 August 26th 06 05:01 PM
code in module A to not execute a Worksheet_SelectionChange sub of another module Jack Sons Excel Discussion (Misc queries) 4 December 11th 05 11:52 PM
Variable from a sheet module in a class module in XL XP hglamy[_2_] Excel Programming 2 October 14th 03 05:48 PM


All times are GMT +1. The time now is 10:53 PM.

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"