Help!

[Markmesa]

Hi
I will start by saying i am not at all good with macros but have been asked to put a button on a excel sheet that will open every other workbook in the same folder and copy the sheets individually to separate workbooks and name the workbook the same as the sheet it came from.
Suffice as to say i am stumped. I have tried adapting other peoples code but always end up with unexplainable errors.
Your help is greatly appreciated.

 

[Markmesa]

For example
I have 5 workbooks in c:\temp
in the workbooks i have AAA sheet, BBB sheet and CCC sheet .etc
I want to have AAA copied to a new workbook called AAA and the BBB copied to another workbook called BBB etc and them both saved into the origin folder.

Hi
I will start by saying i am not at all good with macros but have been asked to put a button on a excel sheet that will open every other workbook in the same folder and copy the sheets individually to separate workbooks and name the workbook the same as the sheet it came from.
Suffice as to say i am stumped. I have tried adapting other peoples code but always end up with unexplainable errors.
Your help is greatly appreciated.