I think it may hve to do with the save as part, maybe just save as .xlsx instead of " FileFormat:=xlOpenXMLWorkbook" (not sure what the syntax would be off the top of my head as im replying from my phone right now, i cant look it up efficiently) you could try "FileFormat:=*.xlsx"
Bookmarks