VB to copy a sheet to active workbook

  • Thread starter Thread starter Darin Kramer
  • Start date Start date
D

Darin Kramer

Howdie

I need some vb that will help solve the following...

Scenario - I got two files open

File 1 - entitled Master with sheet called final in it (always be this
set up of file and sheet name)
File 2 - VARIABLE name, ie it will change, but it can be the active book
when I run the macro.

What I need is to copy the sheet master from file 1 into file 2.

Thanks!!!!

Regards

Darin
 
Hi Darin

Test this one
With file 2 active

Dim Wb1 As Workbook
Dim Wb2 As Workbook
Set Wb1 = ActiveWorkbook
Set Wb2 = Workbooks("Master.xls")
Wb2.Sheets("final ").copy _
after:=Wb1.Sheets(Wb1.Sheets.Count)
 
This code assumes that the code is running in th atcive workbook...

Workbooks("Master.xls").sheets("Final").Copy _
After:= ThisWorkbook.Sheets(1)

This code assumes that the code is running in Master.xls...
Thisworkbook.Sheets("Final").copy _
After:= Activeworkbook.Sheets(1)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to Compile Data from Different Sheets 2
Run macro from active workbook whose name keeps changing 20
Help with copying a sheet from One workbook to another workbook 1
Macro to Combine Data from Multiple Sheets with Cell References 4
Creating several smaller worksheets from a 'master sheet' 3
Copying cells and formula from closed workbook to all sheets in open workbook 0
Macro to copy sheets to another workbook fails after about 45 copi 3
Unable to change ActiveSheet within Workbook_Open 2

Back
Top