Pogramar Macro de EXCEL para cocentarme a SAP-HANA y ejecutar una consulta

Hello,

I use SAP Business One Client, and Excel 2010, Do you know if there is a way to connect to SAP-HANA via macro (VBA), to make queries already saved and formatted in SAP B1. Would you help me please, the connection chain that I found does not work for me