I realize with links in cells its simple to pull data from other workbooks. But what about with VBA? Is it possible?

If so, how?

Furthermore, if so, will the links be relative as well or does vba force you to use absolute references?

Any further info about links in VBA like this is greatly appreciated.