Extracting data from a closed Excel Spreadsheet (1 Viewer)

Uncle Gizmo

Nifty Access Guy
Staff member
Local time
Today, 18:47
Joined
Jul 9, 2003
Messages
16,244
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

Super Moderator
Staff member
Local time
Today, 14:47
Joined
Jan 23, 2006
Messages
15,364
I find Paul Kelly's tutorials quite helpful (y)
 

Uncle Gizmo

Nifty Access Guy
Staff member
Local time
Today, 18:47
Joined
Jul 9, 2003
Messages
16,244
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!
 

Users who are viewing this thread

Top Bottom