Hi all

When declaring some API calls, is it possible to use a variable for the
"path" ? I have a standalone DLL that would be present in the directory the
worksheet / document is opened in that won't be registered on the system
locally... its functions can be accessed by pointing to the DLL - but I have
only even seen the path to the DLL hardcoded...

Private Declare Function FunctionName Lib "path" Alias "alias" (ByVal N As
Long) As Integer

TIA

Mike

Have you tested whether you actually need a path? I'm pretty sure that the
current path is checked. If so just the dll's name would suffice.

--
Jim
"Mike Iacovou" <(E-Mail Removed)> wrote in message
news:E324D32D-6CCC-4C9D-98E9-(E-Mail Removed)...
> Hi all
>
> When declaring some API calls, is it possible to use a variable for the
> "path" ? I have a standalone DLL that would be present in the directory
> the
> worksheet / document is opened in that won't be registered on the system
> locally... its functions can be accessed by pointing to the DLL - but I
> have
> only even seen the path to the DLL hardcoded...
>
> Private Declare Function FunctionName Lib "path" Alias "alias" (ByVal N As
> Long) As Integer
>
> TIA
>
> Mike

thanks jim

using the declaration with the DLL in the same folder fails with a "not
found" error... I guess it expects either a registered library or an absolute
path...

First you need to confirm if this is an ActiveX DLL or a standard Windows
DLL.
The former:
- Needs registering
- You access it with by create an instance of its exposed classes

The latter:
- Does not need registering
- You call functions with the Declare statement similar to that you have
shown.

As for the error, it may be because one/some files that this DLL requires
are missing. Get a copy of Dependency Walker to check.

NickHK

"Mike Iacovou" <(E-Mail Removed)> wrote in message
newsB57AAFB-4AB7-48B3-BF2A-(E-Mail Removed)...
> thanks jim
>
> using the declaration with the DLL in the same folder fails with a "not
> found" error... I guess it expects either a registered library or an
absolute
> path...