The project isn't all that difficult. I can send what Ive built so far, and that will provide some direction. I need someone to take it to the next step. What I need is - once this script logins to SAP BW-EX (which is the web-based version of SAP), I need the script to open the variables table, insert a number for a cost category, then SAP will bring up a table of basically just a big buget - I want excel then to pull that data back into the spreadsheet.
In VBE, I want this to be in 'ThisWorkbook' and trigger on workbook_open().
Really its fairly simplistic, Ive done things like this before -just dont have time to do it right now. That said, the other thing Ive never done is trigger the variables table > insert a value. There's lots of information online about how to do it, again I just dont have the time to sort through it all and develop something. Once someone contacts me and knows they can do the work, Ill let you know