Thanks for that. I have removed the step of creating the query. That was an unecesary step. I have tried stepping through the code line by line. It works really well and it the excel application closes completely each time its just that the second time the code runs through the loop the error doesn't run through my error handling it comes up in a normal VBA error window as if my On Error

I have a button uses the below code to create a report by - creating a query - copying the query via DAO recordset to Excel The Excel end is a workbook per month and a worksheet per day named accordingly. To set up a new workbook per month I have the code try to open the current month and if it doesn't exist it goes through the error handling to creating a new file. This code works well

> I downloaded the ' Delphi.NET Generics by Tim Jarvis' video by following the links from http://borland.interwise.com/borland/iClass/PX7778/ However when i tried to run it through interwise it asks for a connection. Is is possible to run this with out any connection?Alternatively what connection details should I input? Venkatesh Works fine for me (or at least, as fine as these