Search results 116

Card image cap
DosCommand_Read

Get output of DOS Command in string, by reading output into temp text file, ...

Card image cap
RunFromTemp

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

Card image cap
EnvVar_All

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

Card image cap
CellRead

Reads a value giving column, row, sheet and workbook name Accepts up to 2 ...

Card image cap
Reversefile

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

Card image cap
ANStrRead + ANStrSave + ANStrSearch

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

Card image cap
Modify SQL table

SQL seams to have issues when we try to modify a table and preserving data, I ...

Card image cap
DB_Setting1List + DB_Setting1List_NameValue

DB_Setting1List is to Returns list of SettingValues matching certain ...

Card image cap
DB_Setting2Read + DB_Setting2Save

Reads and save setting into settings table per 2 IDs, similar to SettingRead ...

Card image cap
CopyText2Clipboard

Copies text to clipboard using MSForms

Card image cap
Connect to UDL

Use a UDL to make your connection to a database

Card image cap
Navigate

Downloads a certain page source into a variable, full content in HTML, using ...