Leaderboard

232showtime, Thanks I tryied that also. Never worked just kept adding more #### the biger the field was. I'm such a full. I finally figured it out. With the help of JLogan3o13 post. I revesed the idea. In the old Excel #include <Excel.au3> $oApp = _Excel_Open() $oWorkbook = _Excel_BookNew($oApp) $oWorkbook.Worksheets("Sheet1").Columns("A").NumberFormat = "00000" ;set Column A to text format Then in the new workbook _ExcelWriteCell($oExcel2, $a1[$i][0],2,2) $sFormat = "mm/dd/yyyy" _ExcelNumberFormat($oExcel2, $sFormat, 2, 2, 2, 2) It worked perfectly. Now it turns the date into a text in the old workbook and when copied to the new it formats it back to a date. It solved all the issues. I just wish I had thought of it myself and sooner. Thanks again for the posts to my question.

Sorry, can't help. Oh! Wait! Format and install win 7.

And learn to play games by yourself.

It seems you still have not learned that we are not going to spoon-feed code to you. Recall all your other threads (two of which were locked as dupes) where you have been chided for refusing to put forth any effort. Guess what will happen here if you display the same attitude?

Jewtus, Repost the code and I will format it for you. M23

$httpobject = _WinHttpOpen(Default,$WINHTTP_ACCESS_TYPE_DEFAULT_PROXY) Retrieves the static proxy or direct configuration from the registry. WINHTTP_ACCESS_TYPE_DEFAULT_PROXY does not inherit browser proxy settings. WinHTTP does not share any proxy settings with Internet Explorer. The WinHTTP proxy configuration is set by one of these mechanisms. The proxycfg.exe utility on Windows XP and Windows Server 2003 or earlier. The netsh.exe utility on Windows Vista and Windows Server 2008 or later. WinHttpSetDefaultProxyConfiguration on all platforms. httpobject = _WinHttpOpen(Default,$WINHTTP_ACCESS_TYPE_NAMED_PROXY,'www.proxy.com:8080') If you wanted to specify a proxy

