I currently have a report which will be emailed to business users weekly. The data output can only be CSV/XML and I do not have the ability to automatically add the requested pivot tables. Therefore, I am attempting to pull the data with a Workbook_Open sub routine which exists in an Excel file.
My issue here is I cannot use Macros on SharePoint nor can the data be publicly accessed in a Macro...so I feel like I am up a creek.
Any suggestions from a VBA, Excel, or BEX/BOBJ standpoint?
Well if your report is forced to be csv/xml.... and you can't access the data directly through a macro... the solution is not terribly straight forward.
Here is how I would solve
1) SAP Job drops off file
2) Some type of automation kicks off a macro
3) Macro formats and emails report
probably possible to have sap email a spreadsheet formatted to taste directly via abap code.... that is not something i have much experience with.