How to register Windows API for a VBA app in VISTA

[si_the_geek]

The Windows API cannot be added to References - you need to declare each function individually as westconn1 showed.

The reason for this is that References is for ActiveX DLL's (or EXE's), but the Windows API is built using COM DLL's.


The only way you could get it in your References is if somebody had made an ActiveX DLL/EXE that contained the declarations etc.

I have to clarify that I don't have the faintes how the list of stuff displayed under references is populated.

It shows the list of all ActiveX DLL's/EXE's that are Registered (ie: properly installed) on your computer.