Excel Readout isnt Copying to the Clipboard - (Moved)

[SerHenning]

Hey I'm trying to make autoit read out a cell from an excel docuement

#include <IE.au3>

#include <Excel.au3>
#include <MsgBoxConstants.au3>

Local $var = "C:\Users\Jan\Documents\Projekte\Autoitlernen\excel\testitest.xlsx"
Local $oExcel_1 = _Excel_Open()
Local $oWorkbook = _Excel_BookOpen($oExcel_1, $var)
;Local $_read = _Excel_RangeRead($oWorkbook,"Tabelle1","A2")
Local $_read = _Excel_RangeCopyPaste($oWorkbook,"Activesheet","A2")

It opens the excel file, so thats working, but it doesnt copy anything to the clipboard 😕

yours Jan

[jitb]

try

_Excel_RangeCopyPaste($oWorkbook.Activesheet, "A2")

(Called with worksheet object)

Edited July 24, 2019 by jitb

[SerHenning]

Thanks for your help! Its weird, when I pasted it in first, it worked perfectly fine with your version, then I changed something in the parts a little down in the code and tried it again, and it says that the problem is in the line above. It says

Local $_read =
_Excel_RangeCopyPaste($oWorkbook.Activesheet,"A2")
Local $_read =
_Excel_RangeCopyPaste($oWorkbook.Activesheet,"A2")^
ERROR

Error: Unable to parse line.

[SerHenning]

2 hours ago, jitb said:

try

_Excel_RangeCopyPaste($oWorkbook.Activesheet, "A2") 

(Called with worksheet object)

I think I had to quote that, woops

[JLogan3o13]

Moved to the appropriate forum.

Moderation Team

[SerHenning]

I deleted all of the code after it and pasted it in again and now it works, but whatever, works now. Thank you @jitb!