Save Csv file
 

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

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

Save Csv file
 

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

Save Csv file
 

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

Save Csv file
 

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

Save Csv file
 

glad to help

--
Don Guillett
SalesAid Software

"Spiros" wrote in message
...
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