Excel Create or Remove a Table with VBA

There are times in Excel when you may wish to create a table on the fly with the assistance of VBA code.  I was in this position recently and needed to this with VBA.  A file was uploaded into a sheet and the task was to create a table and then use that table for more data manipulation.  The following Excel VBA procedure was what I ended up with.

Read More

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.

Ron De Bruin Zipping

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 More