excel automation - search spreadsheets from access vba

[KM]

From MS Access front end, user chooses a directory and enters a
string
into a text box. I need assistance to search all excel spreadhseets
in that directory for that string and return cell and spreadsheet
name
of all instances. Can someone put me in the right directrion to
accomplish the searching of Excel from Acccess VBA?

 

[Shane Devenshire]

First this is an Access programming question. Second what do you mean by
return cell name?

Try posting to here:

http://www.microsoft.com/communitie...1ff-3362-4822-afac-4b579bc9d69d&lang=en&cr=US