Jacob,
Referencing a DLL has nothing to do with using Declare. You don't need to
reference the DLL. However, in the declare statement, you need to provide
the full path name to the DLL, or locate the DLL in the system directory,
Excel's directory, or a directory named in the PATH environment directory.
Otherwise, the file will not be found, as you have found out.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com
"jacob" wrote in message
...
Hi,
Have made something in c++ to convert a unix file to
dos format. I declare the function in a module using
Declare Function Unix2dos Lib "unixconvert.dll" _
(ByVal InputFile As String, ByVal OutputFile As String)
As Long
and then reference the dll in References under the tools
menu. I then call the function in a sub in the same
module containing the Declare statement using
ConvertStatus = Unix2dos(FileIn, FileOut)
and get Err=53, i.e. file not found. What could be wrong,
excepting typos?
Any help appreciated.
jacob