Re: How do you get excel to calculate using ADO?
- From: "Bob Barrows [MVP]" <reb01501@xxxxxxxxxxxxxxx>
- Date: Thu, 4 Oct 2007 14:28:30 -0400
mike wrote:
hello everyone,No way that i know of: for calculations to refresh, the Excel
I can put and read values from excel using ado. I think the main
point of using excel is you can use it do some calculations. however,
when i put values in some cells and read the values of cells that
normally calculate something using those inputs, it doesnt work. I
have to open excel manually, then close it, before the values of those
cells update. How do I get excel to calculate from ASP using ADO or
some other method so that I can read the updated values?
application has to be involved, which is not the case when using ADO.
Microsoft advises against automating Office applications in ASP code. I
think you are just going to have to do these calculations in your
vbscript code.
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
.
- References:
- How do you get excel to calculate using ADO?
- From: mike
- How do you get excel to calculate using ADO?
- Prev by Date: How do you get excel to calculate using ADO?
- Next by Date: vb6 call recordset from sql server 2000 - working until using parameters - then empty recordset
- Previous by thread: How do you get excel to calculate using ADO?
- Next by thread: vb6 call recordset from sql server 2000 - working until using parameters - then empty recordset
- Index(es):
Relevant Pages
|
|
