PDA

View Full Version : [SOLVED] Value & Formula - Export Sheet from xlsx to CSV



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

nicluc88
05-17-2018, 06:08 AM
No idea?
Thanks

nicluc88
05-21-2018, 03:11 AM
Solved with a

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