wilmott.com

Hi,I have encountered a really annoying problem with an xl dll and would be very happy if someone has any ideas about how to solve it.I have built a dll using MVC++6.0 and is calling it from xl using a VBA macro. Everything works fine on my computer and it also works fine on other computers by just copying over the dll object and the excel file and referencing the dll at it's new location. Due to that some calculations are very time consuming a friend of mine offered me to use a really fast server he had connection to. That sounded great and I copied over the files as usual. However, when running the script I get the following error:"run time error 429: ActiveX component can't create object"The place in the code is the first use of the dll, however the line"Dim test As New Model" is ok, but"test.SetDimension 10" fails.One idea I had about what might be wrong is that perhaps the dll weren't properly registered. I therefore tried to run regsvr32 ..path..\lib.dll but I then get another error message saying that it failed and returning a reference to something like 0x0000054.Anyone that has any clever ideas?Best wishes,Robbie

You are probably missing one or all of the c, atl, mfc dlls, use depends on eth COM dll and make sure they are all on the fast box.John

John's probably right, but also since it's a server I suspect it's security may be tighter, and you don't have permission.

Many thanks for your answers!Since "copy the dll and xl files and run" normally works fine (also on computers without MSVC++) I have problems understanding how they can "suddenly" be missing, just because I'm working on the server. But on the other hand I'm a newbie on this, so what can I say..The security issue seems like a possibility. Is there any way to check whether I have permission? If this is the case, is it possible for someone (the host of the server) the entitle me permission? Any workarounds?..Best, Robbie

There's a lot of security setting in Windows, hard to tell which.I'd go for building a minimal XLL with no references to other libraries. See what happens.

QuoteOriginally posted by: robbieHi,One idea I had about what might be wrong is that perhaps the dll weren't properly registered. I therefore tried to run regsvr32 ..path..\lib.dll but I then get another error message saying that it failed and returning a reference to something like 0x0000054.The exact error number would helpJohn

It is running fine on Windows XP but not Windows Server 2003. And you are doing data access in your project. Am I right?? If so most likely that you have a reference to a wrong DAO (data access) object library ( DAO 3.51 instead of DAO 3.6 or vice versa)..