Value & Formula - Export Sheet from xlsx to CSV

[nicluc88]

Hi, I need help to extract a sheet from a xlsx file.
I use:

Workbook.SaveAs FileName:=FileName, FileFormat:=xlCSVUTF8, Local:=True

to extract in a new CSV file (UTF8 encoding).

A filed that in the xlsx contain a formula (calculation of a percentage), in the CSV becomes #REF! .

How can I solve?

Thanks

[nicluc88]

No idea?
Thanks

[nicluc88]

Solved with a

For Each c In shtToExport.Range("A1:B2")
        If c.Value < 1 Then
            c.Value = c.Value * 100