But the OP did seem to ignore that part of your post.

Tom Ogilvy wrote:

I didn't exlude essential content!!

--
Regards,
Tom Ogilvy

"Dave Peterson" wrote in message
...
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" wrote in message
...
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

--

Dave Peterson