Check Query Status

[modest]

Hmm, I'm curious why yours did not work the same. I still have the lngAddr, and am still passing the addressof by value (from the onclick sub). I don't know why it didn't work on yours. Maybe because I'm running WinXPro w/ 2003 ... and you're running something different? In either case, the variable should still work the same as the actual function call because the values should be the same.

ANYHOW... despite the error after the code window appears, this is exactly what I needed and I'm going to use this code, in lieu of all the other suggestions. I thank you all for your help, especially my man John.

All the suggestions were valid, I just think it's more accurate (and useful) to know exactly when a window closes. And John, since you seem to be knowledgable about API calls, I'm sure you know how much I appreciate getting that window handle and having a wiindowproc to work with.

Furthermore, Do you know if it's possible to actually define the proc, or do I have have to use VBAs stagnant/default proc? This is more of a trivial question then something I'm going to use (because I have no use for it as of yet). I will be around if you guys have any questions for me ---


Thank you all again,
Modest

 

[john471]

Hmm, I'm curious why yours did not work the same. I still have the lngAddr, and am still passing the addressof by value (from the onclick sub). I don't know why it didn't work on yours.

I don't understand why either, I just know that it did not work one way, and did work the other. I would expect it should work both (either) way.

Maybe because I'm running WinXPro w/ 2003 ... and you're running something different? In either case, the variable should still work the same as the actual function call because the values should be the same.

I mostly use WIN2K / AC97 (@office) (hence original solution with API calls to get procedure address in lieue of using AddressOf operator), but have WINXP Pro, SP2 / AC 2003 (Office 2003 Professional) (@home) (where I was using AddressOf operator solution). I have no explanation

Furthermore, Do you know if it's possible to actually define the proc, or do I have have to use VBAs stagnant/default proc?

I don't know; in fact I don't understand your question; but that's probably because....

I've had a foray into APIs (I'm still an extreme novice at using APIs) in search of an answer to the more interesting challenge.

Good luck with it.

Regards

John.