Robert,
Check Message #
597306. The QuickReport() function exports the currently selected table to Excel, applies some formatting and optionally allows you to save and/or print the sheet. It's probably a good start. All you have to do is run your query into a cursor before calling QuickReport(). In order to print the report to a specified printer, checkout the ActivePrinter property in Excel.
HTH
>I must begin by thanking ALL of you for the great help and input you have provided in helping me get this far.
>
>I have a new task:
>1.) Programmatically run a query when a 'FINISHED' button is clicked
>2.) Export the results to a EXCEL( 97) table
>3.) Print the table to a specified printer
>
>I'm beginning to kludge this out as I write this, but I know somebody out there has done this before and can possibly save me a lot of errors!!
>
>Thanks in advance!
>Bob Ross
Daniel