Open Save As Dialog in Code

  • Thread starter Thread starter Larry R Harrison Jr
  • Start date Start date
L

Larry R Harrison Jr

I have Excel 2003. I am trying to get code which will prompt the user to
save the currently open file as a tab-delimited file and give them the
option to name it.

Either that, or I want it to assign the current date and "warr" at the end
of it as the file name. Either way, it MUST be a tab-delimited txt file.

Tips?

LRH
 
Hi Larry,

Try this

filesavename = Application.GetSaveAsFilename( _
fileFilter:="Text Tab Delimited (*.txt), *.txt")
If filesavename <> False Then
ActiveWorkbook.SaveAs Filename:=filesavename
End If


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Best way to format a flat file that Excel will load properly? 8
Excel 2003 - Save as dialog box 9
Save As xls to text (tab delimited) in encoding utf-8 0
Import a comma delimited file & match records 3
'Save as' dialog opens despite Application.DisplayAlerts = False 6
Run-time error ‘13’ mismatch type 1
file save as dialog with new filename 13
Auto Open Macro of external .txt file based on cell reference 1

Back
Top