I converted a workbook project to an addin and have no problem running
on XP with excel 2002. When I test on a Vista machine with excel
2007, it cannot find a dll that it uses that is in the c:\windows
\system32 folder. The dll is there, but the calls to the dll fail and
DIR function does not work also. The dll is specific to the addin and
it is written in C. I did not have this problem when the dll was
called from a workbook macro. Any ideas? Thx.

Normally there should be no problem to find the dll in the \system32 folder,
unless of course it has been declared with the full path to \system32 as was
in the XP machine. If that's what you've got, remove the path. If that
doesn't work try putting the dll in the same folder as the addin, also
ensure the dll is declared without a path.

If that doesn't work, try something like this -
oldPath = CurDir
ChDir "c:\path to the dll"
' call the dll
ChDir oldPath

What do you mean by the "DIR function doesn't work", that's like saying "my
car doesn't work"

Regards,
Peter T


"extrnh" wrote in message
...
I converted a workbook project to an addin and have no problem running
on XP with excel 2002. When I test on a Vista machine with excel
2007, it cannot find a dll that it uses that is in the c:\windows
\system32 folder. The dll is there, but the calls to the dll fail and
DIR function does not work also. The dll is specific to the addin and
it is written in C. I did not have this problem when the dll was
called from a workbook macro. Any ideas? Thx.