Mike Buess
USA
3037 Posts |
Posted - 03/09/2007 : 11:32:35 AM
|
You can name the worksheet same as file...
Import Wizard: Check the Rename worksheet to file name option on the first wizard page.
Import ASCII: Select ASCII Options > Other Options and check the Rename Worksheet to Data File Name option.
That said, a worksheet name can have no more than 13 characters so the index (14th char) at the end of your file names will be stripped. Since the full path\name is usually used for the worksheet label you can always abbreviate as you like and rename the worksheet.
Mike Buess Origin WebRing Member |
 |
|