Hi All

I'm sorry, but doing more involved Excel to data source querying in the Mac
version seems to have a large blank spot in the Internet community and I'm
struggling.

Before I starting looking at doing work again on the Mac, somebody informed
me about the Reference part of the PC version and allowed me to add the ADO
library that I know and love.

Developing multiple queries using the minimum overheads/connections and
knowing that I could gracefully close the objects and connections was an
absolute dream for me - not to mention the better control on where to put
these results once I'd got them - but the Mac just doesn't seem to have that
control and its tearing my hair out!!!

The steps I wish to take are as follows:

1) User enters a customer code into say cell A1 of worksheet 1.

2) User enters a start date in say cell B1 of worksheet 1.

3) User enters an end date in say cell C1 of worksheet 1.

4) User clicks a button on worksheet 1 to initiate a coded query.

5) The 1st query opens up a connection to an SQL database and then finds all
the invoices for the customer code entered.

6) In worksheet 1 starting from say cell A3, I 'post' the result of the 1st
query.

7) The coding then moves on to query all the sales orders for this customer
code between a date range using the same connection that was created in
point 5.

8) In worksheet 2 starting from say cell A3, I 'post' the result of the 2nd
query.

9) I do steps 7 and 8 again for 4 more queries with each query going into a
new worksheet and all using the same connection.

10) Once these queries have been completed, I then close the connection and
objects gracefully.

How can this be done via the Excel VBA version on a Mac (ie, 98 or 2001)??

Just as a side point, this querying will be done from a remote Mac
connecting to the PC/SQL Server via broadband, would it be more efficient to
run each query manually rather than the user having to wait for all 6
queries to complete? Is there anyway that Excel could let them know how far
the querying has gone?

Your assistance would be most appreciated.

Rgds

Laphan