Batch renaming of many worksheets in Excel files?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Help please. A MatLab 7.2 program must read 1000 files created in Excel
2000. The current system has Excel 2003 and has different rules for sheet
names. It will not allow MatLab 7.2 to read what it considers flawed files.
The Excel files are in a directory with other files. How can I change the
names of two sheets on each of 1000 files without it being a one-at-the-time
process?
 
Please don't post the same question multiple times.

As I indicated earlier, the rules for naming sheets in Excel 2000 are the
same as those in Excel 2003. They are system-level limitations, not
Excel-specific limitations.

Perhaps the files you are trying to open are corrupted.
 
The files are not corrupted, the worksheets open in Excel 2000 with
characters no longer allowed in Excel 2003. By his reply, Dave may have made
an earlier comment that did not get attached to this thread.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Batch renaming of worksheets 1
worksheet renames - specific 0
Renaming a worksheet in excel 3
Cannot copy worksheet to another file 2
How do I dynamically retrieve the cell address of the last cell t. 1
Worksheet renaming 5
Can't rename worksheet 1
Combine Data 1

Back
Top