Help with macro for copying sheet to existing workbook

[patrick200]

Hi all
I'm trying to copy one sheet and insert it to another existing workbook (storing it for future reference)..... It will copy the sheet but it also copies over the other sheets already in the workbook..........I have no idea what I've done wrong

I'm using Excel 2010 on Windows7

here's the code I have so far

Sub Sample()
Workbooks.Open Filename:=("C:\Users\laptop\Desktop\SAVEDSCHEDULE.xlsx")
Windows("Test Schedule - Copy.xlsm").Activate
Sheets("Sheet3").Select
Sheets("Sheet3").Copy Before:=Workbooks("SAVEDSCHEDULE.xlsx").Sheets(1)
Application.DisplayAlerts = False
Workbooks("SAVEDSCHEDULE.xlsx").SaveAs "C:\Users\laptop\Desktop\SAVEDSCHEDULE.xlsx"
Application.DisplayAlerts = True
Workbooks("SAVEDSCHEDULE.xlsx").Close
End Sub


Thanks.......Pat

 

[JoeMo]

There's nothing in the code that would copy more than Sheet3 that I can see. Have you tried stepping through the code (press F8 key repeatedly) to see what's happening? Have you checked to see that you have not grouped all the sheets when the code is run?

 

[patrick200]

There's nothing in the code that would copy more than Sheet3 that I can see. Have you tried stepping through the code (press F8 key repeatedly) to see what's happening? Have you checked to see that you have not grouped all the sheets when the code is run?

Hi there.....Thanks for the reply
Thats actually what I want to do......Copy sheet3 and save it in another workbook...then, as "data" is changed in the original sheet3....I want to save a new copy of sheet3 in front of the old in the other workbook.......I hope this makes sense.......but as I save a new sheet3 to the other workbook the sheet3 that was previously saved changes to the new sheet3.........It's actally very odd.....I have no idea how to correct it.


Thanks...Pat

 

[JoeMo]

Hi there.....Thanks for the reply
Thats actually what I want to do......Copy sheet3 and save it in another workbook...then, as "data" is changed in the original sheet3....I want to save a new copy of sheet3 in front of the old in the other workbook.......I hope this makes sense.......but as I save a new sheet3 to the other workbook the sheet3 that was previously saved changes to the new sheet3.........It's actally very odd.....I have no idea how to correct it.


Thanks...Pat

You can't copy a sheet to a workbook that has the same name as an existing sheet in that workbook.

 

[patrick200]

AH HA....... Thanks.....I'll rename the sheet before I paste it

Thanks for the info.......Pat