Object refereence not set to an instance of an object

K

Kieran H

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Working outlook via vba code with xlsx - error 0
"The operation cannot be performed because the object has been deleted." 0
Second run of macro hangs on .show of application.filedialog object! 3
"Object not set"? 1
Delete sheets code error requires object 2
object library problem 1
Cells object question 3
Copying worksheet from hidden instance of Excel 1

Top