Thread: How to set file Filter in Save dialog box
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sreenath205 sreenath205 is offline
external usenet poster
  
Posts: 1
Default How to set file Filter in Save dialog box

Hi All

I have a button in one of my sheet,when i click on it following macro
code is invoked

Code:
--------------------


Private Sub CommandButton3_Click()
Sheets("InputFile").Select
Application.Dialogs(xlDialogSaveAs).Show
End Sub


--------------------


Question: The dialog which opens up has filters like "All
files[*.*],Test[*.txt]" etc in fileType: filetr,how to restrict this
filter to *.txt" only?

Thanks
Sreenath M


--
sreenath205
------------------------------------------------------------------------
sreenath205's Profile: http://www.excelforum.com/member.php...o&userid=35663
View this thread: http://www.excelforum.com/showthread...hreadid=566541

Reply With QuoteReply With Quote