We have a reporting system that injects data from our DB to an external Excel sheet, and then running macros in the file. Should note that our Excel component that generates the reports (XJS) sometimes manipulate some parts of the code and that some changes must be done in macro fter the file has opened.
This specific file this project is about is an Excel 2010 file that works with vba. When trying to run the same file on Excel 2011 for Mac, vba code doesn't seem to run.
We need to convert the code so it will run with full functionality on Excel 2011.
The file should run correctly with the whole process, and not only on my computer - meaning that we will upload the file to our system and see if it works after the Excel component handles it.
In the attached ZIP file there are 3 files:
1. Targeting [url removed, login to view] - a basic spec with technical explanation on the report
2. targeting perfomance [url removed, login to view] - clean template. This is the file that should be converted.
3. target report [url removed, login to view] - a sample with data for how the report looks like.