Hello everyone - new to VB.net working with Excel
I am trying to populate data into cells in an Excel spreadsheet using
Range.Value. No matter what cell I give as an argument to the Range
object, Excel always puts the value in "A1".
Here is the code I am having problems with. I am not getting any
errors.
oWBK = oXL.Workbooks.Open("C:\Data.xls")
oWS = oXL.Worksheets(1)
oWS.Range("C3").Value = "PUT IT IN THE RIGHT SPOT!!!"
The resulting Excel sheet will have the text "PUT IT IN THE RIGHT
SPOT!!!" in Cell "A1".
What am I doing wrong?
Thanks