Update Excel Spreadsheet

MagicCity33

Member
Joined
Oct 5, 2005
Messages
7
Location
Birmingham
Programming Experience
3-5
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

Well-known member
Joined
Mar 3, 2006
Messages
74
Location
New Hampshire
Programming Experience
5-10
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
 
Top Bottom