Thread: FileDialog

I have done quite a bit of simple Office VBA programming, so I must be doing something silly and would sure appreciate some help to get past it.

From within Outlook (2003) I used Alt-F11 to start Microsoft Visual Basic.
The following sub

Sub test1()
    Dim Dialog As Office.FileDialog
    Set Dialog = Application.FileDialog(msoFileDialogFilePicker)
    MsgBox "did it"
End Sub

produces the error "Run-time error '438': Object doesn't support this property or method"

In the Tools>References dialog, the checked items are:

• Visual Basic for Applications
• Microsoft Outlook 11.0 Object Library
• Microsoft Office 11.0 Object Library
• Microsoft Excel 11.0 Object Libarry
• OLE Automation
• Microsoft Forms 2.0 Object Library

Can someone please tell me what I've missed?

Thanks!

Dave

pretty sure that from outlook you cannot use the file dialog.

Just initiate a Word application or Excel application and then initiate the file dialog that way.

Thanks! I created an Excel object and it works fine. I appreciate your help.

Dave