Hi again.
I'm trying to open a csv file with a simple macro (which is just gonna
help someone, like a step by step), but my problem is that when I use
- Dim x As Variant
x = Application.GetOpenFilename("Fichiers CSV (*.csv), *.csv")
Workbooks.Open Filename:=x-
(which is msdn code), I will open the CSV as a text file, showing in A1
all my cells separated by semicolumns, instead of opening it as a really
comma-separated values in different cells!
Any idea how to solve that?
Thanks
--
lonfnico
------------------------------------------------------------------------
lonfnico's Profile:
http://www.excelforum.com/member.php...o&userid=33396
View this thread:
http://www.excelforum.com/showthread...hreadid=532572