Search results 1,150

Sorted from new to old.

DirsCombo_Read

Read directories in a specified folder into a combobox Needs FrmBr having Cbo1

2018Jun18

ScreenResolution_wxhxtxl

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

2018Jun17

EnvVar_All

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

2018Jun17

Match2

Matching by two values at the same time in two columns Just like Match the ...

2018Jun16

MatchIf (aka VMatchIf)

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

2018Jun16

Reversefile

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

2018Jun16

File_MostRecent

Getting most recent file in a folder

2018Jun16

WorkbookOpen_ANmar

Opens Workbook in the background with no flickering and with options of ... ...

2018Jun16

BrowseWorkbook + BrowseWorkbook_Save

Asks for Excel file to open, then return the full filename with path if ...

2018Jun16

HardDrivePartitionSN

Get Hard drive SN (old fashioned way) using FileSystemObject

2018Jun15

Convert2SQLDate

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

2018Jun14

BrowseFolder

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

2018Jun14

Crypt128

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

2018Jun14

OpenPassword + ClosePassword

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

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 ...66 ...71 72