Getting a full FilePath from a user

[paulo33]

Does anybody know how to get a valid, full filepath from a user. i.e. Getting the user to browse through the 'SaveAs' dialog box, chose an appropiate file, and that the chosen file is returned as a full-filepath, not just a file name.

thanks

 

[VBslammer]

What program are you working with?

The easiest way to get a filename is to use the MSComDlg.ocx CommonDialog control which returns a 'FileName' containing the full path and file name the user selected.

If you're trying to use office automation then you can capture events by using a class module.

Give us a little more info.
VBSlammer

Unemployed in Houston, Texas

 

[RobBroekhuis]

Both the Application.GetSaveAsFilename and Application.GetOpenFileName methods return the full path, and are very easy to use. I don't know if they are available in every VBA-enabled application, but they should be there in all MSOffice applications.
Rob