VBA pulling data from other workbooks?
 

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.


--
ph8
------------------------------------------------------------------------
ph8's Profile: http://www.excelforum.com/member.php...o&userid=19871
View this thread: http://www.excelforum.com/showthread...hreadid=516120

VBA pulling data from other workbooks?
 

Hello,

I suggest to look at:
http://www.erlandsendata.no/english/...php?t=envbadac

HTH,
Bernd

VBA pulling data from other workbooks?
 

In addition to using ADO as suggested,

The fastest method is usually to have your code enter the linking formula in
a cell/cells, then get the returned data and clear the formula if
appropriate. There is no built in support in VBA for linking to a closed
workbook. There are methods using xl4macro commands, but these are
generally slower.

Depends on what you are doing and how much information you need to retrieve
and whether the information is organized as a database


--
Regards,
Tom Ogilvy


"ph8" wrote in message
...

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.


--
ph8
------------------------------------------------------------------------
ph8's Profile:
http://www.excelforum.com/member.php...o&userid=19871
View this thread: http://www.excelforum.com/showthread...hreadid=516120