Search results 99

Sorted from new to old.

CountDuplicates

Counts how many duplicates found in a range of Excel cells. Basically how many ...

2020Oct31

SortedFiles

Get a sorted list of files in a directory using the File System Object (FSO) ...

2020Aug11

JSON-VBA

2 modules to read output of json API (or file) into parsed array of objects. ...

2020Jul30

FolderSize_Swift

Gets total of folder size in bytes. With some tweaks, you can modify it to use ...

2020Apr20

Delete_Unwanted_Rows

Delete rows in a different way I used to delete rows by looping through those ...

2020Apr14

DelFiles

A very simple to delete a directory and the entire files and folders in its ...

2020Apr1

DB_Connect_Install

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

2020Mar24

Custom Excel Right-Click Menus

Customizing Excel's right click menus The following code demonstrates how to ...

2020Mar21

DB_Connect

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

2020Mar20

IsThere2

Finds a file in giving its full path Similar to IsThere1 except this one uses ...

2020Jan10

BodyYoutubeLink2iframe

Creates youtube embed from link Converts a youtube video link into a youtube ...

2019Dec31

List of Databases

Script to list databases available in a server using ADODB connection From

2019Oct6

MouseDown and MouseUp in FM20 controls

MouseDown and MouseUp in VBA (fm20 controls) are different from those in VB6 ...

2019Apr14

FilesCount_Swift

Count how many files in a folder, with no loop, faster if you just need all ...

2019Feb2

Global asa

As ASP Classic user, I have to have some post about global.asa Here is one, ...

2018Dec28

Split string into table

Returns tag words (as table) in Microsoft SQL Separator set to comma, but you ...

2018Dec18

1 2 3 ...6 7