Would you please be so kind and enclose your code in AutoIt code tags (that's the blue "A" in the editor).? That enhances readability a lot

"its not working" should be removed from the language... WHAT is not working? How about posting your WHOLE code, so we can better assist you in refactoring it?

File Name: AutoIt v.3.3.13.18 Beta File Submitter: Jon File Submitted: 20 Aug 2014 File Category: Beta 3.3.13.18 (20th August, 2014) (Beta) AutoIt: - Fixed #2639: Unable to Copy/Paste from Embedded IE object. - Fixed #2839: GUISetAccelerators() with an invalid array can cause a hard crash. UDFs: - Changed: _ArrayInsert() now uses constants to change addition behaviour and datatype forcing. Click here to download this file

There is always the possibility of script-breaking changes, to be sure. But the update from BETA 17 to 18 was pretty minor.

johnone, You can use a slightly modified version which is what I believe to be the only way to modify an inner array in the light of what Jon said about (). Global $aArray[4] = [7, 8, 9, 0] Global $nPseudoObject[] $nPseudoObject.int = 123 $nPseudoObject.string = "Hello" $nPseudoObject.array = $aArray $nPseudoObject.GetInt = Get_Int $nPseudoObject.GetString = Get_String $nPseudoObject.GetArray = Get_Array $nPseudoObject.SetInt = Set_Int $nPseudoObject.SetString = Set_String $nPseudoObject.SetArray = Set_Array Func Get_Int() Return $nPseudoObject.int EndFunc ;==>Get_Int Func Get_String() Return $nPseudoObject.string EndFunc ;==>Get_String Func Get_Array($i) Return $nPseudoObject.array[$i] EndFunc ;==>Get_Array Func Set_Int($int) $nPseudoObject.int = $int EndFunc ;==>Set_Int Func Set_String($string) $nPseudoObject.string = $string EndFunc ;==>Set_String Func Set_Array(ByRef $array, $index, $value) ; passing "this" byref $array[$index] = $value ; works EndFunc ;==>Set_Array #EndRegion Pseudo Object ConsoleWrite(($nPseudoObject.GetInt) () & @LF) ConsoleWrite(($nPseudoObject.GetString) () & @LF) ConsoleWrite(($nPseudoObject.GetArray) (2) & @LF & @LF) ($nPseudoObject.SetInt) (456) ($nPseudoObject.SetString) ("World") ($nPseudoObject.SetArray) ($nPseudoObject.array, 2, 18) ; This call now works ConsoleWrite(($nPseudoObject.GetInt) () & @LF) ConsoleWrite(($nPseudoObject.GetString) () & @LF) ConsoleWrite(($nPseudoObject.GetArray) (2) & @LF & @LF) Passing "this" byref is always better since it makes the inner functions work independantly of the map instance.

>

My program does not provide a way to copy data to another program. You can only copy data from Excel to the clipboard. _Excel_RangeCopyPaste($oWorkbook1.ActiveSheet, $oRange)

Use a loop? Post some code showing what you have tried and then I'm sure someone will jump in with some help.

You can set the formatting of your range of cells first. Something like this: #include <Excel.au3> $oApp = _Excel_Open() $oWorkbook = _Excel_BookNew($oApp) $oWorkbook.Worksheets("Sheet1").Columns("A").NumberFormat = "mm/dd/yyyy" ;set Column A to date format

To close out this thread, the bug has been fixed in the latest BETA (3.3.13.18). The ticket has been closed.

Please have a look at ControlSend.

OK I’m not a scripter, merely a rare part time hobbyist because of the hours I work, but as I’m off work at the moment with a broken leg I was asked by one of my sons if it was possible to create an equalizer and/or audio effects with Autoit. So being a little familiar with the bass udf I came up the example below. Some of the effects are copied from the examples provided by eucalyptus so many thanks to him because it pointed me in the right direction to create more. Obviously you need at least bass.dll, bass and bass_FX.dll Please give it a try and offer suggestions for improvement. Edit: Thanks wakillon for your comments EqualizerTest.au3

Hi This is a DJ-program like the Denon DN2000F using bass.dll & co There are still a lot of bugs... you can use different audiointerfaces to play and monitor (if you have more than one...) ($iMainDevice and $iMonDevice to choose) http://rapidshare.com/files/201769180/AMD.rar enjoy E

I had some trouble finding this, but this may help others. I still haven't figured how it works.. . I don't think it's install right on my PC Nigel

The attempts will be redirected if you are running a 32 bit process. To prevent this redirection when suitable, disable it and immediately revert it when done. This has been tested on Win7 64bit with AutoIt 32bit and 64 bit. The 2nd RunWait() run under 32bit AutoIt will not find bcdedit.exe as the redirection is reverted to enabled. ; disable filesystem redirection for 32 bit process _Wow64FsRedirection(False) ; run bcdedit with redirection disabled RunWait('"' & @ComSpec & '" /k bcdedit.exe') ; revert filesystem redirection for 32 bit process _Wow64FsRedirection(True) Sleep(500) ; run bcdedit with redirection enabled RunWait('"' & @ComSpec & '" /k bcdedit.exe') Func _Wow64FsRedirection($state) ; Disables or reverts the filesystem redirector for a 32 bit process running on 64bit OS If Not @AutoItX64 And @OSArch = 'X64' Then If $state Then DllCall("kernel32.dll", "int", "Wow64RevertWow64FsRedirection", "int", 0) Else DllCall("kernel32.dll", "int", "Wow64DisableWow64FsRedirection", "int", 0); or 1 as per help EndIf If @error Then Return SetError(1) EndIf EndFunc

This is coming from the official person and for me that is almost a law. It's also a strong indicator that AutoIt's EULA, despite the fact that it was revised couple of times in past time, is still bad or maybe not good... or whatever. Devs would really need an expert on that field to wrote AutoIt's EULA for them. Current one is failing in determination of the owner of the compiled script. Who is the rightful owner? If that's the person who compiled the script then there is a contradiction in EULA when saying "You may not reverse engineer or disassemble the SOFTWARE PRODUCT or compiled scripts..." You can do what ever you wan't with your property if it's truly yours. If "Jonathan Bennett and the AutoIt Team" are saying: "No, you cannot do that!", then they are saying that you are not the rightful owner (in full meaning of that word), because they are there to tell you what you can and cannot do. This situation is common with for example bought software. The difference is that you are not allowed to resell the bought. AutoIt's EULA is allowing you to "... sell for profit and freely distribute scripts and/or compiled scripts...", but how can you freely (the way that suits you) distribute those goods if you are to say to the buyer that "Jonathan Bennett and the AutoIt Team" (third party) forbids this and that to the buyer of your software. "Jonathan Bennett and the AutoIt Team" will eventually have to say if you are the full owner or they have their share in your software.