Update Excel Spreadsheet

[MagicCity33]

Hello All,

I am trying to update a excel spreadsheet from VB.NET then print it. I would like for the data from the VB form to be placed in various cells in the spreadsheet.

All calculations would be done in excel then I would print the spreadsheet.

I noticed that the data is not being updated/calculated after I place the data into the spreadsheet unless I manually go to the spreadsheet and double click on each individual cell.

I would greatly appreciate it if someone would stear me in the direction that I need to go in order to get the job done.

 

[m_ogden]

a code sample would help... are you using the Microsoft.Office.Interop.Excel libraries?
You might be turning off application.screenupdating, if so turn it back on when done? also you can try application.doevents