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...![]()