From: Nev on 1 Mar 2010 16:12
can you help. i want to copy a sheet from a closed book into an open book
via vba macro.
Example is - run code to open the workbook, copy the only worksheet in that
book and paste it into an existing sheet in a workbook that is already open.
Can u help
From: JLGWhiz on 1 Mar 2010 19:37
You left a lot of unanswered questions so I took some liberties. You will
have to change the name "Somefile" to the actual workbook name that you want
to copy from.
Dim wb1 As Workbook, wb2 As Workbook
Set wb1 = ActiveWorkbook
myPath = wb1.Path
fName= myPath & "Somefile.xls" <<<Sustitute actual wb name
Set wb2 = ActiveWorkbook
Application.CutCopyMode = False
"Nev" <Nev(a)discussions.microsoft.com> wrote in message
> can you help. i want to copy a sheet from a closed book into an open book
> via vba macro.
> Example is - run code to open the workbook, copy the only worksheet in
> book and paste it into an existing sheet in a workbook that is already
> Can u help