Welcome to WebmasterWorld Guest from

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


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)


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

joined:July 31, 2003
votes: 2

It's mentioned in this hotfix:
9:30 pm on Feb 14, 2009 (gmt 0)

Junior Member

10+ Year Member

joined:June 8, 2007
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)

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