Leaderboard

Hi all, just a little script I find useful. Always wanted to have an easy way to copy/mirror a complete folder with some kind of progressbar. Since robocopy is reliable and pre-installed in windows 10, it's the easiest way to achieve a copy of a folder. But there is no gui, the plain dosbox looks ugly... so I came up with this. It's a simple script, some would call it a stupid wrapper. The only interesting part of it is the ability to display progressbars for copied bytes and copied files. The script launches robocopy two times: at the first run, robocopy gets called with the /L Parameter, so it just logs what it WOULD do. So the script gathers the number of files and bytes which have to be processed. After that, robocopy gets called to actually do the job and the logfile is read out and compared to the total amount of files/bytes. Warning: there are two possible modes supported: copy and mirror. For gods and your own sake, if you don't know what "mirror" does, do not use this! Short Explanation: "mirror" will force the destination folder to be an exact copy of the source folder, so if there are files in the destination folder which are not in the source folder, robocopy will kill them without any warning! have fun, Marc robocopy.au3

PowerShell is portable on anything built in the last 10 years. If you are embedding passwords you're doing it wrong, regardless of the language you choose.

Actually you should be able to set the font size just using GuiCtrlSetFont() you can also change a rows color using GuiCtrlSetBgColor() (needs to be assigned to the listview item). If you only want a specific row colored, you can use _GUICtrlListView_GetItemParam(..) along with GuiCtrlSetBgColor(...), you would need to know the index though.

@Kelvin44, Seems this literally exact question has been asked many time on different forums so please don't waste any space here! Jos

Have you tried Melba23 listview udf this allows for large fonts and coloring etc...

np: We all have days like that, a second set of eyes usually helps. Best of luck.

Double personality ?

Glad to hear it works You could also try the %MyISNData% dir: C:\Users\%username%\Documents\ISN AutoIt Studio\Data\Properties Should also work (This path is the normal ISN-Profile of the user. All user defined stuff and settings goes here. Every global stuff for every user goes in the program directory)

I'm often supplied spreadsheets from other departments that contain data to drive my scripts. The problem that I often have is they like to apply cell formatting (Especially for Dates) which make it easy for them to use, but makes it crazy slow to open in my automation as I need to use the _Excel_RangeRead() with the Return option 3 and read one cell at a time. For some reason, today I realized I could cheat a bit and made it so much easier and quicker. I just opened the spreadsheet, then saved as a Tab delimited text file, then performed a _FileReadToArray() to get the actual displayed values. works so much faster than reading cell by cell. #include <File.au3> #include <Excel.au3> #include <Array.au3> Local $aRecords ;Will contain the data from the converted file $hFileLoc = FileOpenDialog("Spreadsheet Data", @ScriptDir, "Excel (*.xls;*.xlsx)") ;To select an Excel file If @error Then Exit $sDataFile = _TempFile(@TempDir, "~", ".txt") ;Create a temp file that will store the spreadsheet data ConsoleWrite("CSV file = (" & $sDataFile & ")" & @CRLF) ;So I can view it manually while testing ;*** Spreadsheet formatted as Numbers, Currency, Dates, etc. $oExcel = _Excel_Open(False, False, False, False, True) ;Open Excel a NEW excel app in Hidden mode $oWorkbook = _Excel_BookOpen($oExcel, $hFileLoc, True, False) ;Have Excel open the selected spreadsheet as Read Only _Excel_BookSaveAs($oWorkbook, $sDataFile, $xlTextWindows, True) ;Save as a Tab delimited text file; $xlCSVMSDOS for .csv if @error Then MsgBox(0, "Error", "Failed to Open the Excel file for reading") Exit EndIf _Excel_BookClose($oWorkbook, False) ;Close the selected spreadsheet _Excel_Close($oExcel, False) ;Close Excel If IsObj($oExcel) Then $oExcel.Quit ;Ensure the Excel actually closed _FileReadToArray($sDataFile, $aRecords, 0, @TAB) ;Read the newly created Tab delimited file into an array If @error Then MsgBox(0, "Error", "Failed to read the Excel data") Exit EndIf FileDelete($sDataFile) ;Remove the temp file since its in memory now ;This often brings over extra rows and columns so clean it up with this loop For $r = 0 to UBound($aRecords) - 1 If $aRecords[$r][0] = "" Then ;If A is empty on this row then assume we have reached the end of data ReDim $aRecords[$r][10] ;Remove extra rows, and in this case remove any columns after J ExitLoop EndIf Next _ArrayDisplay($aRecords, "Read Values")

I'm also experiencing this error. Anyone who knows why this is happening? Any help would be much appreciated. SAP version 7400.3.12.1130 AutoIt v3.3.14.5

The name is the same. and the error has changed..

Don't know, but it seems to be the same... Can't understand.