| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB to copy a sheet to active workbook
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 *** Sent via Developersdex http://www.developersdex.com *** |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VB to copy a sheet to active workbook
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) -- Regards Ron de Bruin http://www.rondebruin.nl "Darin Kramer" wrote in message ... 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 *** Sent via Developersdex http://www.developersdex.com *** |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VB to copy a sheet to active workbook
I see I have a space after the sheet name "final "
Remove it before you test it -- Regards Ron de Bruin http://www.rondebruin.nl "Ron de Bruin" wrote in message ... 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) -- Regards Ron de Bruin http://www.rondebruin.nl "Darin Kramer" wrote in message ... 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 *** Sent via Developersdex http://www.developersdex.com *** |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VB to copy a sheet to active workbook
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) -- HTH... Jim Thomlinson "Darin Kramer" wrote: 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 *** Sent via Developersdex http://www.developersdex.com *** |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VB to copy a sheet to active workbook
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy value from active sheet to another workbook | New Users to Excel | |||
| Copy my active sheet to a new sheet and open with an input form | Excel Programming | |||
| VB Method to copy and save only one sheet of the active workbook | Excel Programming | |||
| Copy from active sheet and paste into new sheet using info from cell in active | Excel Programming | |||
| copy worksheet from closed workbook to active workbook using vba | Excel Worksheet Functions | |||
Linear Mode
