Sort several workbooks using code

  • Thread starter Thread starter gotroots
  • Start date Start date
G

gotroots

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?
 
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 ?
 
Your suggestion is a help for sure, might be the solution for this task.

Thank you
Gotroots
 
Back
Top