How to use MS Excel VBA to Logon and use criteria for HANA using SAP BI Analysis for Excel
What I am looking to do is use VBA code that when my XLSM workbook is opened it will Logon to my HANA ODBC connection (through SAP BI Analysis for Excel)
and then use a date range to populate the prompts.
I appreciate the help. Also please let me know if you need any further details.