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
.
|