Windows Explorer lets you open archive (tar and tgz) files like any other folder.
In VBA you can easily handle normal files and folders, but opening and indeed creating archive files takes a little more - and that you'll find here.
This article series will show you how to utilise the Next Generation Cryptography (CNG) API from Microsoft for modern hashing and encrypting/decrypting in VBA.
In this part: Handling passwords.