Jump to content

Leaderboard

Popular Content

Showing content with the highest reputation on 05/07/2017 in all areas

  1. DigDeep, See this... kylomas
    1 point
  2. @Czardas - tongue in cheek..
    1 point
  3. There are 2 matches in the string, so the regex must be written depending on the one you want Local $str = 'Update for Microsoft Outlook Social Connector 2010 (KB2553308) KB234567 32-Bit Edition' ; this will get the first one MsgBox(0,'', StringRegExpReplace($str, '(?i).*?(KB[[:digit:]]{5,}).*', "$1")) ; this will get the last one MsgBox(0,'', StringRegExpReplace($str, '(?i).*(KB[[:digit:]]{5,}).*', "$1"))
    1 point
  4. MsgBox(0,'', StringRegExpReplace($str, '(?i).*?(KB[[:digit:]]{5,}).*?$', "$1")) ; trying do do it with a one liner
    1 point
  5. Subz

    Excel - Freeze the top row

    Couple of ways: #include <Excel.au3> ;~ Example 1 Local $oExcel = _Excel_Open() $oExcel.ActiveWindow.FreezePanes = False Local $sWorkbook = @ScriptDir & "\FileName.xlsx" Local $oWorkbook = _Excel_BookOpen($oExcel, $sWorkbook) $oWorkbook.ActiveSheet.Range("B2").Select $oExcel.ActiveWindow.FreezePanes = True ;~ Example 2 Local $oExcel = _Excel_Open() $oExcel.ActiveWindow.FreezePanes = False Local $sWorkbook = @ScriptDir & "\FileName.xlsx" Local $oWorkbook = _Excel_BookOpen($oExcel, $sWorkbook) _Excel_FreezePanes($oExcel, 2, 2) Func _Excel_FreezePanes($oExcel, $iCol = 0, $iRow = 1) If Not IsObj($oExcel) Or ObjName($oExcel, 1) <> "_Application" Then Return $oExcel.ActiveWindow.SplitColumn = $iCol $oExcel.ActiveWindow.SplitRow = $iRow $oExcel.ActiveWindow.FreezePanes = True EndFunc
    1 point
  6. trancexx

    WinHTTP functions

    ^^ Well, it could be that default global WinHttp proxy setting was changed on your system by you or someone. Try running the help file example for _WinHttpSetStatusCallback and post the console output here. Just change hConnect line to $hConnect = _WinHttpConnect($hOpen, "autoit.de").
    1 point
×
×
  • Create New...