Hi,
I am sending back an ASP page to the browser with the ContentType set for Excel. The data opens in Excel fine, but I have a problem when I attempt to save the file. In Excel 2000 it attempts to save on my local machine, but with Excel 2002 (Office XP) it attempts to save the file in the location that the file was generated - namely the directory on the web server that the ASP page resides. As you can guess this causes problems as Excel gets itself into a bit of a loop trying to communicate with the remote server. Does anyone know of a way to stop this behaviour and make Excel attempt to save the file to the location set as the default save location in excel.
Thanks,
James
James Culshaw
jculshaw@active-data-solutions.co.uk
I am sending back an ASP page to the browser with the ContentType set for Excel. The data opens in Excel fine, but I have a problem when I attempt to save the file. In Excel 2000 it attempts to save on my local machine, but with Excel 2002 (Office XP) it attempts to save the file in the location that the file was generated - namely the directory on the web server that the ASP page resides. As you can guess this causes problems as Excel gets itself into a bit of a loop trying to communicate with the remote server. Does anyone know of a way to stop this behaviour and make Excel attempt to save the file to the location set as the default save location in excel.
Thanks,
James
James Culshawjculshaw@active-data-solutions.co.uk