Thread: Running Macros
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default Running Macros

hi,
is the other workbook open. if not then the macro will be
unavailable.
if is is open then try activing the workbook before you
pass the parameter to it.

workbooks(workbookname.xls).activate

-----Original Message-----
I am relatively new to VBA in Excel and am having

trouble.
I am trying to call a macro in another workbook and pass

a
parameter to that macro. Help does not provide a
reasonable explanation or Example to follow. I would
appreciate any help I can get in solving this problem!

TIA

Steve
.