DavidFromLafayette

Thanks for the feedback. Using Task Scheduler to call program under my network credentials. Added in the error checking from examples in help for those two functions. The _Excel_Read is where it is failing, but only when locked, with error code saying file not found. Changed the excel_read function to remote the HTTP test. Played with the visible and not visible settings and even trusted locations in Excel. Tried with XLSM file on network and on local hard drive with no success. Ended up just writing list of names to text file on network and that processes just fine.

My company is moving from WIN7 to WIN10, I have had a script that runs in the middle of the night, when the computer is locked, to open an Excel spreadsheet, read a few cells, and generate an email. This has worked fine under WIN7, when I try to run under WIN10 it freezes when it gets to a line to handle an array. When I run without the computer locked the script runs as expected. After doing a lot of investigating, it looks like the following line reads a "0" from the Excel file instead of a text string, only when the computer is locked. Any ideas? $Driver1 = _Excel_RangeRead($oWorkbook, "Template", "H12") This is how I am opening the Excel file: Local $oExcel = _Excel_Open(False) Sleep(10000) $oWorkbook = _Excel_BookOpen($oExcel, $sFilePath, True, False)

Thanks for the reply, I had thought about that but wasn't ready to commit the time to do that. What is strange is it appears to be working now both compiled and as a script. Only thing I did was comment parts from obsolete reports.

Let me add this to the confusion, if i run the script by hitting F5 it seems to work. If I compile and run it usually crashes. This is on a new Dell 7710 computer with eight cores, could the exe simply be running too fast for the Excel calls to keep up?

This morning I came in and a script i have been using for several years suddenly stopped working. Windows 7 64 bit, a new laptop but the script did work on this laptop before today. The script finds the most recent morning report in XLS format and then copies several columns to an array for usage later on. I wrote this using the Excel.AU3 referenced below, when Excel.AU3 was updated, I renamed the older version and used it without issue. ; Title .........: Microsoft Excel COM UDF library for AutoIt v3 ; AutoIt Version : 3.2.3++, Excel.au3 v 1.5 (07/18/2008 @ 8:25am PST) When I open the AU3 file it crashes in the _ExcelBookOpen in this step If .ActiveWorkbook.Sheets($i).Visible = $xlSheetVisible Then. I figured that out by inserting a bunch of consolewrite commands at each step. When I retrieved the relevant lines of code from my script and insert into a new AU3 file shown below it runs flawlessly each time. Any suggestions on where to go to troubleshoot this? #include <ExcelOld.au3> #include <array.au3> $LFTServiceFileName = "c:\temp\riglocations\LFT20161218UserReport_BoucDavW_DailyUpdate.xls" $oExcel = _ExcelBookOpen($LFTServiceFileName, 0) $aDailyActivityList = _ExcelReadSheetToArray($oExcel, 9, 2, 0, 8) _ArrayDisplay($aDailyActivityList) ExcelOld.au3

Question... I am trying to implement a simple click on the "save as" option in the IE 10 "Do you want to save or open..." pop-up. Is there a way to send the save as instruction directly to the pop-up? If not is there a way to programatically determine the location of the save pull down and then select the save as? Sorry don't know what the technical terms for these items are.

Looking for suggestions here.... I am trying to mirror a program's window that is on one display, probably minimized, and then show that same window on a second display. The second display is in a remote locaiton, hence the need to mirror and not just extend the desktop. Ultra mon looks like it could do it, but as soon as I minimzed the window it simply showed the tasktray icon. I had a look at a topic called Mirror Screen that makes me think it is possible, just need some suggestions on how to go about finding the correct window and how to scale and send to the second display. Any help or direction would be greatly appreciated.

Looking at the GraphGDIPlus option looks like it will work for me, but when I try to put the graph onto the tab I want to show it on it instead seems to be plotting behind the tab control.

