Dear all,
a macro has many sheets, forms and modules; and each one of them contains
some codings, i want to know how to save all the codings (inside the same
excel file) in one single txt file.
Would you pls help? Thanks.

Why not Export all Modules to your Hard Drive.



--
Regards
Dave Hawley
www.ozgrid.com
"Mak" wrote in message
...
Dear all,
a macro has many sheets, forms and modules; and each one of them contains
some codings, i want to know how to save all the codings (inside the same
excel file) in one single txt file.
Would you pls help? Thanks.

Export all modules will create multiple text files. i had one excel file
with macros, it contains many sheets, forms and modules. i have made some
changes in codings and create a new excel file.
Two years late, there are several excel files, i want to know what exactly i
changes in the past 2 years and thus i am asking an easy way to output all
codes in an excel files to one single text file. Then I may compare these
several text file to find the difference in codings.
Thanks.

"ozgrid.com" wrote:

Why not Export all Modules to your Hard Drive.



--
Regards
Dave Hawley
www.ozgrid.com
"Mak" wrote in message
...
Dear all,
a macro has many sheets, forms and modules; and each one of them contains
some codings, i want to know how to save all the codings (inside the same
excel file) in one single txt file.
Would you pls help? Thanks.

Hmmm,

how about this:
1) export all modules of the excel file into one folder
2 ) from the command line (aka DOS Window)
COPY "c:\My_folder_with_the_text_files\*.*"
"c:\destination_Folder\Version1.txt"
this will combine all files into one file.
Repeat this for all excel files you want to compare.

Helmut.


"Mak" schrieb im Newsbeitrag
...
Export all modules will create multiple text files. i had one excel file
with macros, it contains many sheets, forms and modules. i have made some
changes in codings and create a new excel file.
Two years late, there are several excel files, i want to know what exactly i
changes in the past 2 years and thus i am asking an easy way to output all
codes in an excel files to one single text file. Then I may compare these
several text file to find the difference in codings.
Thanks.

"ozgrid.com" wrote:

Why not Export all Modules to your Hard Drive.

Thanks but your method still require to export all modules individually (many
sheets, forms and modules) to a text file first, then merge them to one
single.

If there is no direct way to do so. Is it a good idea to write a new Excel
macro to search all sheets, forms and modules, see if any codes inside, if
yes then copy the codes and paste it in a NotePad?

But I don't know the code to search all sheets to see if any codes inside,
could you please help?
Thanks.


"Helmut Meukel" wrote:

Hmmm,

how about this:
1) export all modules of the excel file into one folder
2 ) from the command line (aka DOS Window)
COPY "c:\My_folder_with_the_text_files\*.*"
"c:\destination_Folder\Version1.txt"
this will combine all files into one file.
Repeat this for all excel files you want to compare.

Helmut.


"Mak" schrieb im Newsbeitrag
...
Export all modules will create multiple text files. i had one excel file
with macros, it contains many sheets, forms and modules. i have made some
changes in codings and create a new excel file.
Two years late, there are several excel files, i want to know what exactly i
changes in the past 2 years and thus i am asking an easy way to output all
codes in an excel files to one single text file. Then I may compare these
several text file to find the difference in codings.
Thanks.

"ozgrid.com" wrote:

Why not Export all Modules to your Hard Drive.




.

See Chip Pearson's site.

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

Scroll down about half way and see.........

Exporting A VBComponent Code Module To A Text File


Gord Dibben MS Excel MVP

On Thu, 29 Apr 2010 21:30:01 -0700, Mak
wrote:

Thanks but your method still require to export all modules individually (many
sheets, forms and modules) to a text file first, then merge them to one
single.

If there is no direct way to do so. Is it a good idea to write a new Excel
macro to search all sheets, forms and modules, see if any codes inside, if
yes then copy the codes and paste it in a NotePad?

But I don't know the code to search all sheets to see if any codes inside,
could you please help?
Thanks.


"Helmut Meukel" wrote:

Hmmm,

how about this:
1) export all modules of the excel file into one folder
2 ) from the command line (aka DOS Window)
COPY "c:\My_folder_with_the_text_files\*.*"
"c:\destination_Folder\Version1.txt"
this will combine all files into one file.
Repeat this for all excel files you want to compare.

Helmut.


"Mak" schrieb im Newsbeitrag
...
Export all modules will create multiple text files. i had one excel file
with macros, it contains many sheets, forms and modules. i have made some
changes in codings and create a new excel file.
Two years late, there are several excel files, i want to know what exactly i
changes in the past 2 years and thus i am asking an easy way to output all
codes in an excel files to one single text file. Then I may compare these
several text file to find the difference in codings.
Thanks.

"ozgrid.com" wrote:

Why not Export all Modules to your Hard Drive.




.