4 comments

  1. Rodney

    Great post. Your AutoIt forum searching ability is inspirational because you found some great code fragments. Thank you for putting the time and effort into making this post. It has helped me a lot in working with AutoIt strings… and Excel :-)

  2. mobin

    hi,
    very nice function. saved me 5mins a day :)

    big thanks

  3. AJ

    Thank you, it helped me do a summary report from Excel.

    I used your sample code in the link. It was a learning experience to realise that the Excel file has to be opened and closed.

    I didn’t need the Excel file elsewhere so I modified the ExcelSheetToClip function:

    Func ExcelSheetToClip($excel, $sheet)

    ; following statement added to open Excel
    $oExcel = _ExcelBookOpen($excel, 1)

    _ExcelSheetActivate($excel, $sheet)
    ClipPut(“”)
    Send(“^{HOME}^a^c”)
    Do
    Sleep(100)
    Until ClipGet()

    ; following statement added to close Excel
    _ExcelBookClose($oExcel, 0)

    Return ClipGet()

    EndFunc ;==>ExcelSheetToClip

Leave a Reply

You must be logged in to post a comment.

Subscribe to followup comments via RSS