Read our blogs, tips and tutorials
Try our exercises or test your skills
Watch our tutorial videos or shorts
Take a self-paced course
Read our recent newsletters
License our courseware
Book expert consultancy
Buy our publications
Get help in using our site
547 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owl trainers only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
Search our website
We also send out useful tips in a monthly email newsletter ...
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
Kingsmoor House
Railway Street
GLOSSOP
SK13 2AA
Landmark Offices
99 Bishopsgate
LONDON
EC2M 3XD
Holiday Inn
25 Aytoun Street
MANCHESTER
M1 3AE
© Wise Owl Business Solutions Ltd 2024. All Rights Reserved.