How to copy a group of cells using Autoit

[Fabinho]

Hello Guys!

Sorry for my english, it's not my first language.

 

I'm trying to copy a group of cells from MS Excel using Autoit, but I can just copy one cell.

If I try to copy a group, the result returns 0.

 

My code that works fine but copying one cell

Local $oRange = $oWorkbook.ActiveSheet.Range("L4")

sleep(1000)
clipPut($$oRange)
sleep(300)
$sData = ClipGet()
sleep(300)

;run notepad
run("notepad.exe")
sleep(300)
MsgBox($MB_SYSTEMMODAL, "", $sData)
send("^v")

If I try inserting a group of cells, it will return 0

Local $oRange = $oWorkbook.ActiveSheet.Range("L4:O4")

[FrancescoDiMuro]

Hi @Fabinho, and welcome to the AutoIt forum

Just now, Fabinho said:

I'm trying to copy a group of cells from MS Excel using Autoit, but I can just copy one cell.

Take a look at Excel UDF

[Fabinho]

thank you!!

I changed my code to this:

_Excel_RangeCopyPaste($oWorkbook.Worksheets(1), "L4:O4")

and worked fine!! Thank you very much!!

[FrancescoDiMuro]

Happy to have helped