Sort several workbooks using code
 

I am looking to run code that will sort several workbooks even when they are
closed. The code would be executed via a master workbook which will also be
sorted.
Is this possible?

Sort several workbooks using code
 

I'm not aware of sorting records in a CLOSED workbook, but what you can do
is this.

Create some button on the master workbook and let it open the other
workbook, sort the other workbook and close the other workbook.
Accompanied with Application.ScreenUpdating (but also depending on the
amount of records) you will hardly notice the sorting actions.

Does this help ?


--
Regards;
Mark Rosenkrantz
--
Spreadsheet Solutions
Uithoorn
Netherlands
--
E:
W: www.spreadsheetsolutions.nl

--
"gotroots" wrote in message
...
I am looking to run code that will sort several workbooks even when they
are
closed. The code would be executed via a master workbook which will also
be
sorted.
Is this possible?

Sort several workbooks using code
 

Your suggestion is a help for sure, might be the solution for this task.

Thank you
Gotroots

"Spreadsheet Solutions" wrote:

I'm not aware of sorting records in a CLOSED workbook, but what you can do
is this.

Create some button on the master workbook and let it open the other
workbook, sort the other workbook and close the other workbook.
Accompanied with Application.ScreenUpdating (but also depending on the
amount of records) you will hardly notice the sorting actions.

Does this help ?


--
Regards;
Mark Rosenkrantz
--
Spreadsheet Solutions
Uithoorn
Netherlands
--
E:
W: www.spreadsheetsolutions.nl

--
"gotroots" wrote in message
...
I am looking to run code that will sort several workbooks even when they
are
closed. The code would be executed via a master workbook which will also
be
sorted.
Is this possible?



.