How to use MS Excel VBA to Logon and use criteria for HANA using SAP BI Analysis for Excel

[Former Member]

All,

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.

Regards,

Murry

[former_member151004]

Hi Murry,

I believe that the following thread will help you with the VBA connection code:

http://scn.sap.com/message/15180851#15180851

Refer also to the following threads:

http://scn.sap.com/docs/DOC-53317

http://scn.sap.com/community/businessobjects-analysis-ms-office/blog/2011/06/26/can-you-use-vba-with...

I also believe that once you upgrade your analysis for office to SP2 will be easer as you will not have the ODBC connection. Instead ODBC you will have the HTTP connection.

Thanks,

Diego Ferrary