I have a command button in a spreadsheet, which when clicked attempts to call a procedure (ADC1632.dll) which communicates with a port, but the button only works if i open excel.exe then go File>Open and point to the path.
I want to be able to just click the file and the ADC1632.dll file is found and works fine??, but currently it comes up with the Run time error 53, file not found and it is the line
code:---------------------------
ok = adc16_open_unit(Port)
--------------------------------
that is causing the problem, as its the open statement that is not communicating.
I have tried to declare it in the module file (code below) which communicates with the dll, but still it does not find the file
code:--------------------------------------------------------------------------
Declare Function adc16 Lib "C:\Software Development\adc1632.dll"
--------------------------------------------------------------------------------
Any suggestions anyone?
Thanks in Advance
I want to be able to just click the file and the ADC1632.dll file is found and works fine??, but currently it comes up with the Run time error 53, file not found and it is the line
code:---------------------------
ok = adc16_open_unit(Port)
--------------------------------
that is causing the problem, as its the open statement that is not communicating.
I have tried to declare it in the module file (code below) which communicates with the dll, but still it does not find the file
code:--------------------------------------------------------------------------
Declare Function adc16 Lib "C:\Software Development\adc1632.dll"
--------------------------------------------------------------------------------
Any suggestions anyone?
Thanks in Advance