Excel icon

Check a file's last modification time

Ray writes and asks how we can check if a file's modification date is over a certain period of time, and act accordingly.

He has a procedure that prompts the end user for a folder to save some workbooks. Problem is, if the wrong folder is selected, a worm hole will open and the Earth will be destroyed. I kid.

Continue Reading: Check a file's last modification time »

Outlook iconVBA icon

Attach files in a folder to one email

So you want to send a bunch of attachments to someone. Well, here's a technique you might use. This VBA code sample attaches all the files in a folder to a single email. You can specify the type of file you want to attach, or just leave the parameter blank and it will attach all files in the folder.

Continue Reading: Attach files in a folder to one email »

Site last updated: February 8, 2012