Check if Excel is running

[James C.]

I have a form that the user can input data and when they hit submit, it dumps
the information into excel. The problem that I am having is that sometimes
they have excel open which causes a pasting problem.

I want to be able to have the user hit submit and then the module will close
all running excel apps before it opens up the excel workbook that I specify
in the code.

Can this be done

 

[Douglas J. Steele]

Take a look at http://www.mvps.org/access/api/api0007.htm at "The Access
Web"

 

[BAC]

I, for one, would be very upset if I were working an Excel project, switched
to your app, then had your app close my Excel file...especially if I hadn't
saved it...

A better approach would be to use the CreateObject, rather than GetObject
method (creating a new instance of Excel), open your workbook and
specifically activate the worksheet you wanted the data to post to before the
paste operation.

Bac