On Aug 10, 11:45 am, "Mark Rae [MVP]" <m...@markNOSPA Mrae.netwrote:
"Mel" <MLights...@gma il.comwrote in message
news:11******** *************@d 30g2000prg.goog legroups.com...
Can anyone tell me why I am getting this error? It bombs on this line
of my VB code:
Public appExcel As New Excel.Applicati on
Because server-side Office automation doesn't work:http://support.microsoft.com/default...US;q257757#kb2
You'll need to find a different method of integrating Excel into your
ASP.NET app - what are you trying to do exactly...?
--
Mark Rae
ASP.NET MVPhttp://www.markrae.net
The Excel spreadsheet is a calculator. It has a ton of formulas which
were written by a 3rd party vendor of ours. Instead of reinventing
the wheel and creating a new web page which incorporates all of those
same formulas I figured it was easier to just have Excel run in the
background with that spreadsheet open (for read only access). The
idea is, when the user changes an input field on the web page the
visual basic code changes the corresponding field in the spreadsheet
which is running in the background and just retrieves the results from
the spreadsheet and places them on the web page "outputs" section.
Then, as far as maintenance is concerned, if in the future any of the
calculations change we can just update the spreadsheet and no code
would need to be changed on the web site.