Prev: Delete all rows except
Next: how to create a hyperlink in excel for a private mortgage insuranc
From: Zahir on 6 Feb 2010 14:47
I wrote a macro by which I want the user to save the file with an extension
of *.xlt, I mean as a template. I don't how to show the template format in
the type box of SaveAs dialog. Can anybody help me.
From: goshute on 6 Feb 2010 15:02
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
 | 
Pages: 1
Prev: Delete all rows except
Next: how to create a hyperlink in excel for a private mortgage insuranc