Save temp Excel-File without GUI

Help Activities
, , ,
1

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
MWB

1 Like
2

@MWB

Your requirement is somewhat confusing

Can you add more details regarding to your requirement?

Thanks

1 Like
3

Edited original post.

1 Like
4

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

image
image887×336 18.1 KB

Hope this may help you

Thanks

5

Hey @MWB

I guess this should give you some good idea to proceed - https://help.sap.com/doc/0bb77ce37c594468809c6b3e3c670922/1.4.16.0/en-US/f2/6f20a96c9b1014bf2c9a7eb0e91070/frameset.htm

Hope that helps

Thanks
#nK