Search results 47

Sorted from new to old.

Adds Validation drop-down to a cell (Data --> Validation --> List), or to a ...

2018Aug10

Creates new workbook (does not save it) and returns filename.

2018Aug9

Closes a workbook, checks if it is already open first, works for workbooks ...

2018Aug9

Encodes and decodes a string, Base64 is used to convert binary data (like ...

2018Jul31

Connects to MySQL database from Classic ASP All DB variables need to be ...

2018Jul29

Removes [Enter]s from imported csv file into Excel worksheet. Smart enough to ...

2018Jul7

Generate HTML tags with thier parameters as name=value pairs ' Example of ...

2018Jun30

Reads setting saved in columns J:R Just like SettingRead, but when we have ...

2018Jun26

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

2018Jun16

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

2018Jun16

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

2018Jun14

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

2018Jun9

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

2018Apr16

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

2018Apr15

The subprocedure can be called by any ASP applicaiton/page which needs to ...

2018Apr14