Thread: dll in VBA
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default dll in VBA

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