Search results 213

Sorted from new to old.

WeekNum

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

2018Jun26

RemoveChars

Removes all chars found in Chars_to_remove from String1

2018Jun22

BinaryFile_Read + BinaryFile_Save

Reads binary file in chunks, if not chuck defined, all file will be red/saved ...

2018Jun18

EnvVar_All

Read all Environment variables using EnvDir_All Or quickly get user folder, or ...

2018Jun17

MatchIf_ThenDelete

Searches for an item in a column, then if found, delete that cell (not clear, ...

2018Jun17

MatchIf (aka VMatchIf)

The best Match I created, return 0 if not found, kind of CountIF+Match ...

2018Jun16

HardDrivePartitionSN

Get Hard drive SN (old fashioned way) using FileSystemObject

2018Jun15

BrowseFolder

Asks user for a folder tested in VBA of word as well as VBA in Excel

2018Jun14

ANStrRead + ANStrSave + ANStrSearch

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

2018Jun14

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

Multi-line Textbox focus bug

Trick to force textbox with multiple lines and scrollbars to refresh itself ...

2018Jun7

Filter_GotoItem

Allow users to select from list box based on search terms. Have a text box and ...

2018Jun7

RoundUp

Rounds a number up, like Excel function RoundUP

2018Jun2

CutRightString

Cuts a string from a string FROM RIGHT starting from specific character and ...

2018Jun2

CopyText2Clipboard

Copies text to clipboard using MSForms

2018May30

1 2 ...12 13 14