Search results for query: *

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...

thanks

Hello, does anyone know if it is possible to change the row heights within a table in BO using VBA? TIA Cage

Does anyone know if it is possible to change alerters using vba?

Great thats was just what I was looking for. thanks.

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 =...

fantasic! thanks

I am trying to change BO filters / variables in from Excel. Is it possible to load a BO library containing BO objects e.g ActiveReport. TIA