Running an excel file with macros in browser.

[Kai]

I have an excel file sitting on the server that users on
the intra net access through the browser.

Once the user has run the macros and closes all windows,
EXCEL.EXE still shows up in the task manager. If you close
it, it will ask if you want to save changes to the file.

Does anyone know what causes this and how to fix this?

 

[Tushar Mehta]

Are you running XL through automation? If so, it is your
responsibility to close (save, if necessary) any workbooks, quit XL and
set the automation variable to nothing.

If you are doing that, then, sometimes this happens because there are
unqualified references to XL objects. For example, any reference to
Cells() or Range() -- instead of xlObject.Cells() -- will result in
XL.exe hanging around.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions