View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Saix News Saix News is offline
external usenet poster
 
Posts: 3
Default vb.net and excel xp

hi,

i have an vb.net windows forms app that creates an excel workbook.

the problem i am having is that the function that does this does not seem to
be releasing excel completely once it is finished doing what it needs to do.
if the user creates the spreadsheet from the app and then tries to open a
totally different workbook (say by double clicking it in windows explorer),
then excel seems to hang - it opens, but does not open the document.

if i first close the vb app and then do the same thing, then the second
workbook opens without a problem.

i have tried to make sure that all references to the workbook i have created
in code are with reference to the app object i create in the function, and
have also set all excel related objects to nothing at the end of the
function, but am still having a problem.

does anyone have any bright ideas?

if this is not the correct news group for this question then i would also
appreciate it if someone could point me in the right direction there.

many thanks
michael