by G. Hennen (2 Submissions)
Category: VB function enhancement
Compatability: VB Script
Difficulty: Advanced
Date Added: Wed 3rd February 2021
Rating: (3 Votes)
Excel exposes many powerful functions that can also be used in VB. This program demonstartes how to use several by passing data arrays to the functions. Some of the Excel functions return multidimensional arrays and this program shows how to retrieve the returned information.
Assumes
You must have Excel on your machine. I use Excel 2002 so I don't know how this program works with other versions.