Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel & Custom Menus
I have a question: I opened an Excel file made by a co-
worker that used some custom menus. Now, every time I open ANY Excel file, I get the following: "Unable to load Application.COMAddIns.Item ("PPCMenu.dsrPPCMenuExcel").object.clsMenuManag er" It does not occur when I open Excel. Only when I open an Excel file. I have uninstalled and reinstalled Excel to no avail. Do you have any clue as to where this "need" for this file resides on my PC? Even if you don't know precisely how to fix it, if you can tell me how to characterize the problem, that would help me search the Microsoft knowledge base better. Can you tell I am frustrated? Thanks, Stuart |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel & Custom Menus
This looks like a COM object - like an ActiveX control
that was registered on the original creator's PC but isn't on yours. Try going to the IDE, then under TYolls/References look to see if any are marked as 'Missing:' If there is one, then if you need it, you need to install the object - get the guy who made it to install it for you. If you don't need it, then you'll need to isolate & remove any refrences in code to it. Remember that it may alos be an object on a sheet or a form. HTH Patrick Molloy Microsoft Excel MVP -----Original Message----- I have a question: I opened an Excel file made by a co- worker that used some custom menus. Now, every time I open ANY Excel file, I get the following: "Unable to load Application.COMAddIns.Item ("PPCMenu.dsrPPCMenuExcel").object.clsMenuManager " It does not occur when I open Excel. Only when I open an Excel file. I have uninstalled and reinstalled Excel to no avail. Do you have any clue as to where this "need" for this file resides on my PC? Even if you don't know precisely how to fix it, if you can tell me how to characterize the problem, that would help me search the Microsoft knowledge base better. Can you tell I am frustrated? Thanks, Stuart . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel & Custom Menus
-----Original Message----- This looks like a COM object - like an ActiveX control that was registered on the original creator's PC but isn't on yours. Try going to the IDE, then under TYolls/References look to see if any are marked as 'Missing:' If there is one, then if you need it, you need to install the object - get the guy who made it to install it for you. If you don't need it, then you'll need to isolate & remove any refrences in code to it. Remember that it may alos be an object on a sheet or a form. HTH Patrick Molloy Microsoft Excel MVP -----Original Message----- I have a question: I opened an Excel file made by a co- worker that used some custom menus. Now, every time I open ANY Excel file, I get the following: "Unable to load Application.COMAddIns.Item ("PPCMenu.dsrPPCMenuExcel").object.clsMenuManage r" It does not occur when I open Excel. Only when I open an Excel file. I have uninstalled and reinstalled Excel to no avail. Do you have any clue as to where this "need" for this file resides on my PC? Even if you don't know precisely how to fix it, if you can tell me how to characterize the problem, that would help me search the Microsoft knowledge base better. Can you tell I am frustrated? Thanks, Stuart . . Patrick, thanks for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 - Custom menus is missing! | Excel Discussion (Misc queries) | |||
Please Help Me with Custom menus | Excel Worksheet Functions | |||
Copy Excel Custom Menus to New Computer | Excel Discussion (Misc queries) | |||
Custom menus | Excel Programming | |||
Excel.xlb and Custom Menus | Excel Programming |