Communicating with excel file

[13063154]

Hi

I am using visual studio 2003, vb.net.

I am trying to read information from an excel worksheet and then write it to a new excel worksheet in a formatted way. In other words I am trying to read from two columns A and B getting a time and venue value out of the columns, i then want to check if the value is equal to something example Monday 8:00 in venue 25-g08 if this is correct then write it to row and column that matches the information.

 

[vis781]

How far have you got, can you access the excel spreadsheet? can you post some more detail as to what you need help with?

 

[13063154]

I have managed to connect to the excel file, i can read and write data to the file now i have to try and use if statements to get the values and data to the correct cell. I will try it this weekend and if i don't get it i will give more details.

Cheers