You can use any APIs in VBA that you could use in VB6. If you know which one you want, search google using the API name and VBA or VB6. I'm not sure if .Net versions are compatible, but those are worth a trip to google too. (Google is one of my favorite programming tools, BTW.)
API Used in VBA
c_shah
See
www.allapi.com
WXS123
Blader
Ideally, All VB6 API Functions should work with VBA also. I have tried many and it works fine
You can use API Viewer in the Addins tab of VB and get to know the APIs available. You can also add more API Functions to the input file