Closing BO without saving

[Cage]

I am trying to use vba from excel to open, refresh & close a BO report. I have managed the open & refresh part, however I am stuck on the closing part.

I have tried using:

Application.CmdBars(2).Controls("&File").Controls("E&xit").execute

Is there another way of achieving this, e.g

Boobj.application.close

In addition, when closing it asks whether I want to save the file, which I don't as it is read only. Is this overcome simply by turning off the alerts?

thanks

Cage

 

[Cage]

I worked it out. Application.quit seems to work.

However does anyone know if it is possible to turn screen refreshing, e.g like the excel vba application.screenupdating = false

 

[xlbo]

There is no screenupdating property in BOBJ - you may get some joy from:

Application.interactive = false

however

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question