Save Csv file

S

Spiros

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
 
S

Spiros

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" έγγÏαψε:
 
S

Spiros

works fine

thks a lot

Ο χÏήστης "Don Guillett" έγγÏαψε:
 
Top