>I am creating a application that collects numbers from a labratory experemnt, and sends them to Excel (using OLE/VBA automation) to print up a nice graph (and I _realy_ want to do this in excel: it took me a couple of days to format the graph correctly (the X axis is non-linear))
>
>I also want to send over some info from the customer table (the adderess, ATTN:, etc) as well as data from a specification table (which is to be used to draw spec bands on the graph.)
>
>How do I select the specific records and access there fields in the code of the button that executes the data transpher to Excel?). There should be only one record in both the customer or spec tables that have the same file # or spec-type name respectivly.

Do you need to get the customer ID from the Excel file or do you have that before you click the "Do an Excel Graph" button? If you know it, then select the correct record(s) so you can put the data into variables or know the record pointer is correct.

Next, send the lab data to the Excel file.

Third, insert a row or two at the top of the Excel file (use the VBA for this) and put your Customer Name/address into the correct cells to display the way you want them to.

Finally, display your graph.

If the data is sent directly to Excel (as is the case for many lab instruments), you'll have to discover which cell has the Cust.ID, get the value after opening the file, then do your Seek, Insert, etc.

HTH
Barbara