shahino007

Solved it I used _ExcelWriteCell instead of _ExcelWriteFormula

Hey I'm trying to write a formula in Excel but it appears for some reason with single quotes on the values: (The formula compares between values of two cells, in this case A4 and E4 and the result should be at cell 4,4) The code in Autoit: _ExcelWriteFormula($oExcel, "=EXACT(A4:E4)",4,4) The Formula content as it appears in Excel function bar after execution: =EXACT('A4':'E4') This leads to "#NAME?" result in the excel Does anyone know how to solve this? Thanks

Anyone...?

I generated the following code: ************************************************************ #include <Sound.au3> Local $File_path = "C:WINDOWSMediaWindows XP Exclamation.wav" Local $aSound = _SoundOpen($File_path) While StringCompare(_SoundStatus($aSound), "playing") <>0 Sleep(200) _SoundPlay($File_path) Consolewrite("Sound: " & _SoundStatus($aSound) & @CRLF) WEnd MsgBox(0,"","Playing") _SoundClose($aSound) ************************************************************ But I cannot get out of the loop. Can you tell me what is wrong here? *Its not my final code. It's just something to test the ability to detect when the computer is using wav files.

Is there any way to detect whether the computer is trying to access the beep file and use it for my use?

OK The alternative way sounds fine But how do I detect whether the PC is accessing a specific file?

Hey there I'm trying to harness the beep function of the PC to my script conditional activation. I mean that when a certain process in the computer stops (lets say when a USB device is formatted), a beep is played and only then I want to activate my script. Any ideas how to do it? Thanks!

I updated th version to v3.3.10.1 Now I've encountered with new problems: When I execute the Spy_demo.au3 and press ctrl+W on the requested object (on any object actually...) I get the following error on the consule: Veriable must be on type 'Object' This happens on line 58: $objUIAtomation.ElementFromPoint($tStruct, $pIUElement) When I run the the UIAWrappers.au3 I get the message that the UI automation failed (in the first function, the _UIA_Init()) This happens immediately right after executing. The Spy_demo is related to UIAWrappers.au3 so if this doesn't work then spy_demo has a problem So I'm still stuck

Can't run Spy demo and the first automation script because I don't have ObjCreateInterface function. Can you please provide it?

Thanks, Couldn't find enything relevant to my case. I think the focus needs to be on commands that handle BCGPPropList controls. Its only a hunch..

As I said before: When I'm using the Autoit v3 Window Info, it gives me the class name of the table as: BCGPPropList:400000:8:10011:10, INSTANCE:1 I use it instead of control ID (the Window Info doesn't give me any control ID for this control) Its not classic TreeView control so the TreeView commands don't apply here. Its of PropertyList type, and for that I don't know what to use

It's not possible to attach a screen shot of the table because its in a stand alone computer and data cannot be extracted from it (restrictions in my work place) I'll try to explain myself more clearly: I have a property table in an application. This table consists of main topics which are treeview like (Header, data, Footer) It is possible to expand those topics and see their children. An extended topic includes property table with two colomns. The left colomn consists of property fields (name, id, ext..). the right colomn consists of the values of those properties. I don't know how its possible to access those values and edit them Hope its more clear...

Hey I'm trying to access a properties table and automaticaly edit its values (not in IE but in external program), but seems that I cannot get into the table using the regular commands. When I'm using the Autoit v3 Window Info, it gives me the class name of the table as: BCGPPropList:400000:8:10011:10, INSTANCE:1 Is there any special set of commands related to properties table? Thanks, Shahino007

I have the same Autoit3 on both computers and I've tried the option: RunWait('psexec remotecomputer -i C:...AutoIt3.exe C:...My_Script.au3"') but still nothing happened Perhaps there Is another way to execute au3 file on remote computer without using the psexec option. Any ideas?

Hey there, I'm trying to execute an Autoit script which is located on a remote computer (activation is with psexec), but nothing happens. When I compile the au3 script and try to execute it remotely via psexec, everything is OK. So what is the difference between running au3 file to exe file? Both the computers are WinXP Pro SP3 The command is: RunWait('psexec remotecomputer -i C:...My_Script.exe"') ; this works! *The command for au3 script is almost the same: RunWait('psexec remotecomputer -i C:...My_Script.au3"') Thanks,