Ps to Tom only. Others shouldn't read this message!

I think I misunderstood your use of "white space". I thought that you were
saying that the original code did too much stuff (a gentle poke if you will). I
really didn't think you meant it in terms of application.trim() to clean up the
string (since I had used it as well).

And on a much more serious note: Will Washington have a professional football
team this year <gd&r?



Dave Peterson wrote:

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

--

Dave Peterson

--

Dave Peterson