Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
.OnAction points to wrong file.module.procedure
I have a problem with a reference for the .OnAction of a command bar button.
There are two excel workbooks open. One is an XLA that is the code for the other workbook. In each workbook there is a module called reports and a sub called GenerateReports. The full index to the code is Reports.GenerateReports The workbooks are names. Plan1.xls PlanCode.xla The OnAction is set to the code below: .. OnAction = PlanCode.xla!Reports.GenerateReports The problem is that the code that is being run is. Plan1.xls!Reports.GenerateReports not the .XLA file. I cant seem to run the code in the xla version or Reports.GenerateReports Other considerations: The .xla file has the property isAddIn is set to true. Thus the workbook in not visible. I would also prefer not to rename either Module.Procedure name I am running Office10 (Excel XP) Any thought/solutions would be appreciated -- Stewart Rogers DataSort Software, L.C. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
to call procedure in a worksheet in a module | Excel Discussion (Misc queries) | |||
Add Procedure To Module Via VBA | Excel Programming | |||
OnAction procedure | Excel Programming | |||
programmatically open VBE and go to a specified procedure in target module? | Excel Programming | |||
Lines in a Module(Procedure) | Excel Programming |