Filename has Url in file-save dialog when saving exported Excel do

G

GJones

Hi Sam;

This is the normal behavior since when you tell the web
server to return the type as Excel what it really does is
to server up the html page in Excel and not a real Excel
sheet. You can create a VBA routine that will
automaticall save it and make it a real spreadsheet.

Then you will be able to force the name and file type.

Thanks,

Greg
 
Top