Hi All

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

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

Any suggestions would be much appreciated.

Regards

Jerem

--
JG
-----------------------------------------------------------------------
JGS's Profile: http://www.excelforum.com/member.php...fo&userid=2933
View this thread: http://www.excelforum.com/showthread.php?threadid=49265