![]() |
Excel Macro will not allow references
I have an issue where excel will not allow me to add references to my Macro.
The option is greyed out. I have Excel installed on a server along with outlook. In my Excel Macro, I reference the outlook library to create MAPI folders. It works fine on a regular account, but when logged on as a service account on this specific server, it will not run correctly because it does not recognize Outlook.MAPIFolder. This is because the reference is not there. I need to know how to get this refernence there to work. Thanks in advance. -- -Lee |
Excel Macro will not allow references
If I recall correctly using MAPI requires a reference to the CDO 1.2X
library, which is not part of the default Outlook install. You may need to go to outlook and have the componenet installed so that you can get to the object. -- HTH... Jim Thomlinson "Lee" wrote: I have an issue where excel will not allow me to add references to my Macro. The option is greyed out. I have Excel installed on a server along with outlook. In my Excel Macro, I reference the outlook library to create MAPI folders. It works fine on a regular account, but when logged on as a service account on this specific server, it will not run correctly because it does not recognize Outlook.MAPIFolder. This is because the reference is not there. I need to know how to get this refernence there to work. Thanks in advance. -- -Lee |
All times are GMT +1. The time now is 02:57 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com