Re: How to set file Filter in Save dialog box

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: "Harald Staff" <innocent@xxxxxxxxxxxxx>
Date: Mon, 31 Jul 2006 14:49:54 +0200

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" <sreenath205.2bszd7_1154338102.0805@xxxxxxxxxxxxxxxxxxxxx>
skrev i melding
news:sreenath205.2bszd7_1154338102.0805@xxxxxxxxxxxxxxxxxxxxxxxx

Hi All

I have a button in one of my ***,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?action=getinfo&userid=35663

View this thread: http://www.excelforum.com/showthread.php?threadid=566541

References:
- How to set file Filter in Save dialog box
  - From: sreenath205

Prev by Date: RE: wildcard
Next by Date: Run-Time error, type Mismatch
Previous by thread: How to set file Filter in Save dialog box
Next by thread: Re: Help - Send mail from Excel
Index(es):
- Date
- Thread