Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert Excel into a CSV file automatically
Could someone let me know how it is possible to programm the automatic
convertion of an excel file into a CSV file ? That would be great Thanks Serge |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert Excel into a CSV file automatically
For an elegant solution, see Walkenbach's Excel Power Programming with VBA
book. It discusses how to create a whole CSV Class. For a quick and dirty solution, try something like: ActiveWorkbook.SaveAs Filename:= NAME, FileFormat:= xlCSVMSDOS "serge" wrote: Could someone let me know how it is possible to programm the automatic convertion of an excel file into a CSV file ? That would be great Thanks Serge |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert Excel into a CSV file automatically
Thanks for the quick reply.
I am not familiar with VBA for the moment. Where do I have to write your code ? Into VBA directly ? I know that this is a very stupid question and I apologize in advance :-) Thanks for your help Serge "Jared" wrote: For an elegant solution, see Walkenbach's Excel Power Programming with VBA book. It discusses how to create a whole CSV Class. For a quick and dirty solution, try something like: ActiveWorkbook.SaveAs Filename:= NAME, FileFormat:= xlCSVMSDOS "serge" wrote: Could someone let me know how it is possible to programm the automatic convertion of an excel file into a CSV file ? That would be great Thanks Serge |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert Excel into a CSV file automatically
Why can't you go to the menu and do
file=SaveAS and in the file type dropdown, select CSV. -- Regards, Tom Ogilvy "Jared" wrote in message ... For an elegant solution, see Walkenbach's Excel Power Programming with VBA book. It discusses how to create a whole CSV Class. For a quick and dirty solution, try something like: ActiveWorkbook.SaveAs Filename:= NAME, FileFormat:= xlCSVMSDOS "serge" wrote: Could someone let me know how it is possible to programm the automatic convertion of an excel file into a CSV file ? That would be great Thanks Serge |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert Excel into a CSV file automatically
Serge:
If Tom's solution is not acceptable I would suggest that you invest in a good book covering VBA or get a personal introduction from an experienced user. With that being said. Hit Alt+F11 to lauch the VBE, insert a module, and type your code into the module. It will most likely take a lot of tinkering and time spent reading the help topics for you to become proficient in VBA. "serge" wrote: Thanks for the quick reply. I am not familiar with VBA for the moment. Where do I have to write your code ? Into VBA directly ? I know that this is a very stupid question and I apologize in advance :-) Thanks for your help Serge "Jared" wrote: For an elegant solution, see Walkenbach's Excel Power Programming with VBA book. It discusses how to create a whole CSV Class. For a quick and dirty solution, try something like: ActiveWorkbook.SaveAs Filename:= NAME, FileFormat:= xlCSVMSDOS "serge" wrote: Could someone let me know how it is possible to programm the automatic convertion of an excel file into a CSV file ? That would be great Thanks Serge |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I set up Excel 97 to automatically convert/open .csv files | Setting up and Configuration of Excel | |||
How to convert resluts automatically to values in Excel | Excel Discussion (Misc queries) | |||
How to stop Excel convert (c) to © automatically? | Excel Discussion (Misc queries) | |||
how to automatically convert a number to words in Excel | Excel Worksheet Functions | |||
Set Excel to not automatically convert text to date | Excel Programming |