export to excel???

[jgoodman00]

I have written some code which runs a number of queries & then exports these results to an excel spreadsheet. However, in order to improve performance i have set the queries only to run if necessary. This produces a problem. Instead of running the query & returning null, thus wiping previously exported data, the query doesn't run. This means data previously exported remains in the spreadsheet.

So, does anyone know how i can remove all the previous data within the excel spreadsheet, from within access???

James Goodman
j.goodman00@btinternet.com

 

[BlindPete]

The most direct way is through automation. You will have to write some VB code. Search for the help file "vbaxl*.chm". It contains the complete objects map and exmaples.

Enjoy.
-Pete