Xld helped me with an issue that deals with the file format and syntax variances between Excel 2007 and earlier versions.

I created a workbook in Excel 2003 for distribution within our organization. Only about 10% of the agency at this point has migrated to Office 2007. The workbook creates a duplicate of itself and I wanted that duplicate to save in the Excel file format resident on the user's machine.

When the portion of code was added to accommodate the save routine for Excel 2007, it was not recognized by Excel 2003 and was then treated as an undeclared variable.

The solution is found at:

http://vbaexpress.com/forum/showthread.php?t=20220

Ron