Search results 399

Sorted from new to old.

CellSave (SimpleSave)

Saves value to cell without deformation and converting Used to be called ...

2018Jun26

WeekNum

Generates the calendar week number for a certain date, counting the first week ...

2018Jun26

SettingRead_JR

Reads setting saved in columns J:R Just like SettingRead, but when we have ...

2018Jun26

CellRead (SimpleLookup)

Simply reading a value from a specific cell from a sheet from a workbook ...

2018Jun25

CreateGUID

Generate random GUID of 36 chars (with or without brackets) using TypeLib ...

2018Jun25

ANBS controls

Set of functions to generate Bootstrap controls as strings. Controls available ...

2018Jun24

AreTheyTheSame

Compares between two files in binary mode and returns true if they are ...

2018Jun20

File_FirstFound

Gets first file found matches a wildcards mask, using Dir()

2018Jun20

confirmDelete

Asks user before running a link (mostly before deleting) Small important part ...

2018Jun19

ScreenRes

Reads screen resolution, using IE this time, this one will get the active ...

2018Jun17

ScreenResolution_wxhxtxl

Detects active desktop screen resolution and location of taskbar (with some ...

2018Jun17

RunFromTemp

Check if an Excel file is running from 'Temp' location or regular folder This ...

2018Jun17

Reversefile

Reversing a file This tip demonstrates how to reverse a whole file. This ...

2018Jun16

Crypt128

Simple small function to Encrypt or Decrypt a string in cell Simple Encryption ...

2018Jun14

ANStrRead + ANStrSave + ANStrSearch

Reads and saves data into 1 dim string array, ANStr ANStr is a string of list ...

2018Jun14

ListBox_SelectedIndexes

Create list of selected items in MSForms listbox as string separated by | Or ...

2018Jun11

1 2 ...23 24 25