Search results 270

Sorted from new to old.

WeekNum

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

2018Jun26

CreateGUID

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

2018Jun25

TimeRound

Rounds the number of minutes to the nearest quarter of half like 4:32 to 4:30 ...

2018Jun25

ShowAgain2

Make selected item in listbox to be displayed at center of listbox after ...

2018Jun24

LogSheet_Add + LogSheet_Clear

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

2018Jun24

RowsCount

Get total number of rows for a certain worksheet in certain workbook workbook ...

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

InvertColor

Converts color into its negative value, as in "e4f15a" into "1C0FA6"

2018Jun20

Convert2SQLDate

Converts a date (numeric date) into Date acceptable by SQL, as in YYYY-MM-DD ...

2018Jun14

OpenPassword + ClosePassword

Encrypt / Decrypt a string, convert it to "77 96 105 105 106" or back to ...

2018Jun14

ListBox_SelectedIndexes

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

2018Jun11

FixPath, IsThere, IsThere1 ...

Set of 6 functions to deal with filesystem. Gets current workbook path, ...

2018Jun11

FileDate_Formatted

Using FileDateTime to get file date

2018Jun10

Filesin_Coll + Filesin_Cells

Reads files in a specified folder into a Collection, work with VB6 and VBA also, ...

2018Jun10

Frequency

Checks how many items in an ANStr ANStr is list of items separated by a ...

2018Jun8

1 2 ...16 17