Common Dialog Control

[doco]

I would like to know if there is a canned control in Excel (2000) that is
equivalent to the VB6.0 CommonDialog. Or if there is a work around
(UserForm). Not everyone I send templates/Add-ins to has this OCX.

TIA
doco

[Jim Thomlinson]

Let me know if this is kind of what you were thinking...

Application.Dialogs(xlDialogSaveAs).Show

There are a number of different dialogs to choose from and they each take
arguments...
--
HTH...

Jim Thomlinson


"doco" wrote:

> I would like to know if there is a canned control in Excel (2000) that is
> equivalent to the VB6.0 CommonDialog. Or if there is a work around
> (UserForm). Not everyone I send templates/Add-ins to has this OCX.
>
> TIA
> doco
>
>
>

[Robin Hammond]

Doco,

not as far as I know. There tend to be workarounds to some simple things.
j-walk has a colour picker for example, or you can code a browse for
directory using win Api calls.

I tend to package it in an installer if I need it for a project.

Robin Hammond
www.enhanceddatasystems.com

"doco" <perdedor@centurytel.net> wrote in message
news:e7DIi64%23FHA.3464@TK2MSFTNGP15.phx.gbl...
>I would like to know if there is a canned control in Excel (2000) that is
>equivalent to the VB6.0 CommonDialog. Or if there is a work around
>(UserForm). Not everyone I send templates/Add-ins to has this OCX.
>
> TIA
> doco
>

[doco]

Hey, thanks. This got me to thinking and found the following:

Application.GetOpenFilename

Which allows me then to initialize a variable szPath.

doco

"Jim Thomlinson" <jamest@tcgiRe-Move-This.com> wrote in message
news:1D85F391-7B18-47DE-A1BF-588D9876F3A3@microsoft.com...
> Let me know if this is kind of what you were thinking...
>
> Application.Dialogs(xlDialogSaveAs).Show
>
> There are a number of different dialogs to choose from and they each take
> arguments...
> --
> HTH...
>
> Jim Thomlinson
>
>
> "doco" wrote:
>
>> I would like to know if there is a canned control in Excel (2000) that is
>> equivalent to the VB6.0 CommonDialog. Or if there is a work around
>> (UserForm). Not everyone I send templates/Add-ins to has this OCX.
>>
>> TIA
>> doco
>>
>>
>>