Hi. I'd like to know how to use a variable in the SAVEAS code so that, dependent on the value of A10, the file will save as either an Excel 2007 file or Excel 2003.
I'm pretty sure the problem is how I use the variables following "FileName:" and "FileFormat:", as shown in bold/underlined below.
Error message: Run-time error '1004': Method 'SaveAs' of object '_Workbook' failedPlease Login or Register to view this content.
The Debug button highlights the whole code between the last End If and End Sub.
Any tips? Thanks.
Bookmarks