Search results 46

Sorted from new to old.

merge2Arrays

Merges two 1-dimension arrays and return an array Both should be 1 dimensional ...

2021Sep21

ServerXMLHTTP stream

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

2021Aug3

Logging use of executable in Windows

Log the use of .exe, .lnk, .pif, .bat, and .com files on your computer. All it ...

2021Jun13

ShapeRange_BG

Replaces the background fill of any shape in Excel with an image Not Ready yet, ...

2021Mar27

Hiding chart in Excel

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

2020Dec31

Save Excel range (or shape) to picture

This is an interesting approach to export a range of cells into picture using ...

2020Dec21

ANmaCopy_Objects

Copies objects from cell into cell Decide Sheet, and workbooks to copy from or ...

2020Nov11

ExitTool and DoNothing

My way of Exiting tool in case or error, also another sub that basically does ...

2020Oct31

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

DelFiles

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

2020Apr1

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

BodyYoutubeLink2iframe

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

2019Dec31

Checks if URL is valid

Checks if URL is actually working. Uses XMLHTTP object to see if that URL ...

2018Dec9

1 2 3