IIS 6.0 and Excel

[a-dre]

Previously I had my Intranet Server on a Windows NT Server but I have recntly acquired a new machin and convert but the New Server is running Windows Server 2003. Now my pages that were opening perfectly with the other server is telling me that;

Microsoft Excel cannot acces the file ... There are several possibl reasons:
-The fil name or path name does not xtist

-The file you're trying to open is being use dby another program. Col the document in the other program, and try again.

-The name of the workbook you'r trying to save is the same as the name of another document that is read-only. try saving the workbook with a different name

The code i use is
Response.ContentType = "application/vnd.ms-excel"
placed at the top of the page I want to open in excel.

NB. The pages were all opening on the machine running windows nt server.

Can anyone assist me, this is very urgent

[a-dre]

Is there Anyone in Here!!!
HEllo!!!!!!

[Arch_Angel]

Sorry a-dre. I was researching your problem but couldn't find anything that would help you. From everything I have read about IIS 6 is that it has everything disabled or turned off when the server is setup.

I have no experience with IIS 6, but have you checked the list of reasons that the error provided to you?
- Have you checked the file name or path to the file?
- Have you checked if the file is already opened by another program?

[Arch_Angel]

Ok, I checked with some friends of mine who are server admins and they say the following code works for them on IIS 6.

Response.ContentType = "application/vnd.ms-excel"
Response.AddHeader "Content-Disposition", "attachment;filename=Pre_Inspection_Listing.xls"  'forces the save/open box

So I don't know if you have the extra Response.AddHeader code.

[a-dre]

Thank you for your reply but they did not help.

Do you have any other suggestions?
Or someone mentioned that all the features have been turned off for windows 2003 server . Doe sanyone have any ideas on what is needed to turn on?

Thanks

[Arch_Angel]

Can I see a copy of the code you are using?

[a-dre]

The addHeader did actually work thanks alot,

And sorry for taking so long to reply

[Arch_Angel]

You're Welcome.

But how come it didn't work before? You did something wrong in the code?