Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can not save a file
Hello:
I am trying to save an Excel 2003 spreadsheet into a folder which contains brackets. Example "C:\[My Folder]". Everytime I try to save it I get an error saying the file name is invalid due to the bracket, but there are no brackets in the file name. The path has brackets. I was able to save files here before. Does anyone have any idea how to get around this? Harrison Midkiff |
#2
|
|||
|
|||
Looks like a bug in Excel. I don't have a good workaround. It seems that if
you opened the workbook from this folder you can save it, if you do not change the file's name. So you'd have to save it in another folder initially and move it to the [folder] and open it from there. Also it seems that you can save the workbook with a macro as long as it doesn't specify the full path: ActiveWorkbook.Save "abc". This means the [folder] would have to already be the current folder. You can set that separately: chdir "c:\[aaa]" Or maybe you should rename the folder;) -- Jim "Harrison Midkiff" wrote in message ... | Hello: | | I am trying to save an Excel 2003 spreadsheet into a folder which contains | brackets. Example "C:\[My Folder]". Everytime I try to save it I get an | error saying the file name is invalid due to the bracket, but there are no | brackets in the file name. The path has brackets. I was able to save files | here before. | | Does anyone have any idea how to get around this? | | Harrison Midkiff | | |
#3
|
|||
|
|||
Or maybe you should rename the folder;)
I would suggest that might be the most effective alternative, if possible. |
#4
|
|||
|
|||
"Harrison Midkiff" wrote in message ... Hello: I am trying to save an Excel 2003 spreadsheet into a folder which contains brackets. Example "C:\[My Folder]". Everytime I try to save it I get an error saying the file name is invalid due to the bracket, but there are no brackets in the file name. The path has brackets. I was able to save files here before. Does anyone have any idea how to get around this? Harrison Midkiff I remeber someone asked about this before. It seems as if brackets are considered as illegal characters when used as a path. I think this is a bug in Excel. /Fredrik |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excell2003 (SP-1) File > Save and File > Save As.. grayed out | Excel Discussion (Misc queries) | |||
Need to save file for mainframe | Excel Discussion (Misc queries) | |||
save excel file from a table delimited file (.txt) using macros | New Users to Excel | |||
Can't save new excel file | Excel Discussion (Misc queries) | |||
Save & Save As features in file menu of Excel | Excel Discussion (Misc queries) |