Bo and VBA automation 1

[nickjar2]

I am normally on the access forum. I didn't know this forum existed. Glad I found it.

I have been asked to investigate ways of automating a couple of BO reports (maybe with parameters ie. Month) using VBA.

What I was hoping to do was create an app that a user clicks a button and possibly gets asked to supply the month. I think the 2 reports will initially be hardcoded. Once the user has entered a month, the 2 reports will open, refresh and Save As, to a text file (or maybe directly into Access)
I also have an xls file which I want to compare to these 2 BO reports (thinking of running a query in Access).
Would it make more sense to reference the BO library from within Access and do it that way or from within BO.
Any code would be really helpfull.
Please let me know if I haven't made any sense.

Thnx in advance,

Nick

 

[nickjar2]

Can no-one help? I really am at a loose end.

Nick

 

[marchristensen]

I don't know an awful lot about BO, but I do receive a BO report that was developed such that when I open the report, a box pops up and I am able to enter parameters that are used in the report. So you can probably get the user to supply the month directly in BO. I have also had success copying a BO report and dropping it in Excel. For some reason, you have to hold down the ALT key while you use the mouse to outline what you want to copy in BO, but once you do that it goes into Excel perfectly. I know this is not the programming solution you were looking for, but perhaps it will get you closer to your goal.

 

[nickjar2]

Marc?

I have received some sample vb code from a member of the BO forum at businessobjects.com.

I really appreciate your response though.

Thanks,

Nick