MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Search within closed workbooks

  Asked By: Lu    Date: Jan 04    Category: MS Office    Views: 854

I'm a newbie to VBA so hope this doesn't sound to silly. Is it possible to
search for a word/numbers within closed workbooks? Basically, want to search by
part name within a folder of purchase orders.
I realize this isn't something I could do over night ... willing to put the time
to it, if it's even possible. Any input would be appreciated.



2 Answers Found

Answer #1    Answered By: Arnelle Schmidt     Answered On: Jan 04

Yes, it is possible.


www.erlandsendata.no/english/index.php?t=envbadac (ADO/DAO as
well as Workbook and Folder Names)

All I can not help you with off hand is the actual searching. But as
long as you can search  in an open workbook, I think you can do the same
in a closed  workbook using ADO.

Answer #2    Answered By: Cleopatra Massri     Answered On: Jan 04

thank you for your quick answer and the two websites. Off
I go!

Didn't find what you were looking for? Find more on Search within closed workbooks Or get search suggestion and latest updates.