LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Rich
 
Posts: n/a
Default Worksheet name and Backward compatibility

I'm not sure if MS programmers should be blamed for this problem or VBA
developers . . .

In any case, a VBA programmer developed a program in Excel. It, of course,
uses names of Worksheet tabs. Unfortunately, some of the worksheet tab names
have square brackets in them -- "[" and "]". (i.e., "Worksheet[1]")

Also, unfortunately, our company is upgrading most PC's to Office 2003. It
turns out that Excel 2003 doesn't like square brackets in worksheet names.
When you open a worksheet with square brackets in the tab name with 2003,
Excel gives you a warning, then proceeds to open the worksheet (without
apparently modifying the worksheet names).

However, when the worksheet is saved, it converts brackets to parens -- "("
and ")".

This e-mail boils down to two questions:
(1) Is there a way to prevent Excel 2003 from turning brackets to parens in
worksheet tabs, and
(2) if not, is the only fix doing a search and replace in the VBA code?

Thanks for any information . . .

Rich

P.S. From this problem, I learned to consider the use of indexing when
referring to Worksheets within a VBA program.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 08:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"