Extracting an excel worksheet into a file

February 16, 2011 at 10:40:21
Specs: Windows 7
I have several excel files. In each of these excel files, I have one worksheet that contains important data. I want to create a batch file that can copy this worksheet from each of the excel files and save each one of them in a separate file. (The extracted worksheet can be saved in any format)
Thank you in advance for your assistance

See More: Extracting an excel worksheet into a file

Report •


#1
February 18, 2011 at 21:57:01
re: "I want to create a batch file that can copy this worksheet from each of the excel files and save each one of them in a separate file."

As opposed to copying the sheet, I think it would be easier to delete all the other sheets and then save the remaining sheet as it's own file. The original file wouldn't be impacted because it wouldn't get saved.

Is it always the same sheet in each workbook? Perhaps the same name or same location (Sheet1, Sheet2, etc.)?

Somehow we'd have to tell the code which sheet in each file we're interested.

You'll need to provide some more detail before we can offer any assistance.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question