topic Script Recording - Export as Spreadsheet in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/script-recording-export-as-spreadsheet/m-p/10294111#M1833171 <HTML><HEAD></HEAD><BODY><P>Hi all, I'm using the script recording function to link up Excel and SAP for reporting purposes. After I run a t-code, I'd like to export it as a spreadsheet, particularly the 'CTRL+SHIFT+F7' format that is much cleaner and requires no clean-up work compared to the other method to export it, hereby dubbed the local file export, or 'CTRL+SHIFT+F9' format.</P><P></P><P>However, the only way I've been able to do this is via the Local File export. If I try to export it as a spreadsheet with the F7 method, the script recorder abruptly stops once the 'save as' prompt appears.</P><P></P><P>I'd like to automate this as much as possible and have the F7 method save as a certain file name and override any existing files with no prompts, and have all of the script recorded and ready to transfer into excel - is this method possible?</P></BODY></HTML> Mon, 05 May 2014 12:43:37 GMT Former Member 2014-05-05T12:43:37Z Script Recording - Export as Spreadsheet https://community.sap.com/t5/application-development-and-automation-discussions/script-recording-export-as-spreadsheet/m-p/10294111#M1833171 <HTML><HEAD></HEAD><BODY><P>Hi all, I'm using the script recording function to link up Excel and SAP for reporting purposes. After I run a t-code, I'd like to export it as a spreadsheet, particularly the 'CTRL+SHIFT+F7' format that is much cleaner and requires no clean-up work compared to the other method to export it, hereby dubbed the local file export, or 'CTRL+SHIFT+F9' format.</P><P></P><P>However, the only way I've been able to do this is via the Local File export. If I try to export it as a spreadsheet with the F7 method, the script recorder abruptly stops once the 'save as' prompt appears.</P><P></P><P>I'd like to automate this as much as possible and have the F7 method save as a certain file name and override any existing files with no prompts, and have all of the script recorded and ready to transfer into excel - is this method possible?</P></BODY></HTML> Mon, 05 May 2014 12:43:37 GMT https://community.sap.com/t5/application-development-and-automation-discussions/script-recording-export-as-spreadsheet/m-p/10294111#M1833171 Former Member 2014-05-05T12:43:37Z Re: Script Recording - Export as Spreadsheet https://community.sap.com/t5/application-development-and-automation-discussions/script-recording-export-as-spreadsheet/m-p/10294112#M1833172 <HTML><HEAD></HEAD><BODY><P>Not sure what you meant exactly by 'script recording' and 'Ctrl-Shift-F7'. It's also not clear what transaction this is about and, consequently, how exactly the data is displayed. Please be more specific and use standard SAP terminology to avoid confusion (refer to <A _jive_internal="true" href="https://answers.sap.com/community/getting-started/blog/2010/05/12/asking-good-questions-in-the-forums-to-get-good-answers">this blog</A>).</P><P></P><P>Can only guess this has something to do with 'Excel in-place'. If so then there is an interesting <A _jive_internal="true" href="https://answers.sap.com/thread/2068297">document</A> that might be of some help.</P></BODY></HTML> Mon, 05 May 2014 20:28:22 GMT https://community.sap.com/t5/application-development-and-automation-discussions/script-recording-export-as-spreadsheet/m-p/10294112#M1833172 Jelena_Perfiljeva 2014-05-05T20:28:22Z