Excel VBA calling C DLL: run-time error 53 (file not found)

[Alexei Vinogradov]

I'm developing a C DLL. To test, I'm trying to call it from an Excel macro.

Create a new macro-enabled workbook, save it in the same folder as the built DLL, type in the VBA code (declare the function and a simple test sub), and run - works like a charm. Close the .xlsm, reopen it, try running again, and it throws #53 "file not found".

Ultimately it's not Excel that will be calling it and if this is just a fluke I have to live with, I will. But is this something simple/tricky/glitchy, maybe permissions-related (I am not admin on this box)?

Thanks in advance!

 

[Daniel Duffy]

Strange
1. check dir path + dll exists
2. make sure dll has not been opened by another process (e.g. another EXE).