Hi Rick,

Thanks for the comments.

Most people who enquire on these boards are usually looking for a simple,
immediate solution to their current problem, they take it and then cut and
run (no criticism meant, just an observation). It is not so often that we
get people who are on a long journey of learning and improving. They can
usually be spotted by their frequency of return and the intelligence of
their questions (not just 'How do I get the sheet name in a cell?'), and it
is usually the most interesting and enlightening. It looks as though you are
well advanced on that journey, as we (hopefully) also are.

I like running Excel from VB under automation, although it is more work, and
expediency doesn't always allow that luxury.

Look forward to seeing you here some more.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Rick" wrote in message
...
Bob,

You are so correct. I've worked with one engineer, that
did all of his "programming" in Excel with formulas. I
tried to get him to switch to VBA programming, but with
his analytical mind, he was very happy to just stick with
formulas.

By the way, if you get a chance to read this, I want to
thank you so much in helping me develop my VBA programming
with VB6 (last year or so). Over the past year part time,
I've gone a lot further...with other people's help too.
I've got the form to stay on top with an API call. I
developed a lot of neat things here that many others
really don't know about. Again, I can't thank you
enough. Now, I don't have any of my VBA code on my
computer at work anymore...just my compilied executable
VB6 programs that interface with Excel. I'm still making
improvements. It works perfect, for what I need it to do.

Thanks, Rick