Bitten

So simple! I set the format to text, and now i get the values i wanted Awesome. I was on the right track, but im a noob when it comes to excel.

Hi, I'm having a weird issue i can't figure out. When i use _Excel_RangeWrite to outout my array to excel, i get a different value for one of the cells, than the actual array holds. The code i use is: Func OutputExcel($array) Local $oAppl = _Excel_Open() If @error Then Exit MsgBox($MB_SYSTEMMODAL, "Excel UDF: _Excel_RangeWrite Example", "Error creating the Excel application object." & @CRLF & "@error = " & @error & ", @extended = " & @extended) Local $oWorkbook = _Excel_BookNew($oAppl) If @error Then MsgBox($MB_SYSTEMMODAL, "Excel UDF: _Excel_RangeWrite Example", "Error creating the new workbook." & @CRLF & "@error = " & @error & ", @extended = " & @extended) _Excel_Close($oAppl) Exit EndIf _Excel_RangeWrite($oWorkbook, $oWorkbook.Activesheet, $array) $oAppl.ActiveSheet.Columns("A:C").AutoFit EndFuncI have an array that looks like this: 0|240|12.05 1|170|8.54 2|98|4.92 3|95|4.77 4|81|4.07 5|64|3.21 6|64|3.21 7|43|2.16 8|38|1.91 9|27|1.36 11-20|281|14.11 21-30|173|8.69 31+|617|30.99 However, when i output it to excel, the value for "11-20" is replaced with "44136" ( see image ). I'm guessing this has something to do with the format of the value, but i can't seem to make it work. Any idea's are welcome.

Hmm, strange, it's not working on my own windows 7, however i'm part of a domain, so it may be a rights problem. I am a local administrator of my windows system though, and running it as an admin makes no difference.

Is this not the correct forum to ask this perhaps? Or is it just too weird for anyone to know

I'm running it on a Windows Server 2012.. maybe its some kind of rights issue. I have tried elevating the script to admin, and run the exe as admin.. but it makes no difference

I'm trying to edit scheduled tasks through the COM object, but somehow it seems to be a little stubborn when i'm doing anything other than just reading. $TaskRootFolder = "\myFolder" $oTaskSchedule = ObjCreate("Schedule.Service") $oTaskSchedule.connect() $oRootFolder = $oTaskSchedule.GetFolder($TaskRootFolder) If IsObj($oRootFolder) then $oTaskDefinition = $oRootFolder.GetTasks(0) $NumTasks = $oTaskDefinition.count ConsoleWrite($NumTasks & " tasks found in " & $TaskRootFolder & @CRLF) For $oTask in $oTaskDefinition ConsoleWrite("Task: " & $oTask.name & " enabled: " & $oTask.enabled & @LF) $oTask.enabled = False Next Else ConsoleWrite("Task scheduler rootfolder not found." & @LF) Exit EndIf In the above code i connect just fine to the object, and i can read the tasks just fine. But nothing happens when i try to modify it with " $oTask.enabled = False ". I have tried every possible syntax of this i could think of but nothing works. Any info or ideas would be greatly appreciated.

That was one of the first things i tried, and that works just fine. It seems like xcopy just wont run with " runwait() "

Unfortunately this has to run windows native programs only. I guess i'll stick with the shell solution for now.

Did that too, no difference. I even tried replacing xcopy with a different command, which works just fine.

It's not outputting anything, its as if the command isn't run at all.

Aparently this works if i use ShellExecuteWait instead.. I have no idea why though.

Hello, I'm having a weird issue i can't figure out. When i run the script without compiling it it works just fine, however when i compile and run the exe file, nothing is done. I'm at a loss as to what is causing this issue, any suggestions are welcome. The script is compiled and run without any errors. $source = "d:\temp\Mobile\*.*" $destination = "d:\pakning" Runwait(@ComSpec & " /c " & "xcopy " & '"' & $source & '"' & ' "' & $destination & '"' & " /V /H /Y /S /E","",@SW_HIDE)

Hey, I have been searching a bit for a way to do some punycode conversion, i need to convert IDN domain names to their punycode counterpart. I found an example script that used a php tool on a website, but im wondering if it is possible to do this with au3 locally? Anyone got an idea or example script on how to do this?

Just a small update. The script Melba suggested works perfectly. Thnx a bunch!

You know.. that might actually do the trick! Going to test it as soon as a get a minute. It was a lot simpler than what i was expecting.. Awesome!

Hi Melba, Unfortunately, your script wont work, it dosnt take in account that something might already be in the clipboard, and thus, not show the input dialog, or at least thats how its working for me?. I think i may have to make some sort of tracker to track how old the clipboard data is, so it will be able to figure out if its a new selection, or some old stuff.

Well the text selection could happen in outlook, chrome, firefox, adobe reader, internet explorer.. or any similar program. I was hoping that some part of windows was aware that something was selected somewhere, and was able to tell me.

Hi, I have seen several topics regarding this, but none seems to hold the answer im looking for. Please forgive me if i have missed something. Im trying to automate part of a system to handle lookups of customer numbers, i want to automate is in a way so that autoit can accept input in the form of selected text if present, if not it should open a dialog window where the user can input the data to search for. The dialog part is working fine, but i can't seem to find a method for detecting if any text is currently marked. I can't use the clipboard, as this may already contain customer data, thus preventing the dialog from showing. I have no idea if this is at all possible, but im guessing there might be something in windows that knows if anything is marked.. Any feedback or alternative solutions are welcome.