Overcome SAVE AS box in SAP while transferring the report to excel.

thanks for the instant reply but my concern was to overrule the "save as" pertains to SAP.......the steps am performing are as follows
1.executing report in SAP by feeding in relevant parameters.
2.output comes up.
3.saving the report in spreadsheet form....at this point the SAVE AS dialog box pops up in SAP to save the file at desired destination. Once my loop hits this step, everytime I have to save the file manually and then loop moves on further.I want to overcome the step of SAVE AS dialog box.....macro should save the file automatically which am not able to accomodate in my automation steps.

Is there any one who can help me on my below concern????

Can anybody help me with the VB code to run Hyperion from Excel 2010?