Thank you, Greg. Since this can be used by others, is there a way to open a Save As dialog box to prompt users to save to a directory of their choice? encountered a permissions error while trying to save to my root C: drive.
... or just create the file and open it immediately. Saving/opening in an Excel file would be ideal.