FileDialog

DaveInOhio · #1 11-20-2009, 01:52 PM

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

Code:

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

darbid · #2 11-24-2009, 09:06 AM

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.

DaveInOhio · #3 11-24-2009, 11:18 PM

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

Dave

Welcome to the Excel Forum

Forum Statistics