Search results 471

Sorted from new to old.

Shapes-Macros

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

2018Jul9

LoadPicture_Safe

Loads an image into VBA image control without knowing its extension If file ...

2018Jul7

FixENTERS_File

Removes [Enter]s from imported csv file into Excel worksheet. Smart enough to ...

2018Jul7

SwapDate

Changes date format from US to International or from international to US. ...

2018Jul5

Sort1Col

Sorts a column in Excel, easily, with options

2018Jul4

FormulasFlatten

Fill in formulas from 1st row, then convert them to flat values to avoid Excel ...

2018Jun30

WordsOf + Words_Len

WordsOf to create list of words from a block after converting every special ...

2018Jun28

Distance_Calc_fromString

Calculate distance between two points (Latitude, Longitude) LatLon1 and ...

2018Jun27

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

FS_CopyFile

Copies a file

2018Jun24

LogSheet_Add + LogSheet_Clear

2 Functions LogSheet_Add and LogSheet_Clear to add new entry to log or clear ...

2018Jun24

RemoveChars

Removes all chars found in Chars_to_remove from String1

2018Jun22

GetTimeZone

Get local timezone Uses w32tm / tz dos command in command prompt Using ...

2018Jun22

GetUTC

Get the time and date in Universal time based on local time Uses w32tm / tz ...

2018Jun22

RunFromTemp

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

2018Jun17

1 2 ...27 ...29 30