Can't terminate the excel instance from VB

[Gerhard]

I create hyperlinks in an excel workbook from VB. If i
want to add more hyperlinks I first have to close my
application before I can add more hyperlinks. I have tryed
to quit, close workbook and application and set the excel
object to nothing but the excel object keeps on running in
the background.

 

[Bill Lunney]

Perhaps there is a hidden instance/s of Excel running? Check it by using
the task manager. Does the Application.BeforeClose event contain anything
that could prevent termination?

These are the only things I can think of that would be relevant. When you
say you create hyperlinks in the workbook is this an existing workbook that
you're opening or are you instantiating Excel then doing all the work in
code? If the later can you instantiate Excel, say set a cell value then
close it sucessfully? If not, there's something wrong with the way you're
setting things up/closing them down.


--

Regards,


Bill Lunney
www.billlunney.com