Run macro in workbook from PERSONAL.XLS
dim wkbk as workbook
set wkbk = activeworkbook
application.run "'" & wkbk.name & "'!hide_loan_lines"
You could drop the variable stuff, too:
application.run "'" & activeworkbook.name & "'!hide_loan_lines"
But I like the variable.
Brettjg wrote:
Hello out there,I'm running a macro from PERSONAL.XLS and from there I want
to run a macro that resides in the Activeworkbook (which has a variable
name). I've tried a few different combinations but can't quite get it right.
Application.Run (ActiveWorkbook("HIDE_LOAN_LINES"))
Regards, Brett
--
Dave Peterson
|