Excel VBA only has standard functions available?

[snowblizz]

I came across a rather puzzling statement the other day.

It claimed VBA (Excel) was limited to only standard functions in Excel.

Now I'm not a guru in the field but I could have sworn I had to use the References function in the VBA editor to include some non-standard libraries in a budgeting application I made once. IIRC when accessing Access through Excel. Indeed there is a looong list of libraries listed in "References" most of which seem to be external.

Would I be correct in saying there "are to" non-standard functions in available through Excel VBA?

 

[Andrew Fergus]

Would I be correct in saying there "are to" non-standard functions in available through Excel VBA?

Yes - provided you installed the appropriate reference(s).

 

[snowblizz]

Yes, obviously. That part had me stumped for quite a while at one time when I had moved a workbook from the computer I had developed it on to one where it was going to be used. There was a fairly substantial period of "What the... This totally worked yesterday!" before I remembered I'd had the same issue right at the beginning and how to resolve it.

Many thanks for confirming this. It was bugging me immensely and at least I can back it up with a trusty "this dude on-line totally confirmed it".