Referencing a DLL from Excel VBA code

I'm trying to use an excel add-in that comes with a custom developed DLL for calculations which is usually stored in my windows/system32 directory.

Can I still reference the file from my excel vba without storing in windows/system 32?

For example, I tried to register it manually based on storing it in another location using the regsvr32 command but I was unsuccessful with the message “the file was loaded but the DLL register server entry point was not found”

Could I use code to open/reference/activate the file by placing it in another location (e.g. the folder where the addin is stored)?


I am not a progammer, just know some basic VBA for excel so really hope someone can help.

Thanks,

Nick

Put it in the app.path folder, and the .exe should look there. It would still have to be registered, though.