Re: Pull values from each .xls file in dir

Giganews Newsgroups
Subject: Re: Pull values from each .xls file in dir
Posted by:  Duke17 (Duke17.28hp8a_1148772900.8036@excelforum-nospam.com)
Date: Sat, 27 May 2006

Jim, thanks for directing me to that link, it's been very helpful.
There's one thing I'm having trouble with, though.  I need to "set a
reference to the Microsoft ActiveX Data Objects 2.5 library in the VBA
editor."  I'm not sure how to do this...can you please help?

Thanks!

--
Duke17
------------------------------------------------------------------------
Duke17's Profile:http://www.excelforum.com/member.php?action=getinfo&userid=8361
View this thread:http://www.excelforum.com/showthread.php?threadid=546205

Replies

In response to

Pull values from each .xls file in dir posted by Duke17 on Sat, 27 May 2006