Search results 17

Sorted from new to old.

RangeTakePicture_Linked

Converts a range in Excel sheet into picture. linked or unlinked. Important! ...

2025Sep30

Create Tree from 3 columns (Sheet2Tree)

Converts 3 columns in sheet into 3-generation tree using TreeView from Mscomctl. ...

2025Aug7

Match4_4thNot0

Searches for three cells in three columns then checks for 4th column if not ...

2024Nov1

GetPapa + GetSon with variances

Gets the parent folder full name from a path Also Gets the son of a full path. ...

2024Oct26

Win10 ThisPC Virtual locations

I hate it when Windows forcing us to have additional items in "This PC" So, I ...

2024Feb5

ConcatenateStrings_AmongString

Collect strings matching search from a longer string. I used it to concatenate ...

2024Jan17

MultiRead_JSON

Reads array of arrays from the parent and return back ANString of 3 columns

2024Jan13

Grandchildren files and count

Returns list of files in 2 level folders Will not find files as children of ...

2024Jan11

Subdomain to a folder

Redirects a subdomain into a folder child of main domain, named same as ...

2023Oct17

Evaluate

Execute any command in Excel VBE, using Application.Evaluate to execute almost ...

2020Feb16

iframe link to parrent

Link to the parent from inside an iFrame using JAVA

2020Feb3

DB_ExtendedProperties

Returns extended properties of a database, knowing the ADODB connection

2019Jul22

Web.config Redirect

Redirect domain to another, including all its sub pages, sub folders, and ...

2019May21

BrowseFolder

Asks user for a folder tested in VBA of word as well as VBA in Excel

2018Jun14

FixPath, IsThere, IsThere1 ...

Set of 6 functions to deal with filesystem. Gets current workbook path, ...

2018Jun11

Frequency

Checks how many items in an ANStr ANStr is list of items separated by a ...

2018Jun8

1 2