I have a .net COM enabled dll MyDll.dll which I wish to call from Excel 2003 VBA on client pcs. The setup package project I have created in Visual Studio 2008 will successfully register the dll on the client pc, but doesn't seem to be able to register the type library file, MyDll.tlb which it distributes along with the dll file
I can generate and register a new copy of the tlb file on the client pc via running (from a command line, as admin user, and from the .net v2 directory) regasm pathtoMyDll.dll /codebase /tlb but this is tedious to do on 40-50 pcs.
How can I automate the process? Or should I be doing things a different way?
(My clients are usually running Windows XP and Office 2003)