Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
lee lee is offline
external usenet poster
 
Posts: 184
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,119
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
worksheet references for a macro and VBA [email protected] Excel Discussion (Misc queries) 6 February 3rd 09 08:49 AM
Macro to Formula References K1KKKA Excel Discussion (Misc queries) 4 December 18th 06 10:27 PM
Macro without cell references...... Winnie_Shrub Excel Discussion (Misc queries) 1 June 28th 06 09:09 AM
How do I create a macro, that references another excel file ??? Aries Excel Worksheet Functions 1 May 25th 05 11:37 AM
macro vba relative references aut1jlt Excel Worksheet Functions 0 April 20th 05 06:13 PM


All times are GMT +1. The time now is 06:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"