"Rich P" <rpng123@[EMAIL PROTECTED]
> wrote in message
news:1210086523_11990@[EMAIL PROTECTED]
>I have writtens lots of multi threaded programs. The only way you can
> do it in VBA is like this:
>
> "It can't be done!"
I for the most part 100% agree with the above.
> If what I say was not true
> and correct, I would have disappeared a long time ago - from attrition -
Your claim about VBA and threading is 100% correct. however, you claim of
to
quote:
>The functionality you are trying to achieve with your code is not
sup****ted in VBA because it requires a multithreaded environment which
would involve programming in an Object Oriented Programming platform
You DO NOT need to adopt a OOP platform to get threading. Without question
*most* modern development systems that supprot oop *useally* also sup****t
threading, but, your above claim says that you **have** to use a OOP
system
to get multithread enviroment is wrong. I was simply pointing out that
these
are two mutually exclusive issues, and are not related to each other. Once
again, you do not necessarily have to adopt a oop language to get
multithreading capability.
>The limitation of Interpreted programming
code is that you can't perform OOP operations.
Once again I said the above is incorrect, and there are many interpreted
languages is today that are full oop. And, I pointed out that in fact the
..net environment relies on a p-code runtime system, very similar to that
of
the vba. (and I believe on windows mobile, and also the XNA system for
xbox,
there is no JIT either).
I was never questioning you're correct suggestion that threading in VBA is
silly, and the wrong tool and one is barking up the wrong tree to attempt
threading in VBA. Once again, I wholeheartedly agree with you on this
issue.
It is silly and simply not the realm of VBA to write and build threaded
applications.
I should further point out that if I'm reading the original poster's
question correctly, he does not need threading as a solution anyway...
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@[EMAIL PROTECTED]


|