| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Common Dialog control | Excel Programming | |||
| Common dialog control | Excel Programming | |||
| Microsoft Common Dialog Control | Excel Programming | |||
| Cannot get Common Dialog Control to work | Excel Programming | |||
| Excel 97 - Common Dialog Control Help | Excel Programming | |||
![doco[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
