Jump to content

SkysLastChance

Active Members
 View Profile  See their activity

  • Posts

    328

  • Joined

  • Last visited

Community Answers

  1. SkysLastChance
    SkysLastChance's post in running script in Scite getting >Access is denied? was marked as the answer   
    Oh, I see. Do you have any antivirus installed? If so, you may want to disable it and try running your code again. That's where my head goes.
  2. SkysLastChance
    SkysLastChance's post in send pipe character "|" was marked as the answer   
    Send("{ASC 124}") https://www.ascii-code.com/124
  3. SkysLastChance
    SkysLastChance's post in When using MSEdgeDriver.exe 1st user sees two browser windows while the 2nd user sees nothing was marked as the answer   
    You need to strip out the code you don't need in the #include <ConnView.au3>  
    You need to add. 
    _WD_Option('DriverParams', '--verbose --port=' & $portEdge & ' --log-path="' & @ScriptDir & '\edge.log"') Are you sure you don't want to run?
    $sSession = _WD_CreateSession($sCapabilities) Thoese are the ones you are returning however, you are creating the session with $sDesiredCapabilities
     
    Couple other things that might help. Make sure you don't already have edge open befor you run the script. 
    Rename the msedgedriver.exe for each user. I.E. (msedgedriver1.exe and msedgedriver2.exe) 
  4. SkysLastChance
    SkysLastChance's post in _WinAPI_ReadDirectoryChanges Error 58 was marked as the answer   
    I feel dumb. RTFM
    "If the buffer is greater than 64 KB and the application is monitoring a directory over the network, the function fails. This is due to a packet size limitation with the underlying file sharing protocols."  
    #include <APIFilesConstants.au3> #include <Array.au3> #include <AutoItConstants.au3> #include <MsgBoxConstants.au3> #include <WinAPIError.au3> #include <WinAPIFiles.au3> #include <WinAPIMem.au3> Global $g_sPath = "J:\Folder\SubFolder1\SubFolder2" Local $hDirectory = _WinAPI_CreateFileEx($g_sPath, $OPEN_EXISTING, $FILE_LIST_DIRECTORY, BitOR($FILE_SHARE_READ, $FILE_SHARE_WRITE), $FILE_FLAG_BACKUP_SEMANTICS) If @error Then _WinAPI_ShowLastError('', 1) EndIf Local $pBuffer = _WinAPI_CreateBuffer(65536) Local $aData While 1 $aData = _WinAPI_ReadDirectoryChanges($hDirectory, BitOR($FILE_NOTIFY_CHANGE_FILE_NAME, $FILE_NOTIFY_CHANGE_DIR_NAME), $pBuffer, 65536, 1) If Not @error Then _ArrayDisplay($aData, '_WinAPI_ReadDirectoryChanges') Else _WinAPI_ShowLastError('', 1) EndIf WEnd
     
  5. SkysLastChance
    SkysLastChance's post in OutlookEX _OL_ItemRecipientAdd --- Recipient Showing Blank in Variables was marked as the answer   
    Msgbox(0,"Variable",$vSenderAdd.PrimarySmtpAddress) Thank you both. I just needed that little nudge.
  6. SkysLastChance
    SkysLastChance's post in Highlighting Filtred Data Only - Exclude Header was marked as the answer   
    Local $xlup = -4162 $LastRow = $oWorkbook.ActiveSheet.Range("A1000000").End($xlup).Row $oExcel.ActiveSheet.AutoFilter.Range.Rows("2:" & $LastRow).Columns(30).SpecialCells($xlCellTypeVisible).Interior.ColorIndex = 37 $oExcel.ActiveSheet.AutoFilter.Range.Rows("2:" & $LastRow).Columns(30).SpecialCells($xlCellTypeVisible).Value = 0 This seemed to do the trick. 
  7. SkysLastChance
    SkysLastChance's post in _Excel_RangeWrite Formula with variable was marked as the answer   
    Figured it out.
    #include <Excel.au3> Local $oExcel = _Excel_Open() Local $oWorkbook = _Excel_BookNew($oExcel) $vPath = "'J:\Temporary Files\FolderName\FileName.xlsx'!$A:$B,2,0))" _Excel_RangeWrite($oWorkBook, Default, '=IF(D2=D1,"",VLOOKUP(D2,''J:\Temporary Files\FolderName\FileName.xlsx''!$A:$B,2,0))', "A3", False) ;Line 1 _Excel_RangeWrite($oWorkBook, Default, '=IF(D2=D1,"",VLOOKUP(D2,' & $vPath, "A4", False) ;Line 2  
×
×
  • Create New...