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

Hi

Try using
Application.GetSaveAsFilename
instead of that dialog, you have no control of how that one turns out. See
Help for detail.

HTH. Best wishes Harald

"sreenath205"
skrev i melding
...

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