ANmarAmdeen 402

Card image cap
Reversefile

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

Card image cap
File_MostRecent

Getting most recent file in a folder

Card image cap
WorkbookOpen_ANmar

Opens Workbook without running AutoMacros and without letting the user know ...

Card image cap
BrowseWorkbook + BrowseWorkbook_Save

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

Card image cap
WaitFor + ShellWait

Tell App to wait for number of seconds and Execute command and wait for it ...

Card image cap
ColumnName (newer version of ColumnName_XOffset)

Gets the column name from a cell address. Returns "E" from "E45", or "BR" from ...

Card image cap
HardDrivePartitionSN

Get Hard drive SN (old fashioned way) using FileSystemObject

Card image cap
Convert2SQLDate

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

Card image cap
BrowseFolder

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

Card image cap
Crypt128

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

Card image cap
OpenPassword + ClosePassword

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

Card image cap
ANStrRead + ANStrSave + ANStrSearch

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