View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
GEdwards GEdwards is offline
external usenet poster
 
Posts: 40
Default How to Run a Macro From WB1 in WB2 Against WB2

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?