Problem with Save As
Excel uses [] in the filename if you reference an external workbook in a
formula, that may be the reason.
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Nihal Chand" wrote in message
...
Hi,
While using Save As functionality, i am puttin Square Braces "[ ]" in the
file name. e.g abc[1].xls. But getting a weired error saying
This file could not be accessed. Try one of the following.
* Make sure the specified folder exists.
* Make sure the folder that contains the file is not read-only.
* Make sure that the file name does not contain any of the following
characters: < ? [ ] : | or *
* Make sure the file/path name does not contain more than 218 characters.
Of-course in the above list; #3 is restricting the use of Square braces "[
]" in the file name; but as per my understanding, it is a valid character
for
the file names in MS Windows. And also if I right click my desktop and use
"New = Microsoft Excel Worksheet" option; I can name the file over there
using the sqare braces.
I am surprised why MS Excel is restricting the use of "[ ]" in file name.
Any help will be appreciated, because I am stuck with a scenario where I
click a hyperlink(link to abc.xls) in my web page and click Open in the
Open/Save dialog. The file gets downloaded to Temporary Internet files and
contains its name like abc[1].xls. After examining the file if I use the
Save
As option to save it, at that time getting the error message.
--
Nihal Chand
|