View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Duke17
 
Posts: n/a
Default Pull values from each .xls file in dir


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...fo&userid=8361
View this thread: http://www.excelforum.com/showthread...hreadid=546205