2 Replies - 54121 Views - Last Post: 17 March 2013 - 12:51 PM Rate Topic: -----

#1 viceroy01  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 1
  • Joined: 13-March 13

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  Icon User is offline

  • Fire giant boob nipple gun!
  • member icon

Reputation: 2891
  • View blog
  • Posts: 9,599
  • 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
  • +
  • -

#3 BobRodes  Icon User is offline

  • Your Friendly Local Curmudgeon
  • member icon

Reputation: 571
  • View blog
  • Posts: 2,979
  • Joined: 19-May 09

Re: copy a sheet from workbook to another one

Posted 17 March 2013 - 12:51 PM

View Postandrewsw, on 16 March 2013 - 02:20 PM, said:

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

:lol:
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1