L
Laphan
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
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