I have created a Vb.net Class Library project. To this I have added a Com Class Item. Within this I have added a few simple functions.
I then compile this as Release and I get a DLL and a tlb file.
I then reference these with Access 2003 VBA and then create an object of class and therefore have access to .net functions within a VB6 environment.
This works perfectly on my primary machine.
I now need it to work on my laptop. I assumed that if I copied the tlb file across and then added a reference in the same way as above all would be well. Unfortunately it does not work. Instead I get the following error:
Run-Time error ‘429’:
ActiveX component can’t create object
Does the laptop need Visual Studio in order for this to work? Any suggestions as to how I can get this to work appreciated.
(I’ve tried copying the entire contents of the bin\Release folder but this does not work either)