View Full Version : save as csv file codepage problem
ermis1975
08-27-2008, 03:27 AM
I try to save as csv, but when I open it with another txt editor like notepad it opens with "chinese" fonts!
Kenneth Hobs
08-27-2008, 09:57 AM
Saving from what version of xls? Most likely, it is still an xls file and not a csv file.
ermis1975
08-27-2008, 11:17 AM
Version 2003. If I use the manual method, without macro, an save as csv, it s ok. In macro its not!
mdmackillop
08-27-2008, 11:37 AM
Please post your code. It's hard to assist without seeing it.
ermis1975
08-27-2008, 10:21 PM
Sheets("Sheet1").Move
ActiveWorkbook.SaveAs Filename:= _
"C:\TEMP\A.CSV"
ActiveWindow.Close
I try also to put filetype xlCSV with the same results
ermis1975
08-28-2008, 11:20 PM
I "fix" the problem, I don;t know how, but inspite of ( ; ) the separete value is (,). What I do wrong ?
shamsam1
08-29-2008, 01:59 AM
ActiveWorkbook.SaveAs Filename:="C:\test_change.csv", FileFormat:=xlCSV
ermis1975
08-29-2008, 03:00 AM
Its ok now but the Separate string is ( , ) and not ( ; ). !
How can I determine the ( ; ) ?
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.