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
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...
I have a really basic problem which just seems impossible to solve in BO. Here goes...
I have a table within areport which has columns containing Client Name, Income, Cost and a cost income ratio. At the bottem I have a total. I am using Business Objects 6.1.
Client Income Cost CostIncomeRatio...
I am using Business Objects 6.1.
Client Income Cost CostIncomeRatio
Coy A 100 50 50%
Coy B 200 40 20%
Coy C 300 30 10%
Total 600 120 20%
I initially create a single variable to calculate the CostIncomeRatio.
<CostIncomeRatio> = -<cost>/<income>
However I wanted to add...
I have a really basic problem which just seems impossible to solve in BO. Here goes...
I have a table within areport which has columns containing Client Name, Income, Cost and a cost income ratio. At the bottem I have a total.
I have defined the cost income ratio as the following formula...
I want to count the number of companies per Person regardless of how many times they appear. The reason they appear more than once it because the market changes.
Person Company Market Revenue
Jim CoyA US 10
Jim CoyA EU 20
Jim CoyB US 20
Bob CoyA US 30
Bob...
Alex, what is the difference between the 'a' (after the FROM statement) and tblName.
e.g
FROM (SELECT person, company, sum(revenue) FROM tblName GROUP BY person, company) a <----
If I try enter 'a' as the same table as tblName I receive the error:
The specified field '[tblMyTable].[Company]'...
I have the following table:
Person Company Market Revenue
Jim CoyA US 10
Jim CoyA EU 20
Jim CoyB US 20
Bob CoyA US 30
Bob CoyA EU 15
Bob CoyB US 20
Bob CoyB EU 30
Bob CoyC US 10
Ali CoyB UK 25
I wish to...
Hi, I have the following code
Dim RecordSet As DAO.Recordset
Set RecordSet = CurrentDb.OpenRecordset("Select * from tblGlobalData ORDER BY [Model], [Nationality Group], [Total Revenue Curr PEriod] DESC;")
Total = RecordSet![Total Revenue Curr Period]
Nationality = RecordSet![Nationality...
Can anyone give any guidance on how to use a weighted function using it for the following:
I have the following tables:
Table 1
SalesPerson Company Method
Blue A Phone
Blue A Email
Blue B Email
Blue B Email
Blue C Phone
Blue...
Using the following code from earlier in the thread:
BoApp.CmdBars(2).Controls("&Edit").Controls(20).Execute
it is not Copy All from BO. Could this be because I am using BO version 6.1?
Same 429 error. It is strange how CreateObject works but GetObject does not, do they not use the same registry?
Are there any alternative which would allow me to control an open BO application. The reason for this is because the BO file is very large and takes a while to open and would prefer...
Thanks Xlbo, this is very useful. Ideally I would like to control a BO application that is already open.
I tried using
set BOApp = Getobject(,"BusinessObjects.application")
However I am receiving a 'Runtime 429 - ActiveX component
cannot creat'
CreateObject works, GetObject does not work...
Now that I have the library, I guess I would use Getobject() to choose which open BO application to use. If so do I need to HWND to determine which BO application or am I able to type the Title of the open BO application.
E.g
Dim BOBJApp as Busobj.Object
Dim myreport as Report
BOBJApp =...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.