Tstudent

Is there a way (any service) to send an encrypted email with autoit? I currently use autoit with gmail (using the code I found on this forum), but clearly gmail is not encrypted. Thank you

which box should I check? Actually I wanted to convert the script to exe because I wanted to run it through windows task scheduler. But I found that you can run it even without converting it to exe. So at the moment I solved my problem like this.  

I have this script: the .au3 file works. However when I compile it stops working. Run the file in loop and the only way I have to get out of this situation is to restart the PC. I had read that it was necessary to insert the following line: #pragma compile(AutoItExecuteAllowed, True) however, it doesn't seem to change much. Do you have any suggestions?

Thanks this exmple helpd me. Found my solution

Hello, i have a directory with about 50 .csv files. I want to delete last row for each of them. Can you suggest a script that automate this action? Is it possible? My best alternative is to do this manually one by one. Thank you

If i use $oExcel = _ExcelBookOpen($file, 1) an excel Addin that i have doesn't work properly. It load, but doesn't work!!! The only way to have addin working is to use: Run('"c:\EXCELPATH\Office14\EXCEL.EXE" "c:\Path\MyFile.xlsm"') If i run "MyFile.xlsm" in this way the addin WORKS!!! My problem is that i need to select a sheet I try this: $oExcel = ObjGet("","Excel.Application") _ExcelSheetActivate($oExcel, $vSheet) But $vSheet is not activated If i use _ExcelSheetActivate($oExcel, $vSheet) after _ExcelBookOpen($file, 1) it works properly Do you have any suggestions please? Thank you

Found the solution. Paste here for other interested users of this beautiful forum: $oExcel = ObjGet("", "Excel.Application") For $element In $oExcel.Application.Workbooks If $element.FullName <> "" Then MsgBox(0,"",$element.FullName) $element.Save $element.Close Else $element.Activate $oExcel.Application.Dialogs(5).Show EndIf Next $oExcel.Application.Quit

Thank you very much. I have another question, don't know if it is possible. Before run excel file i want (with _ExcelBookOpen($file, 1)) i want to check if, accidentally, there are other excel files already open. In that case i want close all of them (saving before exit). Is possible to do this check and close all other excel files eventually opened? Thanks

What i would like to do is: 1) Open an excel file // no problem, this is very simple 2) wait for excel file completely load // i can use sleep function and use a very long time to be sure 3) run an excel macro called "mymacro1" // i don't know how to do this Can you give me the correct sintax for point three? thank you

Is possible to write some code for "enable/disable" a scheduled tasks? The same effect of: 1) go in scheduled task 2) righ click on a particular task 3) click on "enabled" in the bottom My objective is to automatize this process with a single click on autoit script. Thank you

Thank you, works very well. I have modified this code because i want add another check: i want that day, month and year of "FileA.xls" are equal to CURRENT day, month and year. #include <Date.au3> $sFileToCheck = "c:\AAA.xlsx" $sFileToRun = "c:\BBB.bat" $tCur = _Date_Time_GetLocalTime() $aCur = _Date_Time_FileTimeToArray($tCur) While 1 $aFileTime = FileGetTime($sFileToCheck) If IsArray($aFileTime) Then If $aFileTime[0] = $aCur[0] and $aFileTime[1] = $aCur[1] and $aFileTime[2] = $aCur[2] And $aFileTime[3] = 21 and $aFileTime[4] >= 41 Then Run($sFileToRun,"c:\") ExitLoop Else Sleep(10000) EndIf EndIf WEnd But day, month, year check doesn't work. Any ideas? Thank you

Please, can you show me the most efficent way to do this? i want to launch a file, but only if the time of another file is > then 09:00 pm In another words: if the time (last saved) of "fileA.xls" is > then 09:00pm then open "fileB.bat" otherwise wait 1 minute and restart the control until the time condition is verified. Is possible to do this with autoit? Thank you

Winclose doesn't work because it require a window title that in this case doesn't exist. Processclose is too brutal and doesn't close correctly a program. I have found a solution utilizing the code of Melba. Thank you

I have a windows application that when i click on "minimize" is reduced to icon tray (lower right corner). What i want is to close that program. But i want to close it normally (the same as click on X button), not brutally kill process. Is it possible with AutoIt? I could code a double left mouse click on the program's icon in the tray and after use winclose(title). The problem is that the position of the icon (in the icon tray) isn't always the same. Is there a more elegant and effective solution? Thank you

Thank you, it works perfectly