Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calling macros in another workbook
G'Day. I am beating my head against a brick wall with this problem. I have
probably overlooked something simple soI hope someone can help me. I am using a main workbook to automate functions in another workbook to return data. I have both workbooks open and I need to call a macro in the secondary workbook to manipulate data in the secondary workbook. I activate the secondary workbook I then use the application.run method as follows: Application.Run ("C:\DBModuleRelated\OtherSQL\PHI200580309(RASD)\R elative Value Tool v 2.4 1-06-06.xls!Reset_to_Plan_Assumptions") I then get the error message "Macro not found" I have tried referencing the module that the macro is in as well but still no go - what am I missing? Cheers |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calling macros in another workbook
Make sure that workbook is open first and don't use the full path in your
application.run line: application.run _ "'relative value tool v 2.4 1-06-06.xls'!reset_to_Plan_assumptions Nick Wright wrote: G'Day. I am beating my head against a brick wall with this problem. I have probably overlooked something simple soI hope someone can help me. I am using a main workbook to automate functions in another workbook to return data. I have both workbooks open and I need to call a macro in the secondary workbook to manipulate data in the secondary workbook. I activate the secondary workbook I then use the application.run method as follows: Application.Run ("C:\DBModuleRelated\OtherSQL\PHI200580309(RASD)\R elative Value Tool v 2.4 1-06-06.xls!Reset_to_Plan_Assumptions") I then get the error message "Macro not found" I have tried referencing the module that the macro is in as well but still no go - what am I missing? Cheers -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto updating a workbook with data from another workbook | Excel Discussion (Misc queries) | |||
Removing macros from workbook | Excel Discussion (Misc queries) | |||
Macros for Protect/Unprotect all sheets in a workbook | Excel Discussion (Misc queries) | |||
Unprotect Workbook | Excel Discussion (Misc queries) | |||
can a workbook with macros created in excel 2003 work in excel 20. | Excel Discussion (Misc queries) |