If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
usnig the std open dialog in Visio VBA code
How can I make use of the common dialogs (i.e std open file etc) in a Visio
VBA project when there is not a form in view as the active window? I an writing things into a DLL (using the flow chart demo as a starting point) and while some of my process steps do have forms, some other steps do not. In such a case how to I create a reference to the Microsoft Windows Common Controls (SP6) |
#2
|
|||
|
|||
usnig the std open dialog in Visio VBA code
Solved. It looks like one can drop a reference on any form in the design
and thereby get a global reference that works elsewhere in the project. You also need to use the right control, i.e. Microsoft Common Dialog Control 6.0 (SP6) not the one I mentioned. You can then add a line like: Dim CommonDialog1 As CommonDialog in your routine and you are back in biz. DCK |
#3
|
|||
|
|||
usnig the std open dialog in Visio VBA code
Sorry, but that still does not work, the ref is no good. In order to make
it all work I needed to create a "fake" dummy form to contain the common dialog control and then use it through that. DCK |
#4
|
|||
|
|||
usnig the std open dialog in Visio VBA code
I used to use these
visApp.Application.DoCmd(visCmdFileSave) for the embedded ones. I eventually moved on to just referencing the Excel libraries which gave me access to the Office routines that are referenced in the help files. The exposure is that you have now created a requirement for the user of your DLL to have Office installed (the same one that you developed with). When I get into any new bind with VB I go check Randy Birch's site (vbnet.mps.org) al "DC Kelley" wrote in message ... Solved. It looks like one can drop a reference on any form in the design and thereby get a global reference that works elsewhere in the project. You also need to use the right control, i.e. Microsoft Common Dialog Control 6.0 (SP6) not the one I mentioned. You can then add a line like: Dim CommonDialog1 As CommonDialog in your routine and you are back in biz. DCK |
Thread Tools | |
Display Modes | |
|
|