Excel 2000/XP wont close when opened via html link

[mts176]

Does anybody know why I can't close excel, when I open it with a hyperlink.

It will close fine in excel 97 but 2000/XP it doesn't close. Sometimes I get an error other times I don't. It all depends on which computer I am on. The error occured on an XP machine. I have tried it on two other machines and have not gotten an error. Not sure if it is just user error or not. I have not tried it on the "error" machine.

I have tried:
ActiveWorkbook.close
Application.quit
Workbooks("BOOK1.XLS").Close SaveChanges:=False

Any suggestions, comments, or opinions would help greatly.

 

[PHV]

Any chance you could post the whole error message and the code you use ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244