Hi all,

I am working on Excel 2007 Beta version.
I am facing a problem while calling a DLL in VBA for Excel 2007.
My DLL is located at the currrent directory location and i have declared it
in my VBA code as follows

Private Declare Sub table Lib "numTable.dll" (ByVal n As Integer, ByRef arr
As Long)

I have placed a command button on the worksheet to call the DLL's function.
But it gives error on clicking the button which says numTable.dll missing. I
have to call the DLL without changing its location i.e. current directory.

--
Thank You