Error Opening excel spreadsheet

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • givsu2023
    New Member
    • Apr 2023
    • 1

    Error Opening excel spreadsheet

    I maintain an application written is classic ASP. We are getting the following error when trying to open any of the xlsx files: "Excel cannot open the file 'FileName.xlsx' because the file format or file extension is not valid. Verify that the file has not been corrupted and the file extension matches the format of the file." I do not have a problem creating the file and saving the xlsx on the machine. Open the xlsx is the problem. The organization update the Microsoft 365.

    I am using the code below to create the xlsx:

    Response.Buffer = TRUE
    Response.Conten tType = "applicatio n/vnd.ms-excel"
    ''''attachment = open a file save dialog
    Response.AddHea der "Content-Disposition", "attachment ; filename=" & txtReportName & ".xlsx"

    Thank you for your help.
Working...