Number gets added to filename
If you create a new workbook based on a template named myTemplate (say), you'll
end up with workbooks named:
myTemplate1
myTemplate2
....
myTemplateN
It won't put those numbers in brackets [] and the number appears at the end of
the name.
And there won't be an extension for this newly created file until the workbook
is saved (no .xls until it's saved).
And just to head off another possibility, if the file has multiple windows,
you'll see:
myBook1.xls:1
and
myBook1.xls:2
(note the colon and then the number)
Rookie 1st class wrote:
Is it a template? If you open a second with the first open does it become
*[2]*?
"Dave Peterson" wrote:
I would think that excel wouldn't be doing anything but opening a file stored on
a disk somewhere. I've never seen it change the name of a file when opening it.
But I don't speak the web stuff.
You may want to ask in a forum dedicated to whatever language your web
application is written?????
ExcelUser wrote:
I don't think so since the problem exists even when I try to open a file
which does not exist already.
"Dave Peterson" wrote:
Any chance it's the web application that's noticing that there's an existing
file with that name, so it decides to make a unique filename????
ExcelUser wrote:
My web application generates an excel and sets a filename to the excel for
download. Sample file name is "aaa-09.02.2006-to-09.08.2006.xls". This is how
the code will show:
response.setContentType("application/vnd.ms-excel");
response.setHeader("Content-Disposition", "attachment;
filename="+fileName+";");
But when I try to download the excel from the application, excel opens /
saves the file as aaa-09[1].02.2006-to-09.08.2006.xls thereby inserting
numbers to the filename. I have tried the solutions given in the group like
setting the Excel "OPEN" as default,etc., but nothing seemed to work. Please
let me know how to force excel to retain the filename.
--
Dave Peterson
--
Dave Peterson
--
Dave Peterson
|