excel process in the background

  • Thread starter Thread starter Carol
  • Start date Start date
C

Carol

I'm trying to find a way of updating the excel
spreadsheet without the excel application coming up on
the users PC. We are getting input from the WEB and
using that input to run a model and capture the data in
an excel spreadsheet. Then manipulate the spreadsheet and
create a summary Word document that will be emailed to
the user. Then the user will be emailed with the summary
data from the excel document. The thing is that this will
be running on some server and I don't want the excel
spreadsheet or application to actually come up on the PC.
How can I suppress the application but still update it ?
 
Carol,

Why do you not want it to come up on the PC? If you have a workbook open
macro, it will fire when the workbook is opened, and you can quit the
application at the end of the macro. Schedule the job in the OS, and as long
as it doesn't require user input, it should run ok.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
I have a background job that is getting user input from
an SQL database, it then uses that data to run Crystal
Ball and generate the output within excel. I then just
need to take that spreadsheet and generate a summary
report within Word and email that word document to the
user. So everything is done in the background on this
one server. So there is no need for the application to
come up on the PC.
Can I just set application.visible='FALSE' ? I tried
the application.update='FALSE' but this doesn't seem to
do the trick..
Thanks
 
Back
Top