.xlsb macro save as .xlsx corrupts file

[AndrewI]

Filename_3 = Left(Filename_1, Len(Filename_1) - 10) & " UPLOAD VERSION.xlsx"


ActiveWorkbook.SaveCopyAs Filename:=Filename_3

above is a piece of code from a .xlsb file. when i save as xlsx the file is corrupted and cannot be opened.
saving as xls works but i need to make it xlsx

in another workbook i have this code and it works .

Any ideas ?

Dim relativePath As String
Dim pathLength As Long
Dim pathEdit As String
Dim FinalPath As String

    relativePath = ActiveWorkbook.FullName
    pathLength = Len(relativePath)
    pathEdit = Left(relativePath, pathLength - 5)
   ' MsgBox pathEdit
    FinalPath = pathEdit & " " & SelectedView & " " & Format(Now, "yyyy-mm-dd hh-mm") & ".xlsx"
    'MsgBox FinalPath
  
    ActiveWorkbook.SaveAs Filename:=FinalPath

 

[AndrewI]

ok.. so turns out, even though the xls saves and opens via the macro (alerts turned off), when i try to open the file manually i get this error also

any help would be epic. Especially getting the .xlsx save to work.

Thanks

 

[MARK858]

Not tested your code but try adding the bit highlighted below.

ActiveWorkbook.SaveAs Filename:=FinalPath, FileFormat:=51

Edit: Btw where is

& SelectedView &

defined?

 

[AndrewI]

Not tested your code but try adding the bit highlighted below.

ActiveWorkbook.SaveAs Filename:=FinalPath, FileFormat:=51

Edit: Btw where is

& SelectedView &

defined?

that's actually the one that worked.. it was the first piece of code that didn't and i couldn't wok out why because they seem fundamantally the same.

but i tried the fileformat approach and it worked so thank you so much.. really appreciated.

FYI.. selected view was defined in another procedure and passed to this one. it's the value of a dropdown cell.

thanks again for your help

 

[MARK858]

You're welcome. Just for info if you are changing the file type when saving then you need to state the file format .

 

[AndrewI]

You're welcome. Just for info if you are changing the file type when saving then you need to state the file format .

yep.. i know that now ... still learning bit by bit.. getting there though with help from people like you.. thanks mate