Save temp Excel-File without GUI

I’m using SAP Analysis for Microsoft Office and generate a report in Excel. Now i want to save this excel-file. I was wondering if there is a way to save this excel-file without using the normal click or send hotkey-activities.

Is is possible to execute a invoke vba active that would save the file?

Kind regards

1 Like


Your requirement is somewhat confusing

Can you add more details regarding to your requirement?


1 Like

Edited original post.

1 Like

Sorry I’m not much aware of SAP Analysis office plugin

but is the temp file is saved in your location?

Then you might use Excel application scope and make sure save changes are enabled

Hope this may help you


Hey @MWB

I guess this should give you some good idea to proceed -

Hope that helps