software

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

datagt;text to columns

--
Don Guillett
SalesAid Software

quot;Spirosquot; gt; wrote in message
...
gt; Hi,
gt;
gt; I have created a macro that opens a csv file (seperated by and saves it
gt; as an Excel file. When i create the macro it works fine but after that
gt; every
gt; time i run it saves the EXCEL file but the fields are not columned (by ;
gt; seperator), but shows as a field (Lastname;Firtsname;Address;Zip;City).
gt;
gt; Any suggestion ??
gt;
gt; Spiros Moros
thks..it works fine but for every csv it asks quot;do you want to replace the
contetnts of the destination cellsquot; ...and you must press the button ...igf
you have to convert many files its not flexible? ??峸??庢? quot;Don Guillettquot; ?帠帠?帢?庰:

gt; datagt;text to columns
gt;
gt; --
gt; Don Guillett
gt; SalesAid Software
gt;
gt; quot;Spirosquot; gt; wrote in message
gt; ...
gt; gt; Hi,
gt; gt;
gt; gt; I have created a macro that opens a csv file (seperated by and saves it
gt; gt; as an Excel file. When i create the macro it works fine but after that
gt; gt; every
gt; gt; time i run it saves the EXCEL file but the fields are not columned (by ;
gt; gt; seperator), but shows as a field (Lastname;Firtsname;Address;Zip;City).
gt; gt;
gt; gt; Any suggestion ??
gt; gt;
gt; gt; Spiros Moros
gt;
gt;
gt;

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

--
Don Guillett
SalesAid Software

quot;Spirosquot; gt; wrote in message
...
gt; thks..it works fine but for every csv it asks quot;do you want to replace the
gt; contetnts of the destination cellsquot; ...and you must press the button
gt; ...igf
gt; you have to convert many files its not flexible
gt;
gt;
gt; ? ??????? quot;Don Guillettquot; ???????:
gt;
gt;gt; datagt;text to columns
gt;gt;
gt;gt; --
gt;gt; Don Guillett
gt;gt; SalesAid Software
gt;gt;
gt;gt; quot;Spirosquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Hi,
gt;gt; gt;
gt;gt; gt; I have created a macro that opens a csv file (seperated by and saves
gt;gt; gt; it
gt;gt; gt; as an Excel file. When i create the macro it works fine but after that
gt;gt; gt; every
gt;gt; gt; time i run it saves the EXCEL file but the fields are not columned (by
gt;gt; gt; ;
gt;gt; gt; seperator), but shows as a field (Lastname;Firtsname;Address;Zip;City).
gt;gt; gt;
gt;gt; gt; Any suggestion ??
gt;gt; gt;
gt;gt; gt; Spiros Moros
gt;gt;
gt;gt;
gt;gt;
works fine

thks a lot

? ??峸??庢? quot;Don Guillettquot; ?帠帠?帢?庰:

gt; use a macro to do it with
gt; application.displayalerts=false
gt;
gt; --
gt; Don Guillett
gt; SalesAid Software
gt;
gt; quot;Spirosquot; gt; wrote in message
gt; ...
gt; gt; thks..it works fine but for every csv it asks quot;do you want to replace the
gt; gt; contetnts of the destination cellsquot; ...and you must press the button
gt; gt; ...igf
gt; gt; you have to convert many files its not flexible
gt; gt;
gt; gt;
gt; gt; ? ??????? quot;Don Guillettquot; ???????:
gt; gt;
gt; gt;gt; datagt;text to columns
gt; gt;gt;
gt; gt;gt; --
gt; gt;gt; Don Guillett
gt; gt;gt; SalesAid Software
gt; gt;gt;
gt; gt;gt; quot;Spirosquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt; Hi,
gt; gt;gt; gt;
gt; gt;gt; gt; I have created a macro that opens a csv file (seperated by and saves
gt; gt;gt; gt; it
gt; gt;gt; gt; as an Excel file. When i create the macro it works fine but after that
gt; gt;gt; gt; every
gt; gt;gt; gt; time i run it saves the EXCEL file but the fields are not columned (by
gt; gt;gt; gt; ;
gt; gt;gt; gt; seperator), but shows as a field (Lastname;Firtsname;Address;Zip;City).
gt; gt;gt; gt;
gt; gt;gt; gt; Any suggestion ??
gt; gt;gt; gt;
gt; gt;gt; gt; Spiros Moros
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;

glad to help

--
Don Guillett
SalesAid Software

quot;Spirosquot; gt; wrote in message
...
gt; works fine
gt;
gt; thks a lot
gt;
gt; ? ??????? quot;Don Guillettquot; ???????:
gt;
gt;gt; use a macro to do it with
gt;gt; application.displayalerts=false
gt;gt;
gt;gt; --
gt;gt; Don Guillett
gt;gt; SalesAid Software
gt;gt;
gt;gt; quot;Spirosquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; thks..it works fine but for every csv it asks quot;do you want to replace
gt;gt; gt; the
gt;gt; gt; contetnts of the destination cellsquot; ...and you must press the button
gt;gt; gt; ...igf
gt;gt; gt; you have to convert many files its not flexible
gt;gt; gt;
gt;gt; gt;
gt;gt; gt; ? ??????? quot;Don Guillettquot; ???????:
gt;gt; gt;
gt;gt; gt;gt; datagt;text to columns
gt;gt; gt;gt;
gt;gt; gt;gt; --
gt;gt; gt;gt; Don Guillett
gt;gt; gt;gt; SalesAid Software
gt;gt; gt;gt;
gt;gt; gt;gt; quot;Spirosquot; gt; wrote in message
gt;gt; gt;gt; ...
gt;gt; gt;gt; gt; Hi,
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; I have created a macro that opens a csv file (seperated by and
gt;gt; gt;gt; gt; saves
gt;gt; gt;gt; gt; it
gt;gt; gt;gt; gt; as an Excel file. When i create the macro it works fine but after
gt;gt; gt;gt; gt; that
gt;gt; gt;gt; gt; every
gt;gt; gt;gt; gt; time i run it saves the EXCEL file but the fields are not columned
gt;gt; gt;gt; gt; (by
gt;gt; gt;gt; gt; ;
gt;gt; gt;gt; gt; seperator), but shows as a field
gt;gt; gt;gt; gt; (Lastname;Firtsname;Address;Zip;City).
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; Any suggestion ??
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; Spiros Moros
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt;
gt;gt;
gt;gt;