find in closed workbook

M

marko

I understand it is possible to get a cells data from a closed workbook via a
XLM macro if you know the location already, but is it possible to do more
advanced things like find a string and return the row its in? Or anything
else?

Thanks
Mark
 

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

Similar Threads

Cell data entering slow! 0
Conditional formatting within macro? 3
Ignoring a runtime error 1
Markup status / dashboard 0
Word VBA - Want to test if Full Name is NOT Present in document 0
closing another file by code causes failure to run workbook activate event 2
ASK Field Formatting 1
save worksheet data to alternate closed workbook - next row 1

Top