| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need code to save file to new folder, erase from old folder | Excel Discussion (Misc queries) | |||
| Macro Save File (Unique file name) | Excel Worksheet Functions | |||
| Disable Dialogue Box To Save & Replace File | Excel Discussion (Misc queries) | |||
| Macro to save a file as | Excel Discussion (Misc queries) | |||
| How do you disable save file dialog? | Setting up and Configuration of Excel | |||
Linear Mode
