Welcome to WebmasterWorld Guest from 184.108.40.206
Forum Moderators: phranque
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....
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]