nicluc88
05-14-2018, 09:07 AM
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
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