Re: Microsoft Common Dialog control, version 6.0

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
.

Relevant Pages

  • Re: Microsoft Common Dialog control, version 6.0
    ... Tom Ogilvy wrote: ... API to control the common file dialog. ... Dave Peterson ...
    (microsoft.public.excel.programming)
  • Re: Show new pictures in image control
    ... Ahhh there was a space in the filename I didn't see - works great now. ... Add pictures to Access, ... based on the contents of a text box control that contains the path to ... VBA I get an error message which says that access can't open the ...
    (microsoft.public.access.forms)
  • Re: flv how to insert in Power Point 2007?
    ... One more point to add regarding the filename of the flv file. ... With the VLC Media Player installed, open PowerPoint. ... Now, right click on the control that has been added, select Properties. ...
    (microsoft.public.powerpoint)
  • Re: Microsoft Common Dialog control, version 6.0
    ... API to control the common file dialog. ... "Tom Ogilvy" wrote: ... if you must use the common controls, then use the Windows API to ...
    (microsoft.public.excel.programming)
  • Re: Validating a file name
    ... have no control over). ... Is there a package to check if the string is valid as a filename on the OS? ... However, in input validation, it's generally better to test for ... I tried this kind of validation, but it failed on my lack of knowledge (I didn't know exactly what characters are allowed in win filename). ...
    (comp.lang.perl.misc)