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?
Re: Rounding Problem ... I would suggest that you NOT use the "Precision as displayed" setting. ... It can cause rather odd results in calculations if various cells have a different number of decimal places. ... Microsoft MVP - Excel... (microsoft.public.excel.newusers)
Re: Problems using VB.Net OleDbDataAdapter and Excel ...Formula cells cannot be updated using ADO.... Using ADO classic, Jet and OLE DB, I get slightly different behaviour ... Note that although you can change non-formula cells via ADO, any Excel... (microsoft.public.excel.programming)
Re: Coping numbers to next blank cell on another worksheet ... > I am just learning Excel but any help would be> greatly appreciated. ... > I need to copy calculated numbers in> specific cells on worksheet # 1 to the next blank cells in existing> columns of numbers used in calculations on other worksheets in the same> workbook. ... While the orginial number comes from the same cell> each time the destination for each number must go to the next blank cell> in the same column and on the same worksheet each time. ... (microsoft.public.excel)
RE: write data to a closed file on network drive ... I don't know much about the technical specs of ADO,... works just for Excel too, ...Sub RS2WS ... Microsoft Active X Data Objects Recordset 2.8 Library ... (microsoft.public.excel.programming)
Excel file bloat using ADO ... I have modified a routine based on the following WebPage that uses ADO... to add data to closed Excel files.... How do I update an Excel spreadsheet using ADO? ... Apparently, this is a problem with Access files, given the number of ... (microsoft.public.excel.programming)
