MS Excel doesnt like acccent chars

[cantona]

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?

[coopster]

It's mentioned in this hotfix:
[support.microsoft.com...]

[Monkey]

..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]