VBA Error 6 unknown cause

[amineact]

Hello There, I'm sort of a newbie to VBA. I'm trying to set up a macro thatv will enable me to export a whole workbook each tilme i change the parameters;
For some time, the code was working fine but nom it's giving me Error 6, which i dont know the cause.
I would very much appreciate the help.
Here's the code.

Sub MySave23()

    Dim ws As Worksheet
    
'   Look through each sheet and hard-code formulas
    For Each ws In ActiveWorkbook.Worksheets
        ws.Activate
        ActiveSheet.UsedRange.Value = ActiveSheet.UsedRange.Value
    Next ws
    
'   Save workbook
    Application.DisplayAlerts = False
    ActiveWorkbook.SaveAs ActiveWorkbook.Path & "\Filename_" & Format(Date, "dd-mmm-yy") & ".xlsb", xlExcel12
    Application.DisplayAlerts = True
    
End Sub

 

[northwolves]

Your codes seems no problem. Have you some data in some sheet with too long strings or too large numbers?

 

[amineact]

Your codes seems no problem. Have you some data in some sheet with too long strings or too large numbers?

I would say so as it is a year end accouting report.

 

[amineact]

Your codes seems no problem. Have you some data in some sheet with too long strings or too large numbers?

hey there
sorry for the late reply, your answer was right as i had too much large account numbers and vba was treating them as integer while in fact they should be treated as Long type
Thanks for the help