Show Save As Dialog Box

R

Rummy

Please advise How can I show Excel Built in Save As Dialog
Box Progrmatically in VBA & let user exit if they cancel

Thanks in Advance
Rummy
 
D

dude

Help you require is in the VBA helpf file.
However, i have lifted extract for you:

Example
This example displays the Save As dialog box, with the
file filter set to text files. If the user chooses a file
name, the example displays that file name in a message
box.

fileSaveName = Application.GetSaveAsFilename( _
fileFilter:="Text Files (*.txt), *.txt")
If fileSaveName <> False Then
MsgBox "Save as " & fileSaveName
End If
 
Top