PDA

View Full Version : MS Project Application.FileDialog



NathanWright
04-12-2011, 08:59 AM
I am attempting to use the application.filedialog object to allow a user to select a folder. I do this quite often in other Office application VBA projects.

Unfortunately it appears that winproj's application object doesn't support the filedialog method (despite the help files containing the same examples from other office apps).

Does anyone know of a way to prompt the user with the filedialog object to browse for a folder in MSP? If not (ie it's not possible) are there any clever work arounds?

I'm using MSP Pro 2007 sp2 on Windows 7.

Thanks.

NathanWright
04-12-2011, 07:09 PM
Solved. I have to use the windows api. I found this helpful...

... or not. I do not have enough posts to include a link. So for anyone who finds this and needs the same answer, go research SHBrowseForFolderA.

Chabu
04-24-2011, 04:50 AM
If you have a reference to the Office library (its there by default) you should be able to do the following

Dim fd As FileDialog
Set fd = Application.FileDialog(msoFileDialogFolderPicker)

GROOKNET
03-31-2012, 07:31 AM
Thank you for problem and the solution