Fabinho Posted October 1, 2018 Share Posted October 1, 2018 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") Link to comment Share on other sites More sharing options...
FrancescoDiMuro Posted October 1, 2018 Share Posted October 1, 2018 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 Click here to see my signature: Spoiler ALWAYS GOOD TO READ: Forum Rules Forum Etiquette Link to comment Share on other sites More sharing options...
Fabinho Posted October 1, 2018 Author Share Posted October 1, 2018 thank you!! I changed my code to this: _Excel_RangeCopyPaste($oWorkbook.Worksheets(1), "L4:O4") and worked fine!! Thank you very much!! Link to comment Share on other sites More sharing options...
FrancescoDiMuro Posted October 1, 2018 Share Posted October 1, 2018 Happy to have helped Click here to see my signature: Spoiler ALWAYS GOOD TO READ: Forum Rules Forum Etiquette Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now