Search results 181

Sorted from new to old.

CreateThumb_IrfanView

Creates a thumb of an image using IrfanView Thumbnail filename will have _th ...

2018Jul22

WorkbookSaveAsk_ANmar

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

2018Jul17

WorkbookOpenAsk_ANmar

Asks user to browse to a file and return full path and file name if they do, ...

2018Jul17

CreateZipFile_7Zip

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

2018Jul14

CreateZipFolder_7Zip

Creates a zip from folder using 7Z archive. 7za,exe (found in attached zip) ...

2018Jul14

FindFile

Finds if a workbook is open or not in same Excel session

2018Jul11

CreateFullTree

Creates full tree if not found

2018Jul9

Shapes-Macros

Read shapes in all worksheets in certain workbook and return list of macros ...

2018Jul9

WelcomeSheet

A User-Friendly way to ask user to enable macros. Showing an only sheet to let ...

2018Jul9

Import_CSV

Import the CSV file, DOES NOT OPEN, Open does not fix encoding issue, import ...

2018Jul7

oShellRun1

Runs a WScript.Shell command with wait until finish and returns 0, 1, 2 or -1 ...

2018Jul6

Cookies warning

Thanks to new law in Europe, we need to show users and let them accept a ...

2018Jul6

Active BS4 breakpoint

Was looking for some way to show bootstrap 4 breakpoint, and got this

2018Jul6

ServerVar

Get value of Server variable by passing variable name aVar can be any of these ...

2018Jul4

SortArea1

Sorts a range or area by 1 column given its cell address, with options to ...

2018Jul4

XorC

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

2018Jul1

1 2 ...10 11 12