Search results 132

Sorted from new to old.

DosCommand_Read

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

2018Jun22

RunFromTemp

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

2018Jun17

EnvVar_All

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

2018Jun17

CellRead

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

2018Jun16

Reversefile

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

2018Jun16

ANStrRead + ANStrSave + ANStrSearch

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

2018Jun14

Modify SQL table

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

2018Jun9

DB_Setting1List + DB_Setting1List_NameValue

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

2018May31

DB_Setting2Read + DB_Setting2Save

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

2018May31

CopyText2Clipboard

Copies text to clipboard using MSForms

2018May30

Connect to UDL

Use a UDL to make your connection to a database

2018May27

Navigate

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

2018May22

DB_AllRows

Returns all rows found from an SQL Query as string Separated by row and column ...

2018Apr23

DB_Read1Row (DB_Read1stRow)

Reads from a table in a DB Reads only the first row, and return a string ...

2018Apr21

Str2DB + Str2App + Str2HTML

Set of functions to clean and revise cleaning of string before saving into ...

2018Apr21

Paging with Alternating Colors

This script will take the results of a query and sets up number of records per ...

2018Apr18

1 2 ...8 9