Excellent!
I’ll get to the other Office tools using VBA in future posts. For now, I want to focus on Excel. I think it’s most folks comfort zone.
When it comes to programming. The flexibility is endless.
I have used Excel to call SAP BAPI’s, parse the return, then send to MSSQL. Use SQL to insert, create and update. Then finally pass to an Oracle Agile API.
Your imagination is the limit!!