plastix

Hi all Can IUIAutomation automate existing instances of Chrome to find objects (by ID, for example) within iframes and set text of inputs within them ? I need to basically poll existing Chrome instances regularly to see if a login form is loaded (which will itself be loaded in an iframe potentially within any number of tabs/instances). Chrome will have accessibility 'on', but there are restrictions that won't permit the installation of any non-mainstream extensions etc (othewise would have looked at the _Chrome_UDF). I started dabbling with Selenium (via Selenium Wrapper ) and it worked well spawning an instance of Chrome browser etc - but I later realised that it can't attach to an existing instance of Chrome... I've looked at Junkew's IUIAutomation framework and could see might be feasible to manipulate controls by click etc - but not necessarily at a DOM / DOM tree level... Anyone got any experience / success with this specific issue ? TIA

I live / work in a country where Windows XP support has been extended because major industry can't move on Office is bundled in with that... They won't upgrade the workstation browsers from IE7 due to legacy systems. Demanding web applications require development to run in IE7 (modern browsers / chrome frame not permitted either). The office suite is the most up-to-date thing on the workstation Thanks for all

Yes - my original example was based on the same UDF examples - works fine for Excel 2010 but not for 2003. The actual UDF example works on Excel 2003 - but thats due to having file in @TempDir already (I don't see how that is created - I assumed either Excel does it or it is created by AI during installation). If I amend the destination, it fails with same error above. I'm pretty certain now that this is more a policy issue with the local Excel install/Excel version than the UDF. My 'workaround' is to FileInstall a blank Excel file into destination (using a unique name), manipulate as required and then _Excel_BookSave/_Excel_BookClose and rename (via FileMove) to the required file name convention. I may have somehow missed something... function over beauty

OK. Using SEO/Litlmike's function fails too... but Excel asks me if I want to save changes. Replying 'yes' opens Excel's file save dialog while 'no' generates no error and no file saved (presumably because it 'forgets' everything that was updated). In the remarks for the 3.3.8.1 function it states that we can only "SaveAs" to same working path as originally opened - and this is a newly created unsaved book... so I guess this is the same issue in Excel 2003 +/- 2007 but not a problem with 2010+ I'll try to use _Excel_BookSaveAs to save an empty new book to location, then populate and re-save and see if that works. Failing that, I will need to try a 'FileInstall' of an empty workbook to the required location and then open that / modify and then SaveAs will hopefully work. I'll update as I progress. Any other ideas greatfully appreciated Thanks again UPDATE 1. Save blank workbook created by _Excel_BookNew: FAIL 2. FileInstall blank XLS, _Excel_BookOpen, amend and _Excel_BookClose: OK

Thanks water and sorry for delay. Original code above worked fine on my home PC running Excel 2010 aswell as with $xlWorkbookDefault token. Trying '$xlWorkbookDefault' generated same error on work system (XP, Excel 2003) Must be some kind of security / GPO issue

Hi all I'm using Autoit 3.3.12.0 and Excel 2003 I am trying to export a 2D array to an Excel file. The 2D array ($cells) is populated, and the code below creates a new instance of Excel with a single worksheet and inserts the 2D array correctly. $oXL = _Excel_Open() $oWB = _Excel_BookNew($oXL,1) _Excel_RangeWrite($oWB, $oWB.Activesheet, $cells, "A1") ;FileChangeDir (@DesktopDir & "\") _Excel_BookSaveAs($oWB,@DesktopDir & "\Cases.xls", $xlExcel8, True) After that, it fails to save. I get an @error of 5, with @extended of -2147352567 The file path is a network redirect "domainusernameDesktopcases.xls" but it fails even if i specify "C:cases.xls". I can easily save the workbook manually at the point of the error generation to the specified location. I'm obviously missing something obvious - or it is some kind of permission / automation issue. Any ideas anyone ? TIA

Melba23 Sorry. Didn't really think - seemed like the right place to ask at the time. I'll refrain in future. Thanks for clarity / splitting off topic. ? Maybe add to the forum rules. UEZ The >original thread mentioned possibly refining the stats functions into a mature stats/statistics UDF or possibly including them with their own 'namepsace' within the Math.au3. That is what I was referring to in the post. The issue with _ArraySort related to numerical sorting - I ended up using >_ArraySortClib to address the problems (I forget the detail now - but I think there were problems with zero amongst other things). As it stands I am going to revisit the stats functions (unless anyone contributes any work-in-progress) so I'll test the current _array functions first. Thanks again all

Hi all Previously I had to 'roll my own' stats functions (I was calculating percentiles/medians/means). If I remember the array sort also had a glitch that meant using an alternative array sorting script). Was this ever taken any further ? (I don't see anything within Math.au3 or a seperate UDF) TIA Plastix

Hi all Need to detect systems logged in without a smartcard inserted (and authenticated). Found this post which gets as far as detecting smartcard readers ( ) and linking up to resource manager. Found this resource for constants etc ( http://pyscard.sourceforge.net/epydoc/smartcard.scard.scard-module.html ) Any UDFs in the making ? Anyone made any progress with working with smartcards in autoit ? TIA Plasix

Anyone successfully compiled sqlcipher 2.03 and used in autoit ? i cant even get compiling environment right... but would be good to know will work if we get there in the end...

Thanks smashly I'll take a look

Hi all I kinda need a (basic) dictation system, but with the following features: 1. visualisation of recording i.e. waveform 2. ability to click on waveform to listen from that position 3. ability to click on waveform and record from that point (overwriting previous recordings) 4. normalise (maybe some sound-pattern removal) 5. save as MP3 For me this is a daunting task mainly due to the graphical part (haven't really looked at GDI properly etc)... I'd appreciate anyone's opinions on the best plugins / DLLs etc for the job. Is the BASS suite capable of recording aswell as conversion / normalisation i.e. will the BASS suite cover the sound recording part of this ? (inc. ability to record to file position etc ?). Ideally i'd like this project to not require any 3rd party installs - local DLLs etc are fine... I'd appreciate any comments / feasibility suggestions (outside of my novice coding abilities TIA

Thanks m8 Feared as much. Thanks for checking.

Hi all The topic isn't very clear. I am launching a browser session using IE.au3 and _IECreate, but want to supply some additional information in the URL that the ASP server can read and use during that session. When I create an IE instance with _IECreate("default.aspx?data=123456&info=hello") the browser is created and displays "default.aspx" in address bar. If I use _IENavigate with the same details, it then shows the full URL. This doesn't happen with tests on other pages with .html type... but as far as i'm aware the ASP page doesn't perform any reload etc. Is this a quirk or is it liekly something related to the ASP page itself (I don't have the source)(or am I missing something !) #include <IE.au3> #include <Array.au3> Global $oIE $oIE = _IECreate("http://site/default.aspx?data=123456&info=Hello",0) ;opens with just 'default.aspx' _IENavigate($oIE,"http://site/default.aspx?data=123456&info=Hello") ;reloads with full URL Any pointers appreciate - if this is a quirk etc, can save me hours of tinkering TIA

Hi all Thinking about trying to make an audio recorder / recording editor (probably only normalise and record at set marker in audio track) i.e. a dictation recorder... Some of the BASS dll / GDI+ examples look like it can be a nice waveform visualisation / EQ tool - but do you know if it supports recording / overdubbing as mentioned above ? TIA