Is transfer data from one Excel file to another possible?

[Guest]

I have a named range in my ‘FileA.xls’ file that references an array of data.
But say if I’m working in ‘FileB.xls’ and ‘FileA.xls’ is closed, is there
any way in VB to call out and import the named range from ‘FileA.xls’ into
‘FileB.xls’?

 

[Guest]

Hi EA

See if the information at http://www.beyondtechnology.com/geeks023.shtml
is helpful.

Jim P

 

[Guest]

It seems as thought I'm almost there, but for some reason VB is not taking
this line:

Private Sub GetData ("C:\Documents and Settings\Admin\Desktop\My File.xls",
"Data", "Data_Range", Sheet1.Cells(1, 3), True)

Do I have something wrong here? Thank you so much!!!