Search results for query: *

Rob You get a big star for the comment on Microsoft Excel Objects. I've been coding VBA in xl for years and have never come across that! Thanks. Tom

Sorry - we posted at a similar time. I thought you were asking to link to explorer, which from your latter post appears incorrect. I'm afraid I don't actually understand what you are asking any more! Tom

Hi Geo You can insert a hyperlink to explorer.exe but I cannot make it open the correct folder. You can usually add extensions onto executable file paths to do things like that, but I cannot make it work with explorer. Sorry I can't be any more help. Tom ps. If you did this with code, then...

Hi guys I want to create a very simple function and make it available to a wide range of BO users. The function takes the form: Function myFunc(tempString as String) as String I want it to be available from the variable editor dialogue. (It is not possible to replace this function with an...

Hi Can anyone tell me how to make the Median function work?? I can't. Cheers, Tom [sadeyes]

Could you describe the problem? Are you saying this procedure doesn't get unique results, or that it gets an error message? Tom

Hi All I have given myself a function in Excel, which joins a range of cells together seperated by commas. This creates a string which can be pasted into an "In List" criteria in a business objects data provider. I can paste up to 1000 distinct employee IDs (length of 9 characters)...

Thanks for your view T.Blom It strikes me as odd, though. From a designers perspective, I can see what you're saying, but rather than make it central functionality, there's nothing architectural to stop there being a simple external function which could do a "fill-in" based on certain...

Hi all I need to insert a simple average calculation into lots and lots of columns. Is there a way of doing this that does not involve either: 1) right clicking every column and selecting "Average" from Calculations. 2) Going through slice and dice, clicking on every item, clicking...

Thanks T.Blom, The links led me to some pretty cool stuff, but the alerter thing isn't powerful enough to compare the results of calculations to the results of other calculations (or I'm doing something wrong). I think this might need VBA, but I'm a total newbie to VBA in BO. (I'm perfectly...

Hi All Is simple conditional formatting possible in BO? Can I do it through VBA? In essence, I have: Question Ans 1 Ans 2 Ans 3 Ans 4 Ans 5 Average xxx xxxx? 3 4 4 3 1 3 I want any answers which deviate by more than 1 from the average to show up...

Based on what you've said, this should work: stAppName = "C:\Program Files\ORL\VNC\vncviewer.exe /" & lsmtag BUT I haven't tried it, and am no expert in shelling other apps. Apologies if it doesn't work. Tom

Hi all We are using BO to analyse data gathered from an employee survey. However, by using the objects in the data provider carefully, management will be able to identify indivuals in key areas. This is not desirable. Is there a way I can add some VBA code to the report that counts the number...