Check if Excel is running

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top