Leaderboard

AutoIt v3.3.15.3 Beta View File 3.3.15.3 (16th May, 2020) (Beta) AutoIt: - Added #3681: Lang Variable prefix "o". - Fixed #2915: Map memory leak. - Fixed: Map errors with index < 0. UDFs: - Changed #3620: Removed "stable" from _ArraySort function header. - Added #3670: DriveGetDrive() @error doc clarification. - Added #3574: GuiCtrlCreateInput() Doc $ES_AUTOHSCROLL precision. - Fixed: Problem with _WinAPI_GetFontResourceInfo & _WinAPI_GetFontMemoryResourceInfo - Fixed #3728: Added optional parameter to force single column 2D array to 1D. - Fixed #3678: Amended Help file to show that function with no text blanks a line, not removes it. - Fixed #3757: Added note to GUICtrlListView_SetColor* pages about need to use BGR format. - Fixed #3697: _WinAPI_GetOverlappedResult() failure. Submitter Jon Submitted 05/16/2020 Category Beta  

mmm... zip file as in "let's not use the installer and have everything properly set for me and then post having issues".. Seriously: When installed properly, the last settings are restored from the SciTE.session file : # SciTE session file position.left=105 position.top=5 position.width=1712 position.height=1028 position.maximize=1 which is stored in the directory indicated by the environment variable SCITE_USERHOME.

The first thing that I would suggest would be to temporarily (or permanently) add additional logging information the the excel.au3 udf's __Excel_COMErrFunc() so that you may be able to find out more about why the error is occurring. You should be able to replace the function with something like the one below, which will write additional COM information to the console when an error occurs. Beyond that, one would have to see your script to see if there is an issue that needs to be addressed or whether some additional defensive coding needs to be added to avoid such errors. Hopefully your script has sufficient status logging so you can tell which record or records are being worked on when the error occurs. If not, it should because without it, trying to trouble shoot random errors is much more difficult. Func __Excel_COMErrFunc($oComErr) Local $sErrMsg With $oComErr $sErrMsg = @CRLF $sErrMsg &= ">>> COM ERROR <<<" & @CRLF $sErrMsg &= StringFormat("Script Line Number : %s", .ScriptLine) & @CRLF $sErrMsg &= StringFormat("HRESULT : 0x%x (%s)", .Number, .Number) & @CRLF $sErrMsg &= StringFormat("Windows Error : %s", StringStripWS(.WinDescription, $STR_STRIPTRAILING)) & @CRLF $sErrMsg &= StringFormat("Object Description : %s", StringStripWS(.Description, $STR_STRIPTRAILING)) & @CRLF $sErrMsg &= StringFormat("GetLastError() : %s", .LastDllError) & @CRLF EndWith ConsoleWrite($sErrMsg) Return EndFunc

I’m currently on vacation and will reply this weekend. But if I remember correctly the example script for _OL_ItemCreate or one of the wrapper functions has code to retrieve the current user.

https://docs.microsoft.com/en-us/windows/win32/inputdev/wm-activate

Unfortunately, your script needs to be elevated to Admin to be able to send ALT+F in the Task Manager. If you add #RequireAdmin to the top of your script, you will see that it works. I know that it sort of defeats the purpose though because if your script is elevated when you run Powershell, it will start as Admin. If you are an Admin and do not want to get prompted by UAC when you request elevation, then you need to modify the registry or you can change the setting using the Windows GUI. If you use the GUI, move the setting to "Never Notify" If you want to make the change programtically, then you can look up the key(s) or you can use the UAC UDF (link below). #RequireAdmin #include <Constants.au3> ;Launch Task Manager Send("^+{esc}") If Not WinWaitActive("[regexptitle:Task Manager]", "", 3) Then Exit MsgBox($MB_ICONERROR, "ERROR", "Timeout occurred waiting for Task Manager") ;Run Powershell as Admin Send("!fn") Sleep(500) Send("Powershell") Send("{TAB}{SPACE}{TAB}{ENTER}") https://www.autoitscript.com/forum/topic/158377-user-account-control-uac-udf/

so, in case you were wondering ... full-featured PST to MSG converter check it out: http://sourceforge.net/projects/olbreak/files/v2.0/ the download file is "OLBreak.exe", launch it without command-line parameters to get the ReadMe, which is also displayed in the link. it begins like this: Summary ~~~~~~~~ OLBreak is a PST to MSG converter for Outlook. it converts Outlook mail store to its elements as MSG files, maintaining folders structure. Features ~~~~~~~~~ * Duplicates Filtering * Accumulative or Differential Processing * Invalid Characters Handling * Automation-Ready by Command-Line Parameters and Exit Codes * Detailed Logging * Exchange Mailbox Support * Automatically Acknowledge Outlook Security Warnings * Portable, Open-Source, and Free for any use

This UDF checks if there is a file in the clipboard or not, it is only tested on windwos xp SP2.... if you find any bugs let me know Func _file_in_clipboard() DllCall("User32.dll", "int", "OpenClipboard", "hwnd", "") $file=DllCall("User32.dll", "int", "EnumClipboardFormats", "int", 49158) DllCall("User32.dll", "int", "CloseClipboard") If $file[0]=49159 Then Return 1 Else Return 0 EndIf EndFunc

To be on the safe side, you might want to do this first before checking (in case number values change): $iCF_FileNameW=_ClipBoard_RegisterFormat("FileNameW") If _ClipBoard_IsFormatAvailable($iCF_FileNameW) Then $bFileInClipboard=True Also, a slightly modified version of the Help file script for Function _ClipBoard_EnumFormats which will show the numbers of the formats: #include <GuiConstantsEx.au3> #include <ClipBoard.au3> #include <WinAPI.au3> #include <WindowsConstants.au3> Opt('MustDeclareVars', 1) Global $iMemo _Main() Func _Main() Local $hGUI, $iFormat, $iCount ; Create GUI $hGUI = GUICreate("Clipboard", 600, 400) $iMemo = GUICtrlCreateEdit("", 2, 2, 596, 396, $WS_VSCROLL) GUICtrlSetFont($iMemo, 9, 400, 0, "Courier New") GUISetState() ; Open the clipboard If Not _ClipBoard_Open ($hGUI) Then _WinAPI_ShowError ("_ClipBoard_Open failed") ; Show clipboard formats available MemoWrite("Clipboard formats ..: " & _ClipBoard_CountFormats ()) ; Enumerate clipboard formats Do $iFormat = _ClipBoard_EnumFormats ($iFormat) If $iFormat <> 0 Then $iCount += 1 MemoWrite("Clipboard format " & $iCount & " Number:"&$iFormat&" String: " & _ClipBoard_FormatStr ($iFormat)) EndIf Until $iFormat = 0 ; Close the clipboard _ClipBoard_Close () ; Loop until user exits Do Until GUIGetMsg() = $GUI_EVENT_CLOSE EndFunc ;==>_Main ; Write message to memo Func MemoWrite($sMessage = "") GUICtrlSetData($iMemo, $sMessage & @CRLF, 1) EndFunc ;==>MemoWrite

Copied to clipboard files are also plain text, but of a special format so that Windows knows they're meant for a copy/cut & paste operation. Start this and copy a plain text to clipboard (text / your function will trigger), a file or more files (text / both function will trigger) and finally copy picture content (Bitmap(?) / no function will trigger). ClipPut("") While 1 Sleep(1000) ConsoleWrite(TimerInit() & @tab & "_ClipCheck()" & @TAB & @TAB & _ClipCheck() & @CRLF) ConsoleWrite(TimerInit() & @tab & "_file_in_clipboard()" & @TAB & _file_in_clipboard() & @CRLF) WEnd Func _ClipCheck() $Clip = ClipGet() If $Clip = "" Then Return 0 Return 1 EndFunc ;==>_ClipCheck Func _file_in_clipboard() DllCall("User32.dll", "int", "OpenClipboard", "hwnd", "") $file=DllCall("User32.dll", "int", "EnumClipboardFormats", "int", 49158) DllCall("User32.dll", "int", "CloseClipboard") If $file[0]=49159 Then Return 1 Else Return 0 EndIf EndFunc

Tried with a multitude of different file types, including folders, and it seems to work flawlessly from what I could tell. I could see this being quite useful as a safety-checking function (or error handling/prevention) for lots of different scripts that rely on the clipboard in some way or another; Nice work.