Hi,
Is it possible to copy a known range from a workbook that is not open,
and paste that range into an open workbook?
Usual TIA
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
Hi,
Is it possible to copy a known range from a workbook that is not open,
and paste that range into an open workbook?
Usual TIA
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
Richard,
It sepends on whether you want values or everything (formatting, formulas, etc.).
If you want just values, you can create a link to the cells that you want, and won't need to open
the file. Otherwise, you need to open the file to do the copy.
HTH,
Bernie
MS Excel MVP
"Richard Buttrey" <[email protected]> wrote in message
news:[email protected]...
> Hi,
>
> Is it possible to copy a known range from a workbook that is not open,
> and paste that range into an open workbook?
>
> Usual TIA
>
>
> __
> Richard Buttrey
> Grappenhall, Cheshire, UK
> __________________________
You can extract data from a closed workbook. If your range is set up like a
databasae, you can use ADO.
http://www.erlandsendata.no/english/...php?t=envbadac
You can use formulas (probably the fastest)
With Range("a1:Z26")
.formula = "='C:\My Folder\[MyFile.xls]Sheet1'!A1"
' now replace the formulas with the value returned
.Formula = .Value
End With
--
Regards,
Tom Ogilvy
"Richard Buttrey" wrote:
> Hi,
>
> Is it possible to copy a known range from a workbook that is not open,
> and paste that range into an open workbook?
>
> Usual TIA
>
>
> __
> Richard Buttrey
> Grappenhall, Cheshire, UK
> __________________________
>
You can download a ADO example here
http://www.rondebruin.nl/ado.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl
"Richard Buttrey" <[email protected]> wrote in message news:[email protected]...
> Hi,
>
> Is it possible to copy a known range from a workbook that is not open,
> and paste that range into an open workbook?
>
> Usual TIA
>
>
> __
> Richard Buttrey
> Grappenhall, Cheshire, UK
> __________________________
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks