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

 

[Guest]

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...

 

[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]

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

Application.GetOpenFilename

Which allows me then to initialize a variable szPath.

doco