I have written a save and open dialog box add on for a VBA project i'm working on - heres the link VBA: Get Excel FileDialogOpen to point to "My Computer" by default (thanks for the help @mehow).
Now this add on (Class Library as it is actually called) works fine with the vba project on my computer which Ive been developing it on. However now to use this add (Class Library) on on the server I'm not able to get addon registered successfully so that the VBA project can see it.
I wrote the Dialog box add in in C# with VS 2013 Express for Desktop on my Windows 8 machine and we are now trying to test it on a windows server 2008 machine where the VBA project will run at the end of the day.
I have tried using the regsvr32 command on the server as well as looking for a deployment option in VS 2013 but neither seem to be working! I have also tried searching for a solution but no luck so far.
If anyone has any ideas how this can be done it would be much appreciated. Sorry if i'm not using the correct terminology. . . add ins etc but I hope you get what I mean.
Many thanks
Tristan.
regasm /i /codebase yourAssembly
? Is your assembly (and type) ComVisible? – Frodiregasm /regfile /codebase yourAssembly.dll
. This will produce a reg file you can add to the registry on your target computer. I have had some issues with that though, so it might not be enough. Also note that you can only use the /codebase flag if your assembly is signed. – Frodi