How to include libraries (1 Viewer)

[RogerB]

I need to include an API library file that will allow me to connect to a non Access database.

In C this would be done with "#include 'file name'".

How is it done in a VBA code module?

Thanks

 

[Alexandre]

Use a Declare statement
Ex:

Private Declare Function SHFileOperation Lib "shell32.dll" Alias "SHFileOperationA" (lpFileOp As SHFILEOPSTRUCT) As Long

See an example code snippet:
API - Delete a file