Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with getsaveasfilename | Excel Discussion (Misc queries) | |||
Help with GetSaveAsFilename | Excel Programming | |||
GetSaveasFileName | Excel Programming | |||
GetSaveAsFileName | Excel Programming | |||
GetSaveAsFilename | Excel Programming |