Batch renaming of worksheets

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

Guest

Help - A MatLab 7.2 program must read 1000 Excel files written in Excel 2000
which allowed characters (,^,/, etc. in sheet names. Excel 2003 will not
allow characters you would not use for a filename. Excel 2003 on my machine
will not allow MatLab 7.2 to read these files and directs MatLab to report an
error. Is there a way to change all 1000 Excel sheet names without doing it
one-by-one? They are mixed in a directory with other files.
 
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 many worksheets in Excel files? 2
worksheet renames - specific 0
Batch converting CSV files from comma-decimal to period-decimal 3
How to rename Excel Sheet with more characters? 4
Worksheet renaming 5
Cannot copy worksheet to another file 2
exporting a multiple sheet worksheet to text 2
How to "freeze" all cells in Excel sheets? 1

Back
Top