This macro convert an excel file to a CSV. I use polish language which has special characters like ąćęłńóśźż. When I convert to a csv, this characters are replaced by this symbol "?".
In the file attached, special chatacters are in sheet Data Export, to convert them, you need to click on the Data Export in the firt sheet Macro and save the CSV. Open it and you will see all special characters like ąćęłńóśźż are replaced by "?".
Hi,
I googled around the problem and found a possible solution. It may work, or may not. Please contact me via chat, and let's discuss the details. You only need to accept my bid and pay me, if we can work out the solution before.
$10 USD om 0 dag
5,0 (1 omtale)
0,1
0,1
16 frilansere byr i gjennomsnitt $25 USD for denne jobben
Hello. I already modified your xlsm file and it saves csv in correct format now. So if you'll award my bid and create milestone, I'll send the file to you at once and will exlplain what I changed in it
I work with Microsoft Excel for 16 years, using it as a tool for database analysis and business analysis.
I am also an Visual Basic for Applications expert. Before applying for this work I have simulated your problem and tried to think about a turnaround. It worked fine, I could generate an .CSV file with your characters "ąćęłńóśźż".
We can discuss further details and work on examples.
Best Regards.
Hi,
I have faced the same issue with Japanese text, and fixed with a solution, I can share you the same solution immediately the project is awarded. Looking forward for a response.