• 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 :-)

  • @Rodney

    You are welcome. :) I am not using AutoIt much lately, but documentation and forums has always been very helpful.

  • mobin

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

    big thanks

  • 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)
    Until ClipGet()

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

    Return ClipGet()

    EndFunc ;==>ExcelSheetToClip

Comments are closed.