I cannot figure out the declarations to write to an excel file that is already open.
I open the excel file and make it visible with this:
Private Sub Button1_Click
Dim objExcel As New Excel.Application
Dim objWB As Excel.Workbook
objWB = objExcel.Workbooks.Open("F:\My Software\files\test.xls")
What are the declarations needed to write to this open this file and write to it?
Private Sub Button2_Click
[[I DON'T KNOW WHAT TO PUT HERE]]
row = 1
column = 1
objExcel.Cells(row, column).Value = "cell data"