i have an issue if i will open a .xlsm file which has a included add-in from SAP and a db connection. In this file i have predefined a report on a db. the file should update my report with the corrent status from the db by opening the file. I have built a bot that should open this file and read the range of the updated report. I built it with the “Use Excel File” activity. When i run the bot, it opens the file but without the SAP add-in and the file cannot update the report to the current version.
Can anyone give me some hints or ideas how i can manage this?
Is it truly a 4 level-based (balanced) hierarchy or is it a parent-child (ragged) hierarchy? If it’s level-based, your BW developers may be able to change each level into a dimension so that you can pull all 4 in as individual columns.
Initially using the start process activity, open the macro workbook. It will automatically close. Then use a delay activity. Followed by use the excel application scope to open the same macro workbook. Now you can see the analysis tab enabled.