Search results for query: *

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

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?

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

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

I have the following data: Client Type Sales A Red 12 B Blue 17 C Blue 3 D Green 43 E Blue 27 F Red 6 G Green 30 I would like to add a rank column which ranks the Type (red, blue, green) depending on...

This is probably very easy but I cannot seem to add a button/toolbar to an add-in. I have written code for an addin and would like to add a button in order to run the macro, so that I can then email the addin and it will install on someone elses machine. Any ideas? TIA Cage

When I link to a cell in a closed workbook using the formula: = 'C:\temp\[text.xls]sheet1'!$A$1 It only returns the first 255 characters in that cell. However it I open the workbook I am linked to, then it returns the all of the characters. Therefore my question is is it possible to return all...

I have a range e.g myrange=A,B,B,C,D,C,E and I would like to create a new range containing only distinct items, e.g distinct(myrange) = "A,B,C,D,E" VBA supports a union and intersect, but I cannot find one for distinct, is there a simple function which will do this or do I need to create my...

Hello, I have workbook which has two worksheets A and B. SheetA contains data, whilst sheet B links to sheet A. However every month sheet A needs updating, so I delete it and replace it. The problem is when I do this, the links on sheet B have a #Ref! error. It is possible to keep the link...

Hello, I have created a new custom bar menu (e.g like File, Edit, View). In it have placed custom buttons A, B, C. I have some code which when you click on A it opens a specific directory, B opens a different directory and C a different one still. I plan having this for about 20 different...

Hello, I would like to have it so when I receive an email via outlook overnight it automatically runs a macro in excel. Is it possible to run the code below directly from excel, otherwise does anyone know how I can run an excel macro from outlook? cheers Cage ------------------ Sub...

I have a table with Customer Preferences, for each preference I have assigned a binomial code eg preference 0001 = 1, preference 2 = 0010,preference 3 = 0100, preference 4 = 1000 and so on. I now wish to create a query which will display the preferences of a particular customer. The way I...

I am trying to build a query which will use mulitple criteria from a function. For example a table contains 5 records, "A","B","C","D","E" I would like to have the query display records "A","B","D" using a...

Any ideas how I could link a form in outlook 2000 to Access 97 or would it be better idea to upgrade to Access 2000? TIA Cage

Does anyone know how I can tell who lasted saved a document using VBA? TIA Cage