Stead
07-02-2005, 02:46 PM
hi, i've been looking for ages on the internet, i've discovered (well told on a forum) how to run a vba macro from a vb application, now i would like to know if its possible to do it the other way round,
currenty i've been using the appactivate command in excel and using the sendkeys to send a letter accross, this results in the application having a case select code on keydown on the form, the problem is this seems random with its reliability, and i've noticed certain worksheet functions won't allow it work (been having a lot of problems with code i've written in the worksheet_before close, which brings me onto my next post...)
I was wondering if anyone knew of away to do this? i have a feeling there isn't without being a pro at these things which i am not! but maybe one day :cloud9:
currenty i've been using the appactivate command in excel and using the sendkeys to send a letter accross, this results in the application having a case select code on keydown on the form, the problem is this seems random with its reliability, and i've noticed certain worksheet functions won't allow it work (been having a lot of problems with code i've written in the worksheet_before close, which brings me onto my next post...)
I was wondering if anyone knew of away to do this? i have a feeling there isn't without being a pro at these things which i am not! but maybe one day :cloud9: