Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 132
Default Filename has Url in file-save dialog when saving exported Excel do

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


-----Original Message-----
Hi All,

Using the Excel API, I convert an HTML document to Excel

and stream it to
the browser. The spreadsheet appears correctly inside

the IE browser.
However, when I try to save the spreadsheet via the Save-

As from the file
menu, the Url (to the original Html doc) appears in the

filename instead of
the filename specified in the header's Content-

disposition.

Please help/share if you came across a similar

situation/problem like this
and found a solution for it. Thank you very much in

advance.

Sam
.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to save file as different filename mac Excel Worksheet Functions 6 November 21st 07 10:43 PM
Saving file using value in cell as the filename BCassedy Excel Worksheet Functions 3 July 7th 07 12:43 AM
Save file dialog box in Excel falcios Excel Discussion (Misc queries) 4 February 12th 07 08:29 PM
can't save VBA script when saving excel file thinktwice Excel Discussion (Misc queries) 5 December 27th 06 07:38 AM
Save excel file with filename = cell text TroyB[_2_] Excel Programming 1 November 26th 03 01:00 AM


All times are GMT +1. The time now is 07:46 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"