Common Dialog Control
 

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

Common Dialog Control
 

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

Common Dialog Control
 

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" wrote in message
...
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

Common Dialog Control
 

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" wrote in message
...
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