Search results 180

Sorted from new to old.
Card image
WorkbookSaveAsk_ANmar

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

Card image
WorkbookOpenAsk_ANmar

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

Card image
CreateZipFile_7Zip

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

Card image
CreateZipFolder_7Zip

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

Card image
FindFile

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

Card image
CreateFullTree

Creates full tree if not found

Card image
Shapes-Macros

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

Card image
WelcomeSheet

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

Card image
Import_CSV

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

Card image
oShellRun1

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

Card image
Cookies warning

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

Card image
Active BS4 breakpoint

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

Card image
ServerVar

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

Card image
SortArea1

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

Card image
XorC

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

Card image
Page area and Page Setup functions (Unfinished)

Clear Excel print area, or set it, or read it, along with Page setup commands ...