excel automation to search multiple spreadsheets

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top