Copying a Range from a Workbook without opening in memory.

[Richard Buttrey]

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
__________________________

[Bernie Deitrick]

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
> __________________________

[Tom Ogilvy]

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
> __________________________
>

[Ron de Bruin]

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
> __________________________