how to let VBA programmer import the objects I've written in .NET?

[sirpelidor]

as title... the answer will begear toward VBA programmer in Access, or Crystal Report programmer.

[SpectreReturns]

Perhaps compile the objects into a shared library and pointing to it with VBA? (I've never actually worked with VBA, so I'm just taking a wild guess here)

[sirpelidor]

thanks for trying SpectreReturns. I've got the problem solved, if anyone else interested this is what I did:

1) build my objects
2) compile'em, there will be 1 dll file under the /bin folder
3) package that dll file, send to whoever's machine that needs to use the objects.
4) on the new machine, open command prompt, type: regsvr32 (path to my dll file)
5) now, for VBA, or ASP programmers to use my objects, they need to do:

Set SirPelidorObj = Server.CreateObject("SirPelidorObj.whateverPackage")

6) after pointed to my object succesfully, to use my methods (i.e tostring() )

SirPelidorObj.toString


7) done, time to leave my desk and get a life....

[sirpelidor]

aaargggh!!! this morning i discovered the client machine won't run my dll file.

it complained:

blahblah.dll is registered but It can't be load, DllRegisterServer entry point was not found

alright...this is beyond "web developer" problem...

[sirpelidor]

the solution I discovered turns out to become more annoying then I expected to be, if anyone else interested, here's the site:



http://msdn2.microsoft.com/en-us/library/zsfww439(VS.80).aspx