works fine

thks a lot

Ο χÏ�ήστης "Don Guillett" Î*γγÏ�αψε:

use a macro to do it with
application.displayalerts=false

--
Don Guillett
SalesAid Software

"Spiros" wrote in message
...
thks..it works fine but for every csv it asks "do you want to replace the
contetnts of the destination cells" ...and you must press the button
...igf
you have to convert many files its not flexible


? ??????? "Don Guillett" ???????:

datatext to columns

--
Don Guillett
SalesAid Software

"Spiros" wrote in message
...
Hi,

I have created a macro that opens a csv file (seperated by ;) and saves
it
as an Excel file. When i create the macro it works fine but after that
every
time i run it saves the EXCEL file but the fields are not columned (by
;
seperator), but shows as a field (Lastname;Firtsname;Address;Zip;City).

Any suggestion ??

Spiros Moros