Search results 130

Sorted from new to old.

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

Replace Single Quotes

This script will replace single quotes so the data is SQL-safe

2018Apr16

ArrayRead + ArraySave

Reading and saving 2 dim data into ANStrArray ANStrArray is a string ...

2018Apr15

1 2 ...8 9