Using the Shell function

R

Richard John

I have an application that calls an Excel 2000 macro from within an Access
2000 procedure using the shell function. After Excel has finished, I have
programmed it to close, but am having difficulty getting Access to detect
this. Is there a way for Access to detect when the Excel macro has finished
it's job? The Application ID returned by the Shell function doesn't seem to
help me. I need to inform the user when Excel has finished by displaying a
message.

Thankyou

Richard John
Melbourne, Oz
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Getting Shell Task ID from lost process 0
Extract embedded excel file from word document 0
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Running an app which requires quote defined parameters 3
Automation with Access 2003 0
How does one detect when an application is bieng close BY closing a window? 1
Access 2000 issue opening an Excel 2007 worksheet 0
How to create portable Excel applications? 2

Top