Help using dll with excel 2007 and vista 64
 

I haved use the swedll32.dll with XP and excel 2003 with no problems.

I have a new computer with vista 64 and office 2007. I cant figure how
to make my excel vba functions work. I tried registering the dll using
RegSvr32 but it would not take - Entery Point not found. I tried
putting in the sysyem and system32 folders with no luck.

Any help?


Using RegSvr32 will not help, as the DLL is not a COM DLL. The
potential issue is 64 bit compatibility, as swedll32.dll is a 32 bit
DLL and cannot be loaded into a process which is 64 bit.
But your issue seems strange, as Office 2007 is still a 32 bit app, so
should load the DLL just fine. The problem is probably that the usual
System32 folder is for 64 bit DLLs only. I suggest you put the DLL in
c:\windows\syswow64. This should do it.


That did not work either
Please advise...