Hi Tom,

Thanks again for your advice. That's exactly what I did. I removed the
extra statements that referred to userforms and worksheets, and it worked.

After some trial and error, I ended up putting some hidden textboxes in my
userform, that included the information I needed to add to the file name.
Then after clicking on the 'Snapshot' commandbutton, it dumped that data into
the workbook added, and from there the code to write the file name worked.

Thank you.