Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run macro in workbook from PERSONAL.XLS
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Personal Macro Workbook | Excel Worksheet Functions | |||
Personal macro workbook and personal.xls | Excel Discussion (Misc queries) | |||
Personal.XLS MACRO Workbook | Excel Programming | |||
personal macro workbook | Excel Programming |