View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
goshute goshute is offline
external usenet poster
 
Posts: 19
Default SaveAs dialog argument for file type

See if this will work for you:

Sub SelectSaveFileName()
Dim TheFile As Variant
TheFile = Application.GetSaveAsFilename("C:\Temp\File.xlt", "Template
(*.xlt), *.xlt", , "Your choice:")
If TheFile = False Then
MsgBox "You cancelled"
Else
MsgBox "Do something with file " & CStr(TheFile)
End If
End Sub

Goshute