Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SaveAs dialog argument for file type
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SaveAs wk3 file type error message | Excel Discussion (Misc queries) | |||
SaveAs dialog box | Excel Programming | |||
Can you Pre-fill file name in SaveAs dialog | Excel Worksheet Functions | |||
Built-in Dialog Box Argument Button | Excel Discussion (Misc queries) | |||
SaveAs dialog | Excel Discussion (Misc queries) |