Search results 135

Sorted from new to old.

ANmaSQL_InsertStatement

Creates SQL INSERT statements from a table in Excel. Used to be executed to ...

2022Jul3

DBTable2CSV

Exports table into CSV from ASP Classic function.

2022May31

DBTables

Returns an array of all table names in a database. needs valid OLE database ...

2022Apr28

Fill down

Fill down series in Excel. NotReadyYet! This is a work-in-progress function! ...

2022Jan5

CSVs2Sheets

Import all CSVs found in a folder into sheets, sheet per CSV This was a quick ...

2021Oct5

ServerXMLHTTP stream

Using ServerXMLHTTP object to show (stream or download) and image , or any ...

2021Aug3

SumOf_3Filters

Returns sum of certain column in range (or table) in sheet after applying ...

2021Jan29

EnvironList

List of all variables of Environ It will populate them in sheet range starting ...

2021Jan12

Hiding chart in Excel

How to hide a full chart in Excel. By treating it as shape, not as chart.

2020Dec31

ASP to static HTML

Convert Dynamic ASP files into HTML (once daily) to make them faster when ...

2020Dec24

ListBox_Excel_Sort

Sort items in Fm20 Listbox using Excel spreadsheet Sort function. Can decide ...

2020Sep21

RRRow - Datatables ASP mdb Ajax example

ASP based AJAX example to call mdb database using

2020Sep7

JSPasswordStrength

Quick popup bootstrap 3 popover message to measure password strength ...

2020Sep3

UI_2ValidationsUpdate

Apply validation on two cells, when a 3rd cell is changed When modifying a ...

2020May27

NextID_Reset

Checks if ID has been reset in SQL database table If yes, it will reset it and ...

2020Mar31

DB_Connect_Install

Connects to SQL DB using ADODB, if driver not installed, it will attempt to ...

2020Mar24

1 2 ...4 ...8 9