Dear All,
I found a sample of excel spreadsheet on internet contain a VBA to create a KML file and generate google earth , this VBA works fine , but pop-up balloons on google earth show me just the English Language as it but the Arabic Language Letters shown as unknown font , please how can edit VBA to let pop-up balloons show me the Arabic Language Names in Arabic Language or other Language ?
please see attached file
Best Regards
Hello Hassan
It seems you forgot to attach your file ...
Have you examined Regional Settings from Control Panel and make sure you have chosen Arabic?
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
Dear Yasser, sorry for late ,please see attached file .
I checked the Region from control panel , it is on my country .
Best Regards
dear all , I found the solution but I couldn't type it in the VBA code , the solution is to open the KML file with Notepad and save as ... the Encoding must be utf-8 .
so how can I edit the code in the attached file to add Encoding utf-8 to let google earth read the Arabic language , any help ?
Best Regards
dear all , I need a help to Re-type the code in the attached file to save the Encoding in utf-8 to let pop-up place mark in google earth read Arabic language .
Best Regards
dear Forum Expert , can you help me ?
You can use this CreateTextFile method
Check attached file with the updated code.
Please Login or Register to view this content.
ExportToGoogleEarth test1.xlsm
Hope this helps!
Happy to Help
How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html
"I don't get things easily, so please be precise and elaborate"
If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.
Sourabh
I forgot to remove the "STOP" statement while debugging. You can remove it yourself. Check attached.
ExportToGoogleEarth test1.xlsm
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks