Thread: Save Csv file
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett
 
Posts: n/a
Default Save Csv file

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