Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Batch renaming of many worksheets in Excel files?
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? -- James L. Smith |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Batch renaming of many worksheets in Excel files?
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. "Lumen S" wrote: 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? -- James L. Smith |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Batch renaming of many worksheets in Excel files?
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. -- James L. Smith "Lumen S" wrote: 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? -- James L. Smith |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
unhide menu bar in excel - just disappeared | Setting up and Configuration of Excel | |||
Excel ignores "Text qualifiers" in Unicode files | Excel Discussion (Misc queries) | |||
Drive Erased, got Files back but only excel files scrambled, help. | Excel Discussion (Misc queries) | |||
how can I get excel at start up to only open excel files? | Excel Discussion (Misc queries) | |||
Excel Crash - Help! | Excel Discussion (Misc queries) |