View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default 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