SwordHunter4Ever Posted July 26, 2008 Share Posted July 26, 2008 (edited) Okay so I need to paste something into a cell on excel, not type it. No matter what command I try to use though it seems to type it. Any help? Here is the coding I've tried. #include <Excel.au3> #include <Math.au3> WinActivate("page title"); switch - internet WinWaitActive("page title"); active - internet Sleep(2000) MouseClick("left", 1087, 708, 3); triple click on text Send("^c"); copy text Sleep(500) $sFilePath1 = @ScriptDir & "\excelfile.xls"; open excel file Local $oExcel = _ExcelBookOpen($sFilePath1); open path Sleep(2000); wait while opening _ExcelWriteCell($oExcel, "{LCTRL}v", 2, 4);Write to the Cell <--PROBLEM! Exit I've tried to replace the problem area with this code also but still no luck. _ExcelWriteCell($oExcel, "^v", 2, 4);Write to the Cell Edited July 26, 2008 by SwordHunter4Ever Link to comment Share on other sites More sharing options...
martin Posted July 26, 2008 Share Posted July 26, 2008 Okay so I need to paste something into a cell on excel, not type it. No matter what command I try to use though it seems to type it. Any help? Here is the coding I've tried. #include <Excel.au3> #include <Math.au3> WinActivate("page title"); switch - internet WinWaitActive("page title"); active - internet Sleep(2000) MouseClick("left", 1087, 708, 3); triple click on text Send("^c"); copy text Sleep(500) $sFilePath1 = @ScriptDir & "\excelfile.xls"; open excel file Local $oExcel = _ExcelBookOpen($sFilePath1); open path Sleep(2000); wait while opening _ExcelWriteCell($oExcel, "{LCTRL}v", 2, 4);Write to the Cell <--PROBLEM! Exit I've tried to replace the problem area with this code also but still no luck. _ExcelWriteCell($oExcel, "^v", 2, 4);Write to the CellWhat about _ExcelWriteCell($oExcel, ClipGet(), 2, 4);Write to the Cell Serial port communications UDF Includes functions for binary transmission and reception.printing UDF Useful for graphs, forms, labels, reports etc.Add User Call Tips to SciTE for functions in UDFs not included with AutoIt and for your own scripts.Functions with parameters in OnEvent mode and for Hot Keys One function replaces GuiSetOnEvent, GuiCtrlSetOnEvent and HotKeySet.UDF IsConnected2 for notification of status of connected state of many urls or IPs, without slowing the script. 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