Search results 49

  2. Search results
  3. data and structure
Sorted from new to old.
Card image
CSSFlowChart

Shows a chart with links, nice sitemap maybe, or just easy way to show ...

2018Aug14
Card image
ApplyValidation_DropDown

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

2018Aug10
Card image
WorkbookNew_ANmar

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

2018Aug9
Card image
WorkbookClose_ANmar

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

2018Aug9
Card image
Base64encode + Base64decode

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

2018Jul31
Card image
MySQL DB connection

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

2018Jul29
Card image
FaceIDs

Excel menu icons and icon ids (named FaceIDs) used when yu create toolbars and ...

2018Jul9
Card image
FixENTERS_File

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

2018Jul7
Card image
HTMLTag + HTMLPair

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

2018Jun30
Card image
SettingRead_JR

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

2018Jun26
Card image
CellRead

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

2018Jun16
Card image
Reversefile

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

2018Jun16
Card image
ANStrRead + ANStrSave + ANStrSearch

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

2018Jun14
Card image
Modify SQL table

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

2018Jun9
Card image
Replace Single Quotes

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

2018Apr16
Card image
ArrayRead + ArraySave

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

2018Apr15
1234