Dear All:


I have following task but don't know how to get it done in VBA:

I created a few data listings in a EXCEL file - each listing is a
worksheet in this file. Every worksheet/listing has its own formatting
(basically the fonts, sizes and widths of each column) and I can
create different VBA macros to do formatting for every worksheet. My
question is: how can I create a VBA macro in PERSONAL.XLS to
automatically finish these steps (if this is possible):

1) open this EXCEL file
2) open each worksheet by its name, one by one
3) call formatting VBA macro for this active sheet and run it
(of course, these formatting macros will all be stored in
PERSONAL.XLS)
4) after finishing the formatting for active worksheet, go to next one
and do the same thing until all formatting is done
5) close EXCEL file and exit

The reason I want to get everything done from one VBA macro in
PERSONAL.XLS is that programs in other languages can use DDE to run
this macro.

Thank you very much for any information or sample codes to do similar
functions.


Y. Lin

You need to go through the sheets collection. Examples are in
http://www.mvps.org/dmcritchie/excel/collections.htm
and in
http://www.mvps.org/dmcritchie/excel...#sortallsheets

Try recording a macro to get the code for the other parts..
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"ylin" wrote in message om...
Dear All:


I have following task but don't know how to get it done in VBA:

I created a few data listings in a EXCEL file - each listing is a
worksheet in this file. Every worksheet/listing has its own formatting
(basically the fonts, sizes and widths of each column) and I can
create different VBA macros to do formatting for every worksheet. My
question is: how can I create a VBA macro in PERSONAL.XLS to
automatically finish these steps (if this is possible):

1) open this EXCEL file
2) open each worksheet by its name, one by one
3) call formatting VBA macro for this active sheet and run it
(of course, these formatting macros will all be stored in
PERSONAL.XLS)
4) after finishing the formatting for active worksheet, go to next one
and do the same thing until all formatting is done
5) close EXCEL file and exit

The reason I want to get everything done from one VBA macro in
PERSONAL.XLS is that programs in other languages can use DDE to run
this macro.

Thank you very much for any information or sample codes to do similar
functions.


Y. Lin