Re: Microsoft Common Dialog control, version 6.0

I didn't exlude essential content!!

--
Regards,
Tom Ogilvy



"Dave Peterson" <petersod@xxxxxxxxxxxxxxxx> wrote in message
news:4509FFC1.AE86E2E5@xxxxxxxxxxxxxxxxxxx
I was trying to ask the same question as your followup--with more white
space!

Tom Ogilvy wrote:

Wow. Deja Vu all over again

If I was suggesting that as a solution, I would suggest consulting the
help
so the OP knows they only return the selection and don't perform the
action.

--
Regards,
Tom Ogilvy

"Dave Peterson" <petersod@xxxxxxxxxxxxxxxx> wrote in message
news:4509F9C9.11348D1C@xxxxxxxxxxxxxxxxxxx
If you want to get a filename of an existing file (to open later?), use
application.getopenfilename().

If you want to get a filename to use when you save later, use
application.getsaveasfilename().

If you're doing one of these two, you'll be surprised how easy it'll
become.

Kevin E. wrote:

I'm extremely new to programming so I don't understand how to use the
Windows
API to control the common file dialog.

"Tom Ogilvy" wrote:

if you just want to show the file open or file saveas dialog use

application.GetOpenfileName()

application.GetSaveAsFilename()

instead.

see help for details.

if you must use the common controls, then use the Windows API to
control it
rather than the activex control.

--
Regards,
Tom Ogilvy


"Kevin E." wrote:

When working in VBA I try to add the Microsoft Common Dialog
Control
to my
toolbox but when I try to use it I get a message box telling me
"The
Control
Could Not Be Created Because It Is Not Properly Licensed". I
tried
searching
the Microsoft Knowledge Base and Found a utility to fix this in
VB6
but
didn't work in my situation becuase I don't have VB 6 installed,
just
the
VBA. Any thoughts, or suggestions would be greatly appreciated.
Thanks

--

Dave Peterson

--

Dave Peterson


.

Relevant Pages

  • Re: Microsoft Common Dialog control, version 6.0
    ... Tom Ogilvy wrote: ... "Dave Peterson" wrote: ... when you can have a 40 element array to loop through. ... API to control the common file dialog. ...
    (microsoft.public.excel.programming)
  • Re: Microsoft Common Dialog control, version 6.0
    ... "Tom Ogilvy" wrote: ... MsoFileDialogType can be one of these MsoFileDialogType constants. ... Microsoft Excel opens the file dialog allowing the user to ... VB 2005 has a OpenFileDialog option in the button control and I didn't see ...
    (microsoft.public.excel.programming)
  • Re: Microsoft Common Dialog control, version 6.0
    ... Tom Ogilvy wrote: ... when you can have a 40 element array to loop through. ... API to control the common file dialog. ... Dave Peterson ...
    (microsoft.public.excel.programming)
  • Re: Microsoft Common Dialog control, version 6.0
    ... MsoFileDialogType can be one of these MsoFileDialogType constants. ... VB 2005 has a OpenFileDialog option in the button control and I didn't see ... with the common dialog control. ... Tom Ogilvy wrote: ...
    (microsoft.public.excel.programming)
  • Re: Microsoft Common Dialog control, version 6.0
    ... "Tom Ogilvy" wrote: ... MsoFileDialogType can be one of these MsoFileDialogType constants. ... VB 2005 has a OpenFileDialog option in the button control and I didn't see ... "Dave Peterson" wrote: ...
    (microsoft.public.excel.programming)