| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Batch renaming of worksheets
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Batch renaming of worksheets
Excel 2000 doesn't allow those special characters in sheet names.
"Lumen S" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| batch file to open multiple worksheets | Excel Discussion (Misc queries) | |||
| Problem renaming worksheets | Excel Discussion (Misc queries) | |||
| Renaming File Removes Worksheets | Excel Discussion (Misc queries) | |||
| Renaming Worksheets | Excel Worksheet Functions | |||
| Can I batch rename new worksheets | New Users to Excel | |||
Linear Mode
