VBcoders Browse New Submit Contact Sign In

No account? Register free

Forgot password?

Using Excel Functions from VB

G. Hennen  (2 Submissions)   VB function enhancement   VB Script   Advanced   Wed 3rd February 2021

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.

Rate Using Excel Functions from VB (3(3 Vote))

Download Using Excel Functions from VB

Using Excel Functions from VB Comments

No comments yet — be the first to post one!

Post a Comment

0/1000 characters