![]() Without the “.xls” bit, it always reverts to saving as an. I’ve tried replacing the FileFormatNum with -4143, and 52, and without the FileFormatType, but none of them make any difference. Then further down when it’s created the new workbookĪctiveWorkbook.SaveAs Filename:=Range("u1") & Range("u2").Value & sheetName & ".xls" For some users this is fine, but again for earlier users, the file corrupts.įileExtStr = ".xls": FileFormatNum = 56: FileFormatType = "xlExcel8" ![]() I’ve tried adding “.xls” to the end of the file name, but then it comes up with the error ‘the file format is different to the file extension’. ![]() What I’d like, is to save the files as 97-2003 xls, so everyone can open them, but no matter what I’ve tried (so far) in the fileformat, it saves as xlsx, which the people with earlier versions of Excel don’t seem to be able to open. The problem I’ve got, is that the companies that we’re sending to all have different versions of Excel, and we’re getting errors coming back each time as to being able to open the file, or the file being corrupted. I’ve got a file which from a macro sorts the data then splits it into sections, then creates a new workbook for each section, renames the tabs and and saves the new files as the tab name, for us to email out to different companies.
0 Comments
Leave a Reply. |