Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.macintosh,microsoft.public.excel.programming,microsoft.public.mac.office.excel
|
|||
|
|||
VBA Query coding in Ms Excel for Mac OS 9 (ping Jim)
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PING within Excel Cell | Excel Worksheet Functions | |||
get data from CMD programs directly into excel e.g. PING | Excel Discussion (Misc queries) | |||
Ping Chip Pearson | Excel Worksheet Functions | |||
PING Bob Phillips | Excel Discussion (Misc queries) | |||
Ping anybody | Excel Programming |