Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

FileDialog with MS Project

Status
Not open for further replies.

DrSimon

IS-IT--Management
Dec 14, 2001
674
GB
I can't get FileDialog to work with MS Project. The references are:
[tab]Visual Basic For Applications
[tab]OLE Automation
[tab]Microsoft Office 11.0 Object Library

But I keep getting the error 'Object doesn't support this property or method'. The code works fine in Excel or Access.
If it matters I'm running MS Project Professional 2003.

I want to use it with msoFileDialogFilePicker so I can select one or more file from the selected directory.
Failing that is there anything else I can do?

Thanks
 



Hi,

Can you find FileDialog in the Object Browser?

Do you have a reference set for the Microsoft Office Object Library?

Skip,
[glasses]Don't let the Diatribe...
talk you to death![tongue]

[glasses]Just traded in my old subtlety...
for a NUANCE![tongue]
 
Hi Skip
That was quick!

FileDialog in Object Browser: Yes
Reference for Library: 'Microsoft Office 11.0 Object Library' as given above

Extract of code:
Code:
    Dim fDialog As Office.FileDialog
    Set fDialog = Application.FileDialog(msoFileDialogFolderPicker)

Simon
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top