ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   a question about "Application.GetSaveAsFileName" (https://www.excelbanter.com/excel-programming/358763-question-about-application-getsaveasfilename.html)

12Keys

a question about "Application.GetSaveAsFileName"
 
Is this method available in Excel from versions 2000 onwards. I am
building an Excel app for a company, and can't remember what version of
Excel I am using (I know I should have checked first).

If not what would be an alternative? method of having a popup dialog
box? (Apart from xldialogSaveAs (spelling!??!) - which seems to be
totally unprogramable.


Dave Peterson

a question about "Application.GetSaveAsFileName"
 
Yep.

12Keys wrote:

Is this method available in Excel from versions 2000 onwards. I am
building an Excel app for a company, and can't remember what version of
Excel I am using (I know I should have checked first).

If not what would be an alternative? method of having a popup dialog
box? (Apart from xldialogSaveAs (spelling!??!) - which seems to be
totally unprogramable.


--

Dave Peterson

NickHK

a question about "Application.GetSaveAsFileName"
 
12Keys,
If that a problem, you could use the GetSaveFileName API which "Requires
Windows NT 3.1 or later; Requires Windows 95 or later".

NickHK

"12Keys" wrote in message
oups.com...
Is this method available in Excel from versions 2000 onwards. I am
building an Excel app for a company, and can't remember what version of
Excel I am using (I know I should have checked first).

If not what would be an alternative? method of having a popup dialog
box? (Apart from xldialogSaveAs (spelling!??!) - which seems to be
totally unprogramable.





All times are GMT +1. The time now is 09:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com