Thread
:
Bug? Square brackets in file name confuses sheet renames
View Single Post
#
2
JulieD
Posts: n/a
Hi Rob
this has been raised in these ngs before - it seems that ver 2003 does not
support the use of [ or ] in worksheet names any more - a quick google
search (on "worksheet names" and 2003 - sorted by date order will bring up
recent discussions on the topic)
if you'ld like to submit a request / suggestion etc to MS you can email them
at
with Excel in the subject line and an outline of why you'll like this
functionality put back in or whatever.
Cheers
JulieD
"Rob van Gelder" wrote in message
...
Hi.
I might have stumbled across a bug - could someone please doublecheck.
I'm using Excel 2003 SP1
I would submit this Microsoft but I dont have a clue how to submit a bug
to them!
Create a new workbook
Save this as test.xls
rename test.xls to test[].xls
open test[].xls
rename the worksheet to have a space in it. eg. Sheet 1 instead of Sheet1
The sheet name becomes .xls]Sheet 1
--
Rob van Gelder -
http://www.vangelder.co.nz/excel
Reply With Quote