I have a web forms application that uses Excel to generate a spreadsheet. I
need to save that spreadsheet by calling the SaveAs routine. I have no
problems with the code running under XP. Running under Vista I cannot save
the spreadsheet. I was originally trying to save it to the App_Data
directory that is created in c:\Program Files\MyApp\. Apparently no matter
what I do Vista will not allow me to save a file anywhere under Program
Files. I've tried using the SpecialFolder options for MyDocuments and
Internetcache - those don't work under Vista either. I also tried to save to
the c:\Windows\Temp directory, again without success.

Can somebody tell me what I need to do in order to save a spreadsheet in a
manner that works under both XP and Vista?