Search results 132

Sorted from new to old.

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

DB_Connect

VBA-Excel function to connect to SQL Database server, in addition to ...

2020Mar20

Reset ID Column

How to reset ID Column in Microsoft SQL, (not completed yet). This is because ...

2020Feb9

Decode and NVL

Two oracle SQL functions, that are interesting. Decode to work as (Select ...

2020Feb7

1 2 ...4 ...8 9