Search results 62

Sorted from new to old.

Create summary list If you have SQL table named Table_Name, with DateAdded ...

2018Sep22

Copies range without using clipboard. Applies formats into a cell (or range) ...

2018Aug10

Gets a random image from a folder of files, passed as an unMapPathed (HTML) ...

2018Aug10

Trick to force textbox with multiple lines and scrollbars to refresh itself ...

2018Jul29

Asks user to save file (or workbook) using GetSaveAsFilename method. Returns ...

2018Jul17

Compress a single file into zip archive using 7Za.exe 7za.exe (found in ...

2018Jul14

Converts RGB color to / from HTML format As bonus, functions RGB_ExtractColor ...

2018Jul9

Sorts a column in Excel, easily, with options Expects ... Row 1 is header, ...

2018Jul4

Simple small function to Encrypt or Decrypt a string Test_XorC is for testing ...

2018Jul1

Adds Arabic unit to a number using proper Arabic grammar Units can be ...

2018Jun24

Returns true if VBA is accessible through code, returns false if not

2018Jun22

This script will take the results of a query and sets up number of records per ...

2018Apr18

Opens a textfile and shows contents

2018Apr18

Uses FSO to read, write, or append text in a file

2018Apr15