-
March 4th, 2009, 07:49 AM
#1
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
-
March 4th, 2009, 10:38 PM
#2
Re: Referencing a DLL from Excel VBA code
Put it in the app.path folder, and the .exe should look there. It would still have to be registered, though.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|