I have several workbooks that I run simple formatting macros on. In one of the final macros, I'd like to add code that converts the file to a shared workbook. Is this possible? Any help would be appreciated. Thanks.
P.S. I've tried searching for my answer in the knowledgebase, but wasn't able to find something general enough to be my solution.
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.
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code.