ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Denies certain characters. (https://www.excelbanter.com/excel-programming/352530-denies-certain-characters.html)

[email protected]

Denies certain characters.
 
Hi,

Why does microsoft office not allow certain chars in the file name?

i.e. '[', ']' is not allowed to be part of a file name.

I was just curious because i have a labelling format that uses '[' and
']'.

Maybe an excel guru could shed some light on this subject?


Tom Ogilvy

Denies certain characters.
 
when you link to a close file you use

='C:\myfolder[MyFiles.xls]Sheet1'!A1

so I suspect the

='C:\myfolder[My]Files.xls]Sheet1'!A1

would be problematic.

--
Regards,
Tom Ogilvy



wrote in message
oups.com...
Hi,

Why does microsoft office not allow certain chars in the file name?

i.e. '[', ']' is not allowed to be part of a file name.

I was just curious because i have a labelling format that uses '[' and
']'.

Maybe an excel guru could shed some light on this subject?





All times are GMT +1. The time now is 07:49 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com