The site formerly known as Code For Excel and Outlook
July 1, 2009 by · 
In my previous post titled List matching files in a directory, I posted a method that creates a string array of filenames in a folder that match a given file extension. Here we are going to put that code to some real use.
Continue Reading: List matching files in a folder, part two »
June 11, 2009 by · Problem: You need an easy way to backup an important file on a regular basis. Copying and pasting the file to another folder (with Windows Explorer or some other folder browsing tool), or saving it twice (once to its current folder, and again to a backup folder) is tedious, and still requires you to manually indicate file version.
Solution: Use this Excel VBA procedure. It can be used to backup any single file to a folder of your choice, appending a timestamp to the filename for easy rollback and version management.
Continue Reading: A VBA-Based Backup Solution »
Site last updated: February 9, 2012
Follow Me