Re: Microsoft Common Dialog control, version 6.0

No, not personally.

In that other thread, your approach seemed like a reasonable approach to me,
too. But then I thought if there was other stuff in that text (not always 4
numeric elements), then why revisit it again when the followup post showed up.

In fact, I used application.trim() in the "white space" suggestion <still--not
taken personally, but maybe my sense of humor is not coming through.>

And in this thread, it just looked to me like the OP was ignoring your first
suggestion out of hand. I was just trying to get him to review his
requirements.

Maybe I should have started with: "As Tom wrote, ...." just to make it clearer.


Tom Ogilvy wrote:

There's no accounting for taste. Why have a 4 element array with no loops
when you can have a 40 element array to loop through. Sounds like your
taking this personally. I was really just suggesting to use
application.Trim before split to eliminate all the wasted elements of the
array - seems reasonable to me.

--
Regards,
Tom Ogilvy

"Dave Peterson" <petersod@xxxxxxxxxxxxxxxx> wrote in message
news:450A0B6F.BF7B431C@xxxxxxxxxxxxxxxxxxx
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" <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

--

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
    ... Why have a 4 element array with no loops ... when you can have a 40 element array to loop through. ... Tom Ogilvy wrote: ... API to control the common file dialog. ...
    (microsoft.public.excel.programming)
  • Re: Microsoft Common Dialog control, version 6.0
    ... "Dave Peterson" wrote: ... Tom Ogilvy 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
    ... 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)