| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
name the sheet the same as the file name
"ward376" wrote in message
... Sheet names are limited to 31 characters (through xl 2003 afaik). You could try something like this... ActiveSheet.Name = Left(ThisWorkbook.Name, 31) 'or right as far as that goes That raises the issue of uniqueness of sheet names as the leading/trailing 31 characters might be the same for more than one file. Also, my recollection is that there are characters allowed in filenames that are not allowed in sheetnames. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why does a Multi-sheet/user file open on sheet two every time? | Excel Discussion (Misc queries) | |||
| Split text file into Excel sheet and separate the final results intoa new sheet | Excel Worksheet Functions | |||
| copy the same raws of all sheets from about a 100 file to a new sheet of a book and save the file | Setting up and Configuration of Excel | |||
| Lookup on a sheet so that every time when file open it copes data from another file sheet | Excel Programming | |||
| Updating excel sheet with selected data from another sheet in the same file | Excel Worksheet Functions | |||
Threaded Mode
