Problem with Excel opened in IE

[MJPPaba]

Hi all,

Using Excel 2K & IE v6, I have built a workbook that works beautifully in native excel. However when I run the process via the web using my IE browser, it opens an embedded version of excel in IE and execute almost all the code apart from the last few lines.

Here is the code that is going wrong...

Range("A1").Select
Application.DisplayAlerts = False
Sheets("Employee").Delete

It fails on line 2. the error mesage is...
Runtime error 1004
method 'display alerts' of object 'application' failed

any ideas?

Matt

 

[MJPPaba]

problem solved. file typ e has an option to open in same window, I deselected this and it now opens in excel proper.

cheers
anyway.

Matt