Hi All

How do you find the relative path to the Program Files folder on a particular computer so that a declare statement can find a function within a dynamic-link library?

Declare Function SOMEFUNCTION Lib "c:\Program Files\SomeDLL.dll" (ByVal SomeNo As Double) As Double

Any suggestions would be much appreciated.

Regards

Jeremy