I am trying to see if it is possible to paste data into a specific cell on a specific excel sheet.
so far I have figured out getting it into my active excel, on whatever sheet is active; but if it would be possible to paste something into
"Sheet 2" while I'm sitting in "Sheet 1"' that'd be a game changer. below is a snippet of how I am pasting currently
Code: Select all
ex := ComObjActive("Excel.application")
nwrw := ex.Range("B3")
clipboard := regexreplace(clipboard, "(\s+|,)")
ex.activesheet.range("B3").PasteSpecial(-4104)
return