Aceguy Posted April 2, 2009 Share Posted April 2, 2009 how do i write to an existing (already opened) excel document.... becase all the examples in the helpfile just manipulate new() or open() one...... _ExcelWriteCell($oExcel, "I Wrote to This Cell", 1, 1) $oExcel wont exist... TY [u]My Projects.[/u]Launcher - not just for games & Apps (Mp3's & Network Files)Mp3 File RenamerMy File Backup UtilityFFXI - Realtime to Vana time Clock Link to comment Share on other sites More sharing options...
Authenticity Posted April 2, 2009 Share Posted April 2, 2009 Hmm.. Dim $oExcel = _ExcelBookAttach() ..and then maybe Dim $oSheet = $oExcel.ActiveSheet depending if _ExcelBookAttach() could successfully attach to the Excel instance. Link to comment Share on other sites More sharing options...
Aceguy Posted April 2, 2009 Author Share Posted April 2, 2009 Great, TY....$oExcel = _ExcelBookAttach("Microsoft Excel - Book1", "Title")worked for me.....i must have an outdated Scite helpfile... _ExcelBookAttach didnt show up.. [u]My Projects.[/u]Launcher - not just for games & Apps (Mp3's & Network Files)Mp3 File RenamerMy File Backup UtilityFFXI - Realtime to Vana time Clock Link to comment Share on other sites More sharing options...
Authenticity Posted April 2, 2009 Share Posted April 2, 2009 Man, I must say that I don't think it should match exactly the title. Why not using just StringInStr, more flexibility in my opinion. Oh, by the way, it returns __Workbooks, so to get the sheet use $oSheet = $oExcel.Application.ActiveSheet. Link to comment Share on other sites More sharing options...
Aceguy Posted April 2, 2009 Author Share Posted April 2, 2009 (edited) #include <Excel.au3> $title=WinGetTitle("Microsoft Excel","") if not $title=0 then $oExcel = _ExcelBookAttach($title, "Title") Else $oExcel=_excelbooknew() EndIf $d=0 Do $d+=1 $read= _excelreadcell($oExcel,$d,1) until $read="" ConsoleWrite("end of row is "&$d&@lf) used this to find the last entry in colomn 1..... TY Authenticity Edited April 2, 2009 by Aceguy [u]My Projects.[/u]Launcher - not just for games & Apps (Mp3's & Network Files)Mp3 File RenamerMy File Backup UtilityFFXI - Realtime to Vana time Clock 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