Excel 2003 VBA: Outlook 2003 Error loading DLL

Spurious

Active Member
Joined
Dec 14, 2010
Messages
439
Hi guys,

I got the following code:

Code:
Dim OlApp As Outlook.Application
Dim oMAPI As Outlook.Namespace
Dim oMainFolderName As String
Dim oParentFolder As Outlook.MAPIFolder
Dim oDraftFolderName As String
Dim oDraftFolder As Outlook.MAPIFolder

Set OlApp = New Outlook.Application
Set oMAPI = OlApp.GetNamespace("MAPI")
Set oParentFolder = oMAPI.Folders(oMainFolderName)
Set oDraftFolder = oParentFolder.Folders(oDraftFolderName)

It doesnt work in 2003, but works in 2010.

What's the problem here?
I get an error 48: Error loading DLL


What's the problem here?

Thanks in advance.
 

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"
I am still investigating the problem, it's absurd.
I've tried coping my working DLL to the other computer, but to no avail.
 
Upvote 0
I'm not familiar with doing this, but my guess would be something that excel 2010 has, 2003 does not. There is most likely another way this has to be done in 2003 to fit in with what the libraries have that is handled differently (or newly available) in 2010.
 
Upvote 0
DLL Errors are most likely system related, I got one more thing I need to check, but if this doesnt work, I am at a complete loss.
 
Upvote 0

Forum statistics

Threads
1,214,414
Messages
6,119,375
Members
448,888
Latest member
Arle8907

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top