extract cell content of another excel file

[jflaurin]

Basically I need to acces another Excel file and get the value from cell B2 and copy if into my main Excell file into cell D1

So I'm using the following code to let the user choose the excel file where he'll extract the data from

FileToOpen = Application.GetOpenFilename("Excel (*.xls), *.xls")

This will return the full path of the file I want to extract the data...The part I can't figure oyt is how do I get cell C2 value from FileToOpen and copy it into my main Excel file cell D1 on sheet " Master list". The main excel file is from where I'll run the macro code.

 

[PHV]

Use the Workbooks.Open method

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[jflaurin]

can you give me some code example. I may sound smart but I"m really not !!!