WiseOwl Training - Established 1992 Wise Owl Training

Established May 1992
30 years in business
Wise Owl Training
30 years in business
See 527 reviews for our classroom and online training

Details for SIH007

SIH007 has participated in the following threads:

Added by SIH007 on 24 Apr 2021 at 16:06

How do I get data from a closed Excel file using VBA?


Hi Andrew,

I really love your videos they always have so much information in it!

I just finished watching a. m. video. My problem is the following: I have to grab data from a closed Excel-file, but the data table I need unfortunately is not positioned in row 1 - there has to remain some descriptive stuff above the very table, so I could of course grab the entire table and delete all rows which don*t belong to the datatable. 

But actually I would only need a very small portion of the data, here I would only need column 3 and 4 of the datatable and only values which are bigger than a number on another sheet. I work a lot with SQL statements so it would not be a problem at all to create the statement I need, but I can't address the column names, because they are not in the first row (I would not even need the headers)

Is there a possibility to address the data using a named range instead? Or do you have another idea how to solve that problem?

Best regards,

Susanne