Hi,
I am looking for a way to share code amongst various applications. To start with it has to work with Excel and Access and later, vb.net.
I have various functions written in VBA and stored in the background of various applications and I am hoping to find a way of storing them all in a central place and set all the excel and access applications to run the code from there.
I have been looking into creating dlls and COM objects but I don’t really know where to start. Can anyone recommend a book that can explain the process of creating dlls/ COMs and connecting them to Excel and Access?
I have been able to create test dlls in VB.net express edition but they only work with other VB.net applications when the dll is added to references. Not been able to get Excel or access to use these dlls.
Or is there a better way of storing code in a central location?
Thanks to anyone who can point me in the right direction.
I am looking for a way to share code amongst various applications. To start with it has to work with Excel and Access and later, vb.net.
I have various functions written in VBA and stored in the background of various applications and I am hoping to find a way of storing them all in a central place and set all the excel and access applications to run the code from there.
I have been looking into creating dlls and COM objects but I don’t really know where to start. Can anyone recommend a book that can explain the process of creating dlls/ COMs and connecting them to Excel and Access?
I have been able to create test dlls in VB.net express edition but they only work with other VB.net applications when the dll is added to references. Not been able to get Excel or access to use these dlls.
Or is there a better way of storing code in a central location?
Thanks to anyone who can point me in the right direction.