Hi

I'm trying to do a simple export to Excel using the code below. However, the "£" sign appears as "£" in the spreadsheet.


With Response
.ClearHeaders()
.Clear()
.AddHeader("Content-Type", "text/csv")
.AddHeader("Content-Disposition", "attachment; filename=export.xls")
.Write("£")
.End()
End With


I've tried:
- changing the contentencoding
- changing it to .Write(Server.HTMLDecode("£"))
- AddHeader("Content-Type", "application/vnd.ms-excel")

but no joy.

Any help would be great.
Thanks