Save As Dialog (with FilePath and FileName suggested)

[walkest]

Hi,
I need to show the SaveAs dialog (in VBA) and pass 2 arguments into it.
E.G. I want to show the SaveAs dialog with the suggested FilePath pointing to "T:\IMPORT" and the suggested FileName as "[TodaysDate]_Export".
NB: I don't wish to proceed with the Save automatically, I want the user to be able to change the suggested options.
Stacey

 

[oharab]

Stacey,

Use this method:

Application.GetSaveAsFilename("T:\IMPORT" & format(date(),"yyyymmdd&quot & "_Export.xls", "Excel File (*.XLS), *.XLS", , "Choose a file name&quot

it returns the full path and filename if one was chosen or false if cancel was selected.

HTH

Ben ----------------------------------
Ben O'Hara
bo104@westyorkshire.police.uk
----------------------------------

 

[uberpudge]

Hi Stacey,

I started a similiar thread called &quot;How can I suggest a file name?&quot;. You should be able to read it here: <a href=thread707-264913 Hope this helps,
Pete