Similar codes
Register OCX in 64 and 32 bit
Copy and register ocx using cmd (DOS batch) in Windows 32bit and 64bit.
2020Feb9
UISetup + UIRestore
Simple way to freeze UI in Excel-VBA then restore it after complete in standard ...
2022Jan28
oShellRun1
Runs a WScript.Shell command with wait until finish and returns 0, 1, 2 or -1 ...
2018Jul6
DosCommand_Read
Get output of DOS Command in string, by reading output into temp text file, ...
2018Jun22
Permission Denied error
Issue: Trying to copy file (Using VB command FileCopy) while that file was ...
2018Sep26
Recently by developer
ANString_Location
Finds the location of a sting inside list of strings with certain separator, or ...
Tue 8AM
SettingSave + SettingRead for NumberFormat
Reads or applies certain NumberFormat to cell in settings. Same patterns as ...
Apr19
ANmaCellFormat
Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...
Apr18
CopyFields_FromTo
Moves strings within cells into other cells, move or copy. Specific task to ...
Apr17
Random Codes
UserChanged_Log4
Adds date to column1 when user enters text in column2. Also, if user remove ...
Nov28
OpenAnyFile
Finally, can have one command to open any file using its default associated app ...
2022Jan28
merge2Arrays
Merges two 1-dimension arrays and return an array Both should be 1 dimensional ...
2021Sep21
ANmaCopy_Objects
Copies objects from cell into cell Decide Sheet, and workbooks to copy from or ...
2020Nov11