Hi all,
I have the following code but it's errors (1004), stating an invalid extension. I'm trying to save the Active Workbook in a different location as a XLSX file. Any ideas?
![]()
Dim myFileName$ myFileName = ThisWorkbook.Name ActiveWorkbook.SaveAs "C:\Users\MyName\Desktop\Replicated\" & myFileName, FileFormat:=51 ActiveWorkbook.Save
Bookmarks