Blue_Drache Posted September 7, 2006 Share Posted September 7, 2006 (edited) Prior to the 3.2.0.1 release, this code worked fine with the Beta releases: While 1 ; Get the DCN from the user $dcn = "" Do $pass = 0 If WinExists("Microsoft Excel") Then $oExcel = ObjGet("", "Excel.Application") ; sets the current Excel window as an object. $dcn = $oExcel.ActiveCell.Value ; grab the data from the current active cell. ConsoleWrite('@@ Debug(54) : $dcn = ' & $dcn & @lf & '>Error code: ' & @error & @lf) ;### Debug Console MsgBox(262144,'Debug line ~54','Selection:' & @lf & '$dcn' & @lf & @lf & 'Return:' & @lf & $dcn & @lf & @lf & '@Error:' & @lf & @Error) ;### Debug MSGBOX ; mark what's been done It ran perfectly...did what I wanted, behaved itself and returned the requested data from Excel.... Now...the only value I can get for a $dcn is "23" ???? @@ Debug(54) : $dcn = 23 >Error code: 0 As far as I can tell...there's nothing wrong with my code....I've reviewed the helpfile and matched my structure to those given in the examples. Edited September 7, 2006 by Blue_Drache Lofting the cyberwinds on teknoleather wings, I am...The Blue Drache Link to comment Share on other sites More sharing options...
lod3n Posted September 7, 2006 Share Posted September 7, 2006 Try it in reverse: $oExcel.ActiveCell.Value = "HERE IS THE ACTIVE CELL" Does that show up where you expect? [font="Fixedsys"][list][*]All of my AutoIt Example Scripts[*]http://saneasylum.com[/list][/font] Link to comment Share on other sites More sharing options...
MHz Posted September 7, 2006 Share Posted September 7, 2006 What did you expect as a return value instead of 23? I know that there was a bug fix done with floating numbers found by Valik and maybe be ok in the latest beta. I cannot see in history to confirm but could be your issue? Differcult to tell with amount of info. Link to comment Share on other sites More sharing options...
Blue_Drache Posted September 7, 2006 Author Share Posted September 7, 2006 Try it in reverse: $oExcel.ActiveCell.Value = "HERE IS THE ACTIVE CELL" Does that show up where you expect? Borksville. C:\Documents and Settings\U256655\Desktop\AutoIt\User Scripts\RetroDDRPrinter.au3 (55) : ==> The requested action with this object has failed.: $oExcel.activecell.text = "TEST TEST TEST" $oExcel.activecell.text = "TEST TEST TEST"^ ERROR It seems that it's not even getting the object in the first place, yet...wait... *slaps forehead* I feel dumb. *walks away and quickly closes the other two windows that were open* I apologize for wasting y'alls time. Sheesh...when I close out the other two windows, it works perfectly. Go figure. Lofting the cyberwinds on teknoleather wings, I am...The Blue Drache 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