I am trying out a spreadsheet on a totally different computer. It has a VBA subroutine that is complaining with a compiler error about the Format() function is not found. Yet when I create a brand new spreadsheet and create a VBA subroutine the Format command shows up in the Intellisense and it works when I run it. I am using Excel version 2002. Thanks
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.