>I have a com object that an ASP page calls. It takes an sql statement and creates a temp excel file that the browser is pointed to for download. Works great and fast, but I had selected type xls so some of our users who still have win 3.1 could still use. One of my win NT users is trying to sort the excel by a date field and excel will not change the format of the column to allow this (comes down as 01-Jan-98). Tried from excel to file save as type 5 or 7 with no results. tried format change and then caluculate. The only way I can get the excel to update the format is one cell at a time.
>
>I have already changed the com object to download type xl5 and everything works fine, if I have to I can add another selection from the asp page, but I was wondering if I am Missing something simple.
>
>
>TIA
>Jeff
The problem with the date fields is familiar. When you do the COPY TO command, use an .XLS extension, but do not specify TYPE XLS. Let it create a dbf. With the .XLS extension, it can be opened in Excel even by double-clicking on the filename in Explorer. The date fields will then allow sorting. Try it.
Dana
Where's the damned Any Key?...too late