Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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) |