Office Automation w/o interference

[Robert Chapman]

Hi,

I've been running some VBA in Access to open Excel and perform a number of
operations. In the past, it has always been the case that while the code is
running you shouldn't click the mouse anywhere or change the open window to
avoid generating an error. However it is suddenly working so that you can do
whatever you want in any open application and the routine will continue,
which is extremely useful. On transferring the routine to another PC it
works in the old way. How do you set this behaviour up to occur?!

TIA,

Rob

 

[Graham R Seach]

Robert.

Try this:
http://www.pacificdb.com.au/MVP/Code/BlockUserInput.htm

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

 

[Robert Chapman]

Thanks for this Graham but how do you think it is working in this way on my
PC? I can work away in any program I like without affecting the carrying out
of the code and I can even make changes in Excel while the routine is working
without upsetting it! I haven't programmed it to do so so there must be some
setting that is active.....?

Really keen to know what this is...

Thanks,

Robert

 

[Graham R Seach]

Robert,

Sorry, on re-reading your original post, it seems I misunderstood what you
wanted.

I'm afraid I don't have an answer for you. I'd suggest you ask the same
question in one of the Excel groups. I know many of the people there do a
lot of Excel VBA work, and many of them frequently automate Excel from
Access. With their unique knowledge of Excel, I'm sure they can shed some
light on the problem.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------