S
SpeeD72
Hi.
I´ve made a simple macro to save 2 sheets do a txt tab separated. The
problem is that the numbers formated as "currency" (with a euro sign)
end up with a dollar sign in the resulting txt.
Does anyone knows why this is hapenning?
this is my code
Sheets("HOLDI").Select
ActiveWorkbook.SaveAs Filename:= _
ActiveWorkbook.Path & "\..\Dados_holdi.txt" _
, FileFormat:=xlText, CreateBackup:=False
Sheets("EMP").Select
ActiveWorkbook.SaveAs Filename:= _
ActiveWorkbook.Path & "\Dados_emp.txt" _
, FileFormat:=xlText, CreateBackup:=False
ActiveWindow.Close
Thnks a lot
SpeeD
I´ve made a simple macro to save 2 sheets do a txt tab separated. The
problem is that the numbers formated as "currency" (with a euro sign)
end up with a dollar sign in the resulting txt.
Does anyone knows why this is hapenning?
this is my code
Sheets("HOLDI").Select
ActiveWorkbook.SaveAs Filename:= _
ActiveWorkbook.Path & "\..\Dados_holdi.txt" _
, FileFormat:=xlText, CreateBackup:=False
Sheets("EMP").Select
ActiveWorkbook.SaveAs Filename:= _
ActiveWorkbook.Path & "\Dados_emp.txt" _
, FileFormat:=xlText, CreateBackup:=False
ActiveWindow.Close
Thnks a lot
SpeeD