Worksheet1 and Worksheet2 are tables. I created a relationship between the two tables. I need to populate a column in Worksheet2 with data from Worksheet1 based on the relationship. See attached file for illustration. Capture.PNG
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc.
In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
Windows Explorer lets you open cabinet (cab) files like any other folder.
In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.