Search results 46

Sorted from new to old.
Card image
WorkbookNew_ANmar

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

Card image
WorkbookClose_ANmar

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

Card image
Base64encode + Base64decode

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

Card image
MySQL DB connection

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

Card image
FixENTERS_File

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

Card image
HTMLTag + HTMLPair

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

Card image
SettingRead_JR

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

Card image
CellRead

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

Card image
Reversefile

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

Card image
ANStrRead + ANStrSave + ANStrSearch

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

Card image
Modify SQL table

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

Card image
Replace Single Quotes

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

Card image
ArrayRead + ArraySave

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

Card image
Create and Write Log File

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