Excel - GetSaveAsFilename - Is there an equivalent in Access

[Guest]

In excel I use the follwing code:

fLog = Application.GetSaveAsFilename(InitialFileName:="Extract_log.txt", _
fileFilter:="Text Files (*.txt), *.txt")
If fLog = False Then
MsgBox "Log file has not been provided. Processing Cancelled."
Exit Sub
End If

open fLog for output as #20
....

This is an easy way to create a new file and gives the user the flexibility
to control the filename and location in Excel. Is there an equivalent
function in Access?

Thanks in advance!

Guy Normandeau

 

[Allen Browne]

Use this API call:
Call Windows File Open/Save Dialog box
at:
http://www.mvps.org/access/api/api0001.htm

 

[Guest]

The best way is to use the File Open/Save Dialog API. See this site:
http://www.mvps.org/access/api/api0001.htm