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.

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

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" <[email protected]> wrote in message
news:[email protected]...
> 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.
>