They have helped me before here to paste the value of a variable into a cell in Excel.
In this case I determine which cell to paste the value into.
Code: Select all
xlApp := ComObjCreate("Excel.Application")
xlAppDown := -4121
xlApp.Visible := true
xlApp.DisplayAlerts := False
oxWorkbook := xlApp.Workbooks.Open("C:\Temp\Some_Plan.xlsm")
xlApp.Range("A2").Value := VarToPaste
I try something like this...but doesnt work
Code: Select all
xlApp := ComObjCreate("Excel.Application")
xlAppDown := -4121
xlApp.Visible := true
xlApp.DisplayAlerts := False
oxWorkbook := xlApp.Workbooks.Open("C:\Temp\Some_Plan.xlsm")
xlApp.ActiveSheet.Value := VarToPaste