copy a sheet from workbook to another one

Posted 16 March 2013 - 01:02 PM

Hello everybody,

Maybe mi question is easier, however I have spendt a week loking for an answer.

I have 2 workbooks and want to copy a sheet from a workbook to the other one.
both workbooks are in the same folder, of course differnt name.
I am using vb6.0 and Excel 2010.

Regards

Is This A Good Question/Topic? 0

Replies To: copy a sheet from workbook to another one

#2 andrewsw

Provides a RESTful service

Reputation: 1096

Posts: 3,414
Joined: 12-December 12

Re: copy a sheet from workbook to another one

Posted 16 March 2013 - 01:20 PM

Really? Spent a week looking for the answer? :whistling:

Learn to use the macro recorder in Excel; this is the easiest way to get started:

Sub Macro1()
    Sheets("Sheet1").Select
    Sheets("Sheet1").Copy After:=Workbooks("Book1").Sheets(3)
End Sub

The macro creates some unnecessary code - for example, the first .Select line is unnecessary - but it will always giving you a starting point.

Spent a week..? The very first link on a Google search leads me to this page:

http://www.ozgrid.co...ead.php?t=59938

Was This Post Helpful? 1