Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
You can try something like this. (untested)
Sub OpenAnotherInstance() Dim OldApp As Excel.Application Dim newAPP As Excel.Application Dim NewWB As Excel.Workbook Dim oldWB As Excel.Workbook Dim NewWS As Excel.Worksheet Dim OldWS As Excel.Worksheet Set OldApp = Application Set newAPP = CreateObject(, "Excel.Application") Set oldWB = ThisWorkbook 'Opeen Workbooks FA Master in NewApp Set NewWB = newAPP.Workbooks.Open(Filename) 'Where filename is the FA Master workbook 'If it were me, I'd define the active sheet somehow Set NewWS = NewWB.Worksheets("SheetName") Set OldWS = oldWB.Worksheets("SheetName") NewWS.Range("v19:v20").Copy OldWS.Range("m3:m4").PasteSpecial xlPasteValues End Sub HTH, Barb Reinhardt "John" wrote: Hi this works if both workbooks are open in the same instance... however I like to view both workbooks at once on two screens... Can this be adapted to work in a separate instance of excel? Both workbooks will be open when code runs Sub copyFA() Workbooks("FA Master").Activate Range("v19:v20").Copy ThisWorkbook.Activate Range("m3:m4").PasteSpecial xlPasteValues End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
add two cells from seperate work sheets into a cell on seperate wo | Excel Worksheet Functions | |||
Open files in seperate instance | Excel Discussion (Misc queries) | |||
Copy data into new line on seperate sheet? | Excel Discussion (Misc queries) | |||
Does anyone know how I can seperate a post code in my data sheet? | Excel Discussion (Misc queries) | |||
Is it possible to export each row of data to a seperate work book | Excel Programming |