- 1. AutoHotkey: App GUI Listview to Rename Files
- / AutoHotkey /
- ... if (v_Text == v_Filename) v_AlreadyExists++ } Return v_AlreadyExists } ; -------------------------------------------------------------------------------------- ; SubRoutine: ...
- Created on 08 July 2020
- 2. Autohotkey - Chrome Profiles in Alphabetical Order
- / AutoHotkey /
- ... extract value. Hide the first column in the list view (contains "Profile 1", "Profile 2", ...) Sort the second column (contains "Joes Personal Profile", "Joes Work Profile", etc) Create subroutine for ...
- Created on 07 January 2020
- 3. MS Excel - Split Workbook into separate files per sheet
- / Excel /
- ... following script is made of 4/5 subroutines. Follow the instructions above on how to execute a vbscript and then paste the below into the developer window. Ensure that your mouse cursor has focus in ...
- Created on 11 February 2019
- 4. AutoHotkey: Check Windows Folder Sizes
- / AutoHotkey /
- ... Subroutine: LoopThrough: loops through folders and counts file sizes (including subfolders) LoopThrough: SB_SetText("Reading current directory...") vTotalSize = 0 Loop, Files, %MyBaseDir%\*, F { ...
- Created on 28 January 2019
- 5. SSRS Hide results table if empty
- / SQL Server Reporting Services /
- ... MySQL where you can do iteration within the query (SELECT @ncount:=@ncount+1), we're stuck with T-SQL. Ask Google how to iterate in T-SQL and you're confined to functions, temporary tables or little subroutines ...
- Created on 29 March 2011