PDA

View Full Version : Force excel download on webpage



JimFl78
12-17-2007, 09:58 AM
Hi,

Can anybody tell me how you would force an excel file to be downloaded to their desktop from a webpage link?

Not sure if this the correct forum for this but would appreciate any thoughts.

Many thanks in advance.

JimFL

tpoynton
12-17-2007, 08:01 PM
not a VBA question, but you can force the save/open prompt to be displayed instead of the file displaying in the browser. add this line to an htaccess file

AddType application/force-download xls

I havent tested this on IE7.

JimFl78
12-19-2007, 03:03 AM
Many thanks for this - I appreciate it outside of the normal forum material.

tpoynton
12-19-2007, 07:29 AM
Post would be appropriate for the 'other applications' forum here. I would have never read it there though!

A good forum for web questions, I find, is forum.powweb.com. You dont need to have your website hosted there, but if you ask questions just be sure to mention you are not hosted at powweb.