Excel VBA Send Files to Zip Drive
Zipping up Excel files on the fly can be a most useful activity especially if working with outlook. You may wish to generate a set of files with Excel VBA then zip those files and send them on to a list of people for review or as part of a monthly reporting procedure. I have seen plenty of these type of procedures. The most famous of which is on Ron De Bruin's site.
The idea behind the concept is to have a file path with files inside it. The zip procedure runs and sends all of the files to a compressed zip file and saves the file in a designated folder.
Read MoreExcel Import Data from Multiple Cells
Recently a client asked me if I could create an Excel VBA procedure which picked up data from a file but the data came from multiple sheets and multiple cells in non sequential locations. Firstly, I thought the best method to do this would be to have a summary sheet which is hidden and simply pick this sheet up and consolidate it in the parent workbook. However the problem was the files had already gone out and over 200 Excel files needed to be consolidated into a single workbook.
Read MoreFeatured Posts
Recent Posts
Split File into Parts and Save to Directory April 20, 2024
Most Popular Author December 14, 2023
Creating an Excel Dashboard - A Guide with Templates December 8, 2023
Real Estate Excel Dashboard October 11, 2023
Updating Excel Dashboards September 29, 2023
TheSmallman in Another Top Blog Rank April 24, 2023
Project Tracking Dashboard March 25, 2023
Excel Unique Formula September 17, 2022
Horizontal Range to Vertical Range in Excel June 15, 2022
Hiding Rows Quickly with VBA May 20, 2022