I'm not sure I'm clear on what you're asking. Is the client using a browser to download an excel-formatted file from a web server?
If this is the case, and assuming you don't have control over the file that gets put on the server, the macro is probably (definitely?) the most straight-forward solution. I imagine you could build an applet/application that would get the file, and using some third-party excel api, modify the file to format everything as currency. That sounds excessive, though. -----Original Message----- From: Nahid, Nazneen (CORP, Consultant) [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 30, 2002 12:23 PM To: JDJList Subject: [jdjlist] Excel File Download Hi Everybody, Problem - Client wants to export the data from a web in an excel file. When he downloads the excel file, he wants the cells of the excel file to have the format not as "General ", but to have the format as "Currency", "number" etc. I know how to download the excel file as "CSV", but give each column of the cell a format as "Number" ? We also have the solution that download the exel and let the user run a macro? But this is not favoured by the client ? Any ideas/Solution? Thanks Nazneen To change your membership options, refer to: http://www.sys-con.com/java/list.cfm To change your membership options, refer to: http://www.sys-con.com/java/list.cfm
