I have a friend that uses a database that she refers to as "Forest & Trees"
but I have never heard of that. Apparently it is a front end to an SQL
database and I was wondering if this is a standard database and if anyone
knows of a way to write "Forest & Trees" queries in VBA to bypass the need
to manually build, run and save the query and then open them in Excel.

TIA,
Ken

Hi Ken,

Possibly your friend is using Computer Associate's CleverPath Forest and
Trees softwa

http://www3.ca.com/Solutions/Product.asp?ID=1308

---
Regards,
Norman



"Ken Loomis" wrote in message
...
I have a friend that uses a database that she refers to as "Forest & Trees"
but I have never heard of that. Apparently it is a front end to an SQL
database and I was wondering if this is a standard database and if anyone
knows of a way to write "Forest & Trees" queries in VBA to bypass the need
to manually build, run and save the query and then open them in Excel.

TIA,
Ken

Thanks, Norman.

I do recall that at one time she mentioned "CA" (Computer Associates) in
connection with this.

I'll follw up thru that link.

Ken


"Norman Jones" wrote in message
...
Hi Ken,

Possibly your friend is using Computer Associate's CleverPath Forest and
Trees softwa

http://www3.ca.com/Solutions/Product.asp?ID=1308

---
Regards,
Norman



"Ken Loomis" wrote in message
...
I have a friend that uses a database that she refers to as "Forest &
Trees" but I have never heard of that. Apparently it is a front end to an
SQL database and I was wondering if this is a standard database and if
anyone knows of a way to write "Forest & Trees" queries in VBA to bypass
the need to manually build, run and save the query and then open them in
Excel.

TIA,
Ken

As I recall, Forest & Trees is a decision support product, now marketed
(owned?) by CA.

It has an Excel interface but I know nothing of it. I suggest that you do a
Google on 'Forest & Trees Excel' and do your research.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Ken Loomis" wrote in message
...
I have a friend that uses a database that she refers to as "Forest &
Trees"
but I have never heard of that. Apparently it is a front end to an SQL
database and I was wondering if this is a standard database and if anyone
knows of a way to write "Forest & Trees" queries in VBA to bypass the need
to manually build, run and save the query and then open them in Excel.

TIA,
Ken