Showing information from an excel document to another excel docume

[Patboy]

Hi,

My question is, I have 2 excel documents (excel1.xls & excel2.xls for
example) is there a way to display information like a cell or a whole sheet
from excel1.xls to excel2.xls?

 

[CLR]

Maybe..........

='c:\my Documents\[Excel1.xls]Sheet1'!A1

Modify as necessary to fit your conditions......

Vaya con Dios,
Chuck, CABGx3

 

[Patboy]

Hi, thanks for your response, it's working for a cell.

is there a way to make it work for an entire sheet?

thanks

Maybe..........

='c:\my Documents\[Excel1.xls]Sheet1'!A1

Modify as necessary to fit your conditions......

Vaya con Dios,
Chuck, CABGx3

Hi,

My question is, I have 2 excel documents (excel1.xls & excel2.xls for
example) is there a way to display information like a cell or a whole sheet
from excel1.xls to excel2.xls?

 

[CLR]

Not that I know of, other than to just copy and paste it to cover the range
of interest...........

Of course one can use VBA to open the file and copy the sheet out to the
activebook

Vaya con Dios,
Chuck, CABGx3

Hi, thanks for your response, it's working for a cell.

is there a way to make it work for an entire sheet?

thanks

Maybe..........

='c:\my Documents\[Excel1.xls]Sheet1'!A1

Modify as necessary to fit your conditions......

Vaya con Dios,
Chuck, CABGx3

Hi,

My question is, I have 2 excel documents (excel1.xls & excel2.xls for
example) is there a way to display information like a cell or a whole sheet
from excel1.xls to excel2.xls?