Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dim Dim is offline
external usenet poster
 
Posts: 5
Default MAPI create object error

Hi,
i'm having problem with instantiating MAPISession object.. the code
works on my other desktop (desktop2) just fine.. both machines Win2K
and Excel 2K..

i deleted existing MSMAPI32.ocx from desktop1 and then dropped three
files copied from destop2 (msmapi32.dep, msmapi.srg, msmapi32.ocx) on
desktop1, registered ocx with regsvr32, made reference in excel to
that ocx file (Microsoft MAPI Controls 5.0 (SP2) but code generates
the err message that ActiveX can't be created..
I would think that ocx is corrupted but since it's the same file which
works perfectly on desktop2 i ran out of ideas why it behaives that
way...

here's two ways i tried to instantiate that object


Dim objMapiSession As New MAPISession
Dim objMapiMessage As MAPIMessages

With objMapiSession ( HERE ERR GENERATES)
blah, blah...
end with

i tried different way:
Dim objMapiSession As Object
Dim objMapiMessage As Object

Set objMapiSession = CreateObject("MSMAPI.MAPISession")( HERE ERR
GENERATES)
Set objMapiMessage = CreateObject("MSMAPI.MAPIMessages")


i checked newsgourps on that topic but could not find anything
helpful...
Would appreciate any help on it
thanks in advance
Dim
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
runtime error 429 when trying to create Inet object Radu[_2_] Excel Discussion (Misc queries) 0 April 15th 10 02:08 PM
Mapi problem Eison Excel Discussion (Misc queries) 0 June 24th 08 01:02 PM
Excel mail MAPI error DGardner Excel Discussion (Misc queries) 5 June 4th 08 01:58 PM
Macro to Create New Worksheet and Reference Cell in Old Worksheet As Tab Name - "Object Required" Error [email protected] Excel Discussion (Misc queries) 4 September 25th 06 01:35 PM
Object Variable Not Set Error on Selection object Jean Excel Worksheet Functions 3 July 24th 06 06:45 PM


All times are GMT +1. The time now is 06:52 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"