Welcome to WebmasterWorld Guest from 3.84.130.252

Forum Moderators: phranque

Message Too Old, No Replies

MS Excel doesnt like acccent chars

     
4:11 pm on Feb 13, 2009 (gmt 0)

Junior Member

10+ Year Member

joined:June 17, 2008
posts: 47
votes: 0


Hello

I am downloading some data in CSV format from my website. Some of the data is in French and has a few accent characters.

When I open the CSV document in Notepad or FireFox, the accent characters display properly. But when I "open" the file with MS Excel, the accent characters break.

I've found that if I "import" the file, I can change the 'file origin' and set this to 'unicode (utf-8)', it works.

But why doesn't it work when I first open it? I don't want to go through the import process every time....

Any ideas?

7:46 pm on Feb 13, 2009 (gmt 0)

Administrator

WebmasterWorld Administrator coopster is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:July 31, 2003
posts:12548
votes: 2


It's mentioned in this hotfix:
[support.microsoft.com...]
9:30 pm on Feb 14, 2009 (gmt 0)

Junior Member

10+ Year Member

joined:June 8, 2007
posts:76
votes: 0


..and if that doesn't fix it, then record the code to use the Import Text Wizard. Add the code snippet I've created for you after the Sub line and then find the place for your filename and replace with strFileName


Dim strFileName As String
Dim dlgFileOpen As FileDialog


Set dlgFileOpen = Application.FileDialog(msoFileDialogOpen)
dlgFileOpen.Show

strFileName = dlgFileOpen.SelectedItems(1)

[edited by: Monkey at 9:31 pm (utc) on Feb. 14, 2009]

 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members