exodius

I realized that I had the wrong constant for xlCellValue - I should have had 1

Hi, Can someone help me with how to translate this correctly? I've been working on it for a few hours and I just can't quite get it right. Columns("G:G").Select Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlEqual, _ Formula1:="=""Purchase""" Selection.FormatConditions(Selection.FormatConditions.Count).SetFirstPriority With Selection.FormatConditions(1).Font .Color = -16383844 .TintAndShade = 0 End With With Selection.FormatConditions(1).Interior .PatternColorIndex = xlAutomatic .Color = 13551615 .TintAndShade = 0 End With Selection.FormatConditions(1).StopIfTrue = False I think I'll be fine after the .Add line, I just cannot get it to work. Here's what I've been trying: $oExcel.Selection.FormatConditions.Add(9, 3, "=""Purchase""", '') ;Type:=xlCellValue, Operator:=xlEqual, Formula1:="=""Purchase""" Any help is definitely appreciated!

I should have mentioned, I'm using v3.3.12.0 on Windows 7 64 bit - I have the issue regardless of whether I compile in 32/64 bit.

I have no idea if this is just an issue for me or if anyone can help - Googling the issue didn't yield me much in the way of answers. I have several scripts that are all very dependent on writing to a network drive to collaborate with each other, and I'm surmising that periodically we have a brief network connectivity issue that causes them all to crash. (this is just my theory) When they crash, I get error windows that look like the following. Does anyone have any ideas on any solutions? Or am I just stuck? Thanks! Problem signature: Problem Event Name: InPageError Error Status Code: c000020c Faulting Media Type: 00000000 OS Version: 6.1.7601.2.1.0.256.4 Locale ID: 1033 Additional Information 1: 418d Additional Information 2: 418d79335d4cff81a1979d56f38ebe70 Additional Information 3: fbfc Additional Information 4: fbfc2b6e29523fb831f516cd3c083bea Problem signature: Problem Event Name: InPageError Error Status Code: c000020c Faulting Media Type: 00000000 OS Version: 6.1.7601.2.1.0.256.4 Locale ID: 1033 Additional Information 1: abcc Additional Information 2: abcc8f7853b48d9807d6d51eb1fa5df9 Additional Information 3: abcc Additional Information 4: abcc8f7853b48d9807d6d51eb1fa5df9

Thanks

Okay, maybe I'm crazy, but is the following an issue with _ArrayMin in version 3.3.12.0 Stable? Or am I just doing something wrong? If I run _ArrayMin against a single item array I don't get any return value back and @error returns as 5 ($aArray is empty) If I run it against a two item array it works fine. #include <Array.au3> Global $aTest[1] $aTest[0] = 1 ;~ _ArrayDisplay($aTest) $vMin = _ArrayMin($aTest) ConsoleWrite("Minimum Value: " & $vMin & @TAB & "@error: " & @error & @LF) Global $aTest[2] $aTest[0] = 1 $aTest[1] = 2 ;~ _ArrayDisplay($aTest) $vMin = _ArrayMin($aTest) ConsoleWrite("Minimum Value: " & $vMin & @TAB & "@error: " & @error & @LF)

I noticed (actually Google Now told me, which is pretty sweet) that AutoIt v3.3.12.0 was just released - I was wondering if SciTE has been updated to match yet or if that's still coming. I noticed on the SciTE download page that it says it was updated on 5/31/2014 and "Definition files included: AutoIt v3.3.10.2 and BETA v3.3.11.5". Thanks!

He's writing a paper - as in the college/university sense where you have to learn/research a subject and then write about it (typically for a grade for a class).

This page probably contains the answer you're looking for, but I guess it depends on what you mean by "supports" http://en.wikipedia.org/wiki/Variant_type

See if this posts helps you: I posted it to show how you can use Access as a medium to script things on SharePoint, but you can probably make it fit your situation.

What exactly do you want to do to that file? You most likely don't need to simulate left-clicking it to accomplish what you want to do.

Try WinGetText or ControlGetText

Try this to see the entirety of your array: _ArrayDisplay($adObj) And try this to see the one element you want (you'll need to change the #'s): MsgBox(0, '', $adObj[3][9])

Well done.

Or use _GUICtrlListView_GetItemText or _GUICtrlListView_GetItemTextArray...