Outlook Application object visibility issue

[malik641]

Hey Guys

Can someone explain to me why I get an error when trying to show an instance of outlook from excel? I get an "Object doesn't support this property or method" error in this code (bolded where the error is):

[vba]Sub test1()
Dim objOL As New Outlook.Application
objOL.Visible = True
Set objOL = Nothing
End Sub[/vba]
I can get it to work like this:

[vba]Sub test1()
Dim objOL As Variant
objOL = Shell("Outlook.exe", vbMaximizedFocus)
End Sub[/vba]
Why won't it work the first way? I have the reference set in the VBE...

[malik641]

Oh yeah, and to further note...it won't work using late binding either:
[VBA]
Sub test1()
Dim objOL As Object
Set objOL = CreateObject("Outlook.Application")
objOL.Visible = True
Set objOL = Nothing
End Sub[/VBA]

[Killian]

Hi Joseph,

The error object doesn't lie (at least not in this case). Strange tho it may seem, the Outlook application object doesn't have a Visible property.
("Strange" doesn't adequately describe it, does it?)

There is always the "Display" property, which you're probably familiar with as applied to mail items etc. but also applies to folders, so displaying the Inbox for example, will show the main application window[VBA]Dim objOL As New Outlook.Application
Dim ns As Namespace
Dim fldr As MAPIFolder

Set ns = objOL.GetNamespace("MAPI")
Set fldr = ns.GetDefaultFolder(olFolderInbox)
fldr.Display[/VBA]

[malik641]

Thanks Killian I see how I can get Outlook to show itself now.

You know, you would think that maybe outlook didn't have a Visible property for a specific reason...but I can't think of why

Anybody have any suggestions?