GetSaveAsFilename
 

Hello Everybody,
I have MS Excel 2003 Pro.

Do I need some kind of reference to a library checked before I could use
GetSaveAsFilename? I am getting Run-time error '1004'.

Thhank you,
--
Syed Zeeshan Haider


------------------------------------------------------------
Learn about famous muslim names at http://szh.20m.com/learn/aboutnames.html

GetSaveAsFilename
 

No it is standard excel dialog, you must have the parameters set
incorrectly. Post your code for further advice.

--
Cheers
Nigel



"Syed Zeeshan Haider" wrote in message
...
Hello Everybody,
I have MS Excel 2003 Pro.

Do I need some kind of reference to a library checked before I could use
GetSaveAsFilename? I am getting Run-time error '1004'.

Thhank you,
--
Syed Zeeshan Haider


------------------------------------------------------------
Learn about famous muslim names at
http://szh.20m.com/learn/aboutnames.html

GetSaveAsFilename
 

No additional libraries need be referenced. GetSaveAsFilename is native to
Excel.

What code is causing the error? The following works for me:

Dim FName As Variant
FName = Application.GetSaveAsFilename("Book11.xls", _
"Excel Workbooks (*.xls),*.xls")
If FName = False Then
MsgBox "User clicked cancel."
Else
MsgBox "User choose: " & FName
End If


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)



"Syed Zeeshan Haider" wrote in message
...
Hello Everybody,
I have MS Excel 2003 Pro.

Do I need some kind of reference to a library checked before I could use
GetSaveAsFilename? I am getting Run-time error '1004'.

Thhank you,
--
Syed Zeeshan Haider


------------------------------------------------------------
Learn about famous muslim names at
http://szh.20m.com/learn/aboutnames.html