Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have searched through many examples but cannot locate what I need.
1) I have a file "Invoice Template.xls" (WB1). Within it is a sheet named "Invoice". 2) I have a file "Master List.xls" (WB2). Within it is a sheet named "All Invoices". From a macro called CloseXLS in WB1, I need to run a macro in WB2 called SortList. This must sort the "All Invoices" sheet within WB2. I then need to return control back to the initial macro CloseXLS to complete its work. Within my CloseXLS macro I have tried the code... Application.Run "Master Invoice List.xls'!SortList" I cannot get it to work. I am not worried about the sort code just how to call from the WB1 macro to execute another macro in WB2 against WB2. How can this be accomplished? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
AutoRun Macro with a delay to give user the choice to cancel the macro | Excel Programming | |||
Macro not showing in Tools/Macro/Macros yet show up when I goto VBA editor | Excel Programming | |||
how to count/sum by function/macro to get the number of record to do copy/paste in macro | Excel Programming | |||
macro to delete entire rows when column A is blank ...a quick macro | Excel Programming | |||
Start Macro / Stop Macro / Restart Macro | Excel Programming |