SAP Analysis for Excel use

[Riyas.Muhammed (Muhammed Riyas)]

Normally we use “Excel Application Scope” activity to run the VBA, but Analysis & Analysis Design tabs will not be available while we are using “Excel application Scope” activity. To use Analysis tab and run any VBA codes with SAP Analysis in the excel, use “Open Application” activity to open blank excel workbook then brows the excel file. Once the file is opened, use “Excel Application Scope” activity and open the same excel file. Now we can see the Analysis & Analysis Design tabs.