Filedialog: save

[way2bord]

What is the most effective way to open a standard save-dialog message box to allow end-user to enter path/filename?

Currently using:

set oDialog = Application.filedialog(2)

Given the above method, I am unable to add filters for the filetype (ie. when used it will always say "*.* | All"...

 

[rzw0wr]

Use an input box.

Dale

 

[way2bord]

Use an input box.

Dale

Strikes me as a much less effective method, unless there's an inputbox() gui I'm completely unfamiliar with?

the Filedialog is pretty much ideal, except for:
1) conflicts with early versions of references -- I'm not entirely sure where these are, but I know they exist.
2) FileType filters. ie. if they're saving an access file, instead of "*.*" I'd like to see a ".mde"

 

[rzw0wr]

Displays a prompt in a dialog box, waits for the user to input text or click a button, and returns a String containing the contents of the text box.
Syntax
InputBox(prompt[, title] [, default] [, xpos] [, ypos] [, helpfile, context])

InputBoxFunction
Dale