topic Re: in VBA Forum

Windows Common control

Anonymous — Tue, 13 Mar 2001 12:26:37 GMT

having heck trying to use the windows common controls to use the showopen to
get a filename, but can't get it to work. Which file do I need to add a
reference to? There are multiple mscom files. Help.

Troy

Re: Windows Common control

Anonymous — Tue, 13 Mar 2001 13:19:46 GMT

Microsoft Windows Common Controls 6.0 is in C:\WINDOWS\SYSTEM\MSCOMCTL.OCX,
but the file open dialog is in Microsoft Common Dialog Control 6.0 (SP3)
C:\WINDOWS\SYSTEM\Comdlg32.ocx. Help file for the latter is in
C:\WINDOWS\HELP\CMDLG98.CHM.
--
John Goodfellow
irtf'nm
use 'microtouch' in address to email

"Troy Sigwing" wrote in message
news:A159B7FEC1D167B253BD78279D3AB9FD@in.WebX.maYIadrTaRb...
> having heck trying to use the windows common controls to use the showopen
to
> get a filename, but can't get it to work. Which file do I need to add a
> reference to? There are multiple mscom files. Help.
>
> Troy
>

Re:

Anonymous — Tue, 13 Mar 2001 14:16:38 GMT

Unfortunately I get a message saying my help file is corrupt. When I
located it manually, I could open it, but cannot get to any of the linked
info, especially the examples. If anyone would be so kind as to post it
here...

eternally grateful

Troy

"John Goodfellow" wrote in message
news:D5825105E2B21D2DEB018AAB84881C01@in.WebX.maYIadrTaRb...
> Microsoft Windows Common Controls 6.0 is in
C:\WINDOWS\SYSTEM\MSCOMCTL.OCX,
> but the file open dialog is in Microsoft Common Dialog Control 6.0 (SP3)
> C:\WINDOWS\SYSTEM\Comdlg32.ocx. Help file for the latter is in
> C:\WINDOWS\HELP\CMDLG98.CHM.
> --
> John Goodfellow
> irtf'nm
> use 'microtouch' in address to email
>
> "Troy Sigwing" wrote in message
> news:A159B7FEC1D167B253BD78279D3AB9FD@in.WebX.maYIadrTaRb...
> > having heck trying to use the windows common controls to use the
showopen
> to
> > get a filename, but can't get it to work. Which file do I need to add a
> > reference to? There are multiple mscom files. Help.
> >
> > Troy
> >
>

Re: Windows Common control

Anonymous — Tue, 13 Mar 2001 14:43:59 GMT

The problem is that I don't have any forms to drop the commondialog control
onto, I am just writing a module, and I am going to load it into a button.
When the user clicks the button this program will run, and part of it needs
to activate the windows open dialog box, but I don't know how to do it
without the commondialog control. I guess windows API here I come.

"Troy Sigwing" wrote in message
news:A159B7FEC1D167B253BD78279D3AB9FD@in.WebX.maYIadrTaRb...
> having heck trying to use the windows common controls to use the showopen
to
> get a filename, but can't get it to work. Which file do I need to add a
> reference to? There are multiple mscom files. Help.
>
> Troy
>

Re:

Anonymous — Tue, 13 Mar 2001 14:56:13 GMT

Troy,

Why not just add a form to your project, which you can drop the common
dialog control onto, without ever making the form visible?

Andrew Wilford
www.artwork.com

Re:

Anonymous — Wed, 14 Mar 2001 04:11:00 GMT

On Tue, 13 Mar 2001 14:43:59 -0800, "Troy Sigwing"
wrote:

»The problem is that I don't have any forms to drop the commondialog control
»onto, I am just writing a module, and I am going to load it into a button.
»When the user clicks the button this program will run, and part of it needs
»to activate the windows open dialog box, but I don't know how to do it
»without the commondialog control. I guess windows API here I come.

Visual Basic Common Control API Routines
Using the GetOpenFileName Common Dialog API
<>

--
Paul Marshall
pmarshal@vulcraft-al.com

Re:

Anonymous — Wed, 14 Mar 2001 07:58:14 GMT

Ok, I loaded it, but how do I get it to display the standard windows file
open dialog box? when I try to use it I get:

GetOpenFileName.GetOpenFileName

and I don't know what it is looking for after the last GetOpenFileName

Thanks again, I feel like such an idiot.

Troy
"Paul Marshall" wrote in message
news:5tnuat8h2vf0n22gj32cu2l4pb77t0g7j0@4ax.com...
> On Tue, 13 Mar 2001 14:43:59 -0800, "Troy Sigwing"
> wrote:
>
> »The problem is that I don't have any forms to drop the commondialog
control
> »onto, I am just writing a module, and I am going to load it into a
button.
> »When the user clicks the button this program will run, and part of it
needs
> »to activate the windows open dialog box, but I don't know how to do it
> »without the commondialog control. I guess windows API here I come.
>
> Visual Basic Common Control API Routines
> Using the GetOpenFileName Common Dialog API
> <>
>
> --
> Paul Marshall
> pmarshal@vulcraft-al.com

Re:

Anonymous — Wed, 14 Mar 2001 08:14:07 GMT

Finally found the soloution I was looking for at http://www.acadx.com/

"Troy Sigwing" wrote in message
news:A59154C557A4375E0BD4C29224E4E2CC@in.WebX.maYIadrTaRb...
> Ok, I loaded it, but how do I get it to display the standard windows file
> open dialog box? when I try to use it I get:
>
> GetOpenFileName.GetOpenFileName
>
> and I don't know what it is looking for after the last GetOpenFileName
>
> Thanks again, I feel like such an idiot.
>
> Troy
> "Paul Marshall" wrote in message
> news:5tnuat8h2vf0n22gj32cu2l4pb77t0g7j0@4ax.com...
> > On Tue, 13 Mar 2001 14:43:59 -0800, "Troy Sigwing"
> > wrote:
> >
> > »The problem is that I don't have any forms to drop the commondialog
> control
> > »onto, I am just writing a module, and I am going to load it into a
> button.
> > »When the user clicks the button this program will run, and part of it
> needs
> > »to activate the windows open dialog box, but I don't know how to do it
> > »without the commondialog control. I guess windows API here I come.
> >
> > Visual Basic Common Control API Routines
> > Using the GetOpenFileName Common Dialog API
> > <>
> >
> > --
> > Paul Marshall
> > pmarshal@vulcraft-al.com
>

Re:

Anonymous — Wed, 14 Mar 2001 08:17:24 GMT

On Wed, 14 Mar 2001 07:58:14 -0800, "Troy Sigwing"
wrote:

»Ok, I loaded it, but how do I get it to display the standard windows file
»open dialog box? when I try to use it I get:
»
»GetOpenFileName.GetOpenFileName
»
»and I don't know what it is looking for after the last GetOpenFileName

OK, now I'm confused.

Somewhere in your code, you should have something like:

Dim OFN As OPENFILENAME

With OFN
.nStructSize = Len(OFN)
'fill other needed elements of OFN

End With

If GetOpenFileName(OFN) Then
'success... process the returned file name(s)

End If

If you're wanting a class which encapsulates this stuff, try this one
from From A.C.A.D (<>)

FileDialog.cls
<>

--
Paul Marshall
pmarshal@vulcraft-al.com