Excel - Spreadsheet

[judgedk]

Hi,

been trying to get my head around this but it dosent seem to work.

I'm using the Excel UDF.

when the script starts i allready have a excel spreadsheet open.

how do i get that spreadsheet that is allready open to have this name : " $oExcel1 " within the script, so i can work with it?

i need to copy all the data from the 1st spreadsheet that is allready open into a new spreadsheet, then sort the data and so on.. but i guess that is no problem..

if i only could find out how to handle the spreadsheet that is allready open and wasent created by me.

Regards

Roy

[Zedna]

_ExcelBookAttach()

[judgedk]

_ExcelBookAttach()

Thank you so much

[judgedk]

_ExcelBookAttach()

Been playing around with that func but cant seem to get i work..

"$oExcel = _ExcelBookAttach( "Microsoft Excel" , "Title" );with $s_mode = "Title" ==> Name of the open workbook
_ExcelWriteCell($oExcel, "If you can read this, then Success!", 1, 1);Write to the Cell";

I only know a part of the title like "Microsoft Excel" but when this runs its the only spreadsheet open.

when i run this i get this error

--> Warning from function _ExcelAttach, No Match

what am i doing wrong?

[nfaustin]

I think the "Microsoft Excel" should be a complete title.

Try AutoIt window info tool to view the Complete title of that spreadsheet.

[judgedk]

I think the "Microsoft Excel" should be a complete title.

Try AutoIt window info tool to view the Complete title of that spreadsheet.

Is that the only way ? cause when this run's i don't know the complete string..

well i guess i could use the "WinGettitle" command to get to full title but anyway.

Edited February 7, 2009 by judgedk

[Zedna]

Look at

Opt("WinTitleMatchMode", 2) ;1=start, 2=subStr, 3=exact, 4=advanced, -1 to -4=Nocase