Object refereence not set to an instance of an object
 

Hi folks,

I have a reporting application that runs without error in Excel 2000
but under Excel 2007
when I close the workbook, the Workbook BeforeClose event fires and
runs as expected. I am then prompted to save the workbook (default
behaviour not coded)

However,

I then get the following error:

Object reference not set to an instance of an object

I cannot step through to the error as it it flashes up immediately
after the prompt to save and I do not believe any of my code is
running at this time

I have checked that all objects are set to Nothing

Any thoughts would be greartly appreciated

Cheers

Kieran