I have an array, part of which is below, of 13 parameters based on time. What I would like to do is have an XY style plot with time running the Y axis and the 13 parameters plotted across the window. Any suggestions or "quick" ways to do this would be much appreciated. [0]|||||||||||||| [1]|2013-03-06 21:15:57.000| 0| NULL| NULL| NULL| NULL| NULL| NULL| NULL| NULL| NULL| NULL| NULL| [2]|2013-03-06 21:15:57.000| NULL| 0| NULL| NULL| NULL| NULL| NULL| NULL| NULL| NULL| NULL| NULL| [3]|2013-03-09 08:19:46.000| NULL| 0| NULL| NULL| NULL| NULL| NULL| NULL| NULL| NULL| NULL| NULL| [4]|2013-03-09 08:19:46.000| 0| NULL| NULL| NULL| NULL| NULL| NULL| NULL| NULL| NULL| NULL| NULL| [5]|2013-03-09 08:19:46.000| NULL| 0| NULL| NULL| NULL| NULL| NULL| NULL| NULL| NULL| NULL| NULL| [6]|2013-03-09 08:19:46.000| 0| NULL| NULL| NULL| NULL| NULL| NULL| NULL| NULL| NULL| NULL| NULL| [7]|2013-03-09 08:20:51.000| 0| NULL| NULL| NULL| NULL| NULL| NULL| NULL| NULL| NULL| NULL| NULL|

Question about email with two embedded screen captures (PNG files) and _OL_ItemSave When I try to use ItemSave I get a crash with ... D:Documents and SettingsboucdavwMy DocumentsAuto programsPrint Emailsoutlookex.au3 (3427) : ==> Array variable has incorrect number of subscripts or subscript dimension range exceeded.: If FileExists($sOL_Drive & $sOL_Dir & $sOL_FName & "_" & $aOL_Temp[1] & "_" & $iOL_Index2 & "." & $aOL_Temp[2]) = 0 Then ExitLoop If FileExists($sOL_Drive & $sOL_Dir & $sOL_FName & "_" & $aOL_Temp[1] & "_" & $iOL_Index2 & "." & ^ ERROR I ran _OL_ItemAttachmentget and returned the array below, [0]|2|7||||| [1]||Picture (Device Independent Bitmap)|||161|949613|6 [2]||Picture (Device Independent Bitmap)|||223|1025901|6 I am guessing there is something missing from the ItemAttachmentGet call that is causing the Itemsave to crash Any suggestions? Modified outlookex.udf with the following around line 3427 and seems to be working For $iOL_Index2 = 1 To 99 If $aOL_Temp[0] = 1 Then ;change ReDim $aOL_Temp[5] ;change $aOL_Temp[2] = "unknown" ;change EndIf ;change If FileExists($sOL_Drive & $sOL_Dir & $sOL_FName & "_" & $aOL_Temp[1] & "_" & $iOL_Index2 & "." & $aOL_Temp[2]) = 0 Then ExitLoop also modified line 3402, added a $sOL_FName = StringRegExpReplace($sOL_FName, '[ /:*?"<>|]', '_') ;change

DOH!!!!!!!! Had them in there from when using path names d:documents..... thanks

hopefully there is something simple and stupid i am doing wrong here. Below is a simple routine that in my mind would check for any open PST files and put them into an array and then go through and close all of those PST files. The array is displayed with all of the open PST files as folders that match the folder names in Outlook. But in the close section it doesn't recognize the folder name, see consolewrite output below code. Do you see anything obvious? thanks for looking #include <outlookex.au3> Global $oOutlook = _OL_Open() ConsoleWrite("asdf"&isobj($oOutlook) & @error & @extended & @CRLF) $bla = _OL_pstget($oOutlook) _ArrayDisplay($bla) For $k = 1 To $bla[0][0] ConsoleWrite("""" & $bla[$k][0] & """" & @CRLF) If Not $bla[$k][0] = "" Then $a = _OL_PSTclose($oOutlook, """" & $bla[$k][0] & """") ConsoleWrite("result" & $a & @error & @extended & @CRLF) EndIf Next _ol_close($oOutlook) asdf100 "SharePoint Lists" result02-2147352567 "2012 Jan to Jun Inbox" result02-2147352567

Version 0.7, will download and retest with 0.7.1

water: I think I finally got this working the way I want it, one question for you what is the fix for _ol_foldertree If StringStripWS($vOL_Folder, 3) = "" Then Return SetError(1, 0, "") being in the wrong location?

I have about 16 years of emails stored in about 30 individual PST files as part of our latest round of finger pointing and I told you that five years ago (yes Dilbert, Dogbert and the pointy haired boss really do exist). Does anyone have any suggestions on letting Outlook run say overnight load each PST, convert every email message to a PDF stored in seperate folders by year, month, and date of the message, and then close the PST files. Reason for doing this I figure it would be faster to do a keyword search on a series of PDF files indexed by Google Desktop than trying to load up all of these PST files and then letting Outlook do the seach. Any suggestons welcome thanks