excel automation - search spreadsheets from access vba

  • Thread starter Thread starter KM
  • Start date Start date
K

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?
 
Back
Top