can we copy our "sheetnames" too?

Giganews Newsgroups
Subject: can we copy our "sheetnames" too?
Posted by:  Martyn (ay…@post.com)
Date: Thu, 20 May 2004

Hi,
The below code copies the content of our workbook sheets seperately as new
workbooks, but saves the sheets with default "Sheet1", "Sheet2" name format.
Can we also copy the used sheet names while copying?
TIA

Replies