VBA Read Excel File

Here is a question I received

“Thanks for the video, I have a question.How to read from a group of closed excel files searching for a certain value in say column F then if that value is found then copy that row to a workbook and continue search for then next value ”

So I thought about it and answered in word and a video example:

“You could query the closed Excel file with SQL,
or you could do what I demonstrate in this video…”

Click here for the file:
VBA Read Excel File.zip

For more Excel related posts, take a look at our sister site, http://www.vbastring.com

Free! Subscribe To Our YouTube Channel!

facebooktwittergoogle_plusredditpinterestlinkedinmailby feather
Tags: , , , , ,




 

Call Erik Now