Macro to get value from a file

[JoeNK]

Hey guys,
If for example in cell A1 I have a link hard-coded in,
C:\sales\2011 Budget\January.xls
In Cell B1 i need the value of a certain cell in that file

Is there a macro that would go find that file and look for a specified worsheet and give me the value in a specified cell ?

Thanks

[g8r777]

Quick and dirty but something like this should work:

Please Login or Register  to view this content.

You can modify the references to the sheets and cells to return the value from the correct cell in wb2 to whatever cell you want in wb1.

Also keep in mind that the reference to the other file is exact. For example I was initally having a problem with this code because my workbook was January.xlsx and not January.xls. Be mindful of the file name extension based on what version of Excel you are using.

[JoeNK]

Sweet, it worked
Thanks for the quick reply

[g8r777]

Glad to help.

Please mark this thread as SOLVED by going to Thread Tools -> Mark this thread as solved