GetSaveAsFilename

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Syed Zeeshan Haider - 08 Dec 2006 18:38 GMT

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,

Signature

Syed Zeeshan Haider

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

Reply to this Message

Nigel - 08 Dec 2006 18:50 GMT

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

Signature

Cheers
Nigel

> Hello Everybody,
> I have MS Excel 2003 Pro.
[quoted text clipped - 3 lines]
>
> Thhank you,

Reply to this Message

Chip Pearson - 08 Dec 2006 18:53 GMT

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

Signature

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

> Hello Everybody,
> I have MS Excel 2003 Pro.
[quoted text clipped - 3 lines]
>
> Thhank you,

Reply to this Message