VBA Pull Data In from another workbook without opening that workbook

[CarolynS]

Hi

I'm trying to find some code that will pull data from one workbook to another without having to open the source data workbook. Currently, when my workbook "MTCR Tool" opens it asks if you would like to update the mapping data. If i click yes, I would like the mappings data to then be pulled in from the "Mappings" workbook. I know how to write the code to open the mappings workbook, copy and paste the data in to the MTCR Tool workbook and then close the mappings workbook but I remember hearing a while back that there is a way to do this without ever opening the mappings workbook? The mappings data I want to pull across is in columns A,C,D,E,F of the mappings workbook but the number of rows could vary.

I did find some code in another thread but it was using absolute references. I'm not sure how to handle the fact that I don't want to copy column B over and my row numbers may change?

Thanks

 

[Gingertrees]

Everything I've ever read about this topic, as well as everything I've done similar, says that it's far, far easier to code open the foreign workbook, copy in needed things, close foreign workbook save:=false. You can even speed it up by turning off screenupdating and turning calculation to manual before you open/copy things (remember to reset scrnupdtg and calc at the end!).