Extracting data from a closed Excel Spreadsheet

[Uncle Gizmo]

I've just found this exceptionally useful tip for extracting data from a closed Excel spreadsheet into MS Access! The code shown is actually for Excel, but you should be able to adapt it for use in MS Access. If you need some help with this, then please post a message...

5 More things I wish I Knew When I Started Using Excel VBA​

 

[jdraw]

I find Paul Kelly's tutorials quite helpful

 

[Uncle Gizmo]

I find Paul Kelly's tutorials quite helpful

Very Very Good!

Earlier in the same YouTube HERE:-

5 More things I wish I Knew When I Started Using Excel VBA​

he showed a couple of tricks whilst using the Watch window! There's a couple of things there I didn't know you could do, I generally avoid using the Watch window, but I think seeing this tip, I will be using it more!