What reference do I add to access .net objects from Excel VBA

I have a need to use certain methods in the System.IO Namespace from an Excel VBA macro (Specifically, methods and properties in the Path class). What I can't figure out, is what reference to add to be able to use this class.

Can anyone point me in the right direction? Note that I am interested in this question for two reasons:

1. How to do this specifically (that is, how use Path.GetRandomFileName, e.g. from VBA)
2. How to do this generally (to be able to reference other .Net objects)

AFAIK you cannot add direct references to the .NET library from VBA. Period.

Perhaps this windows API call can help you:

http://support.microsoft.com/kb/195763

It would be mscorlib.dll but you can't use System.IO.Path from VBA as far as I know, unlike some of the .Net objects.

Quote:

---

Originally Posted by Jan Karel Pieterse

AFAIK you cannot add direct references to the .NET library from VBA. Period.

---

Well! that's a drag for sure