Salesforce Developer Community

I am trying to find a way to import an existing report directly from SFDC using vba alone.

I want it to work as the Excel SFDC add-in does except the login and password would be hard coded.

Ideally i want it to create a macro which will import my report at the click of a button.

Does anyone have any ideas?