I'm at work at the moment ( I work as an Office Integration Developer). I'll take a closer look at this when I get home at about 1:30 PM Central time.
in the mean time, I believe some, if not all of your questions, are or can be answered by looking at the VBA code in the sample workbook I uploaded last night.
Take a look at that and see what you think of it and I'll take another look at this thread when I get home.
Bookmarks