Recent content by thefear

Hello folks, From what I have read, on this forum and elsewhere, the Shape statement in ADO can be used to create recursive recordsets, where values extracted from a table are used to extract further values from the same table, and so on, for as many nested statements the user has programmed...

Hi Skip, DocAgentOption lives in the BusinessObjects 5.1 Object Library. My machine's unique in the organisation, because it's got BO installed locally. Most people connect over Citrix - I've checked and they don't have the reference available.

Hello folks, I've got a ton of BO reports to schedule in Broadcast Agent (I'm using BO 5.1.4), and I'd like to so by using a bit of VBA. Below is what I have so far, put together from various sources. It fails on the .ExportAsText line. I know this isn't the correct method to use, and I've...

Glenn, Combo and Skip, Thank-you very much for your efforts. You've all got me to the answer, so you can all have a star. I've learned something here as well as getting just what I need, so once again, thank-you! Best Regards Mark

Thanks Skip, but I'm still having problems. I've put your line of code into the following... Dim cellref As Range cellref = Worksheets("Commercial").Range("Status_Options").Find(Target) If cellref Is Nothing Then Else Target.Interior.Color =...

Hi Combo. Thanks for looking! Where do I put what I'm looking for in that string?

Is that what I need? In the example above, the first entry in the table is in cell C4 but my function, (worksheet_Change)... Application.WorksheetFunction.Match(Target.Value, Worksheets("Commercial").Range("Status_Options"), False) ...returns 1. I was hoping to concatenate the returned value...

Hi Folks, I hope someone can help, this has had me going in circles since Friday. I'm trying to emulate the conditional formatting of Excel 2007 in 2003. I've been given a workbook that another has created. At the top of its only worksheet is a small table, (C4:C8), that holds 5 possible...

Thankyou Remou! Eval works perfectly!

Hello! I'll get straight to the point, and waffle on later... Can I retrieve a value from a recordset and use that value as the function it describes? e.g. If the value in rsSource!BookmarkVariable was "Date", can I parse the word "Date" to give me the date, without writing my function to...

Absolutely! Thank-you

Hi, I'm updating a raft of policy documents with new logos, etc. I've got one word document(Template) open with the new items, and I open each policy document in turn to read and paste into as necessary. I've written a macro that will save the file I'm working on with a new filename if hasn't...

Seriously, this works so well it's spooky! Ta again

That's perfect, Mr Lionelhill! Thank-you so much! Best Regards Mark

Hi folks, I hope someone can help. I keep getting caught out by things that seem evidently logical, but then aren't! I've rewritten this question several times to get it as clear as possible, but please let me know if you'd like any more information. In a nutshell: I have two linked...