Common Dialog Control

  • Thread starter Thread starter doco
  • Start date Start date
D

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
 
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...
 
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
 
Hey, thanks. This got me to thinking and found the following:

Application.GetOpenFilename

Which allows me then to initialize a variable szPath.

doco
 
Back
Top