Skip to Content
Former Member
Oct 22, 2015 at 06:23 PM

Calling Business Objects 4.1 from Excel VBA


I'm not sure if any of you do this. We currently have Excel VBA that calls Deski reports, opens them, passes in variables, refreshes, and downloads the data into Excel.

There are many valid reasons for my users to do this, and they need to continue with this process once we move to 4.1 But Deski will no longer be there so we need to come up with a new way to do this. I could code just about everything except for the part that asks the user to save or open the file.

How can I get around this? Is there something I might be missing? They need to run their process on demand so scheduling a report won't work for us.

Thanks so much for any help you might be able to provide.