Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to convert .xls to .csv in VB ?
Hi all,
I am new to VBA and Excel stuff. I am trying to convert .xls file to .html. I am successeded in that, but when i am trying to convert another .xls file to .csv the previously generated .csv file gets lost, i..e it is not seen, may be it get replace with new file(though names are different). Is any body getting same problem. I want to save previous .csv file also. Reply soon Thank you sujay |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to convert .xls to .csv in VB ?
sujay wrote: Hi all, I am new to VBA and Excel stuff. I am trying to convert .xls file to .html. I am successeded in that, but when i am trying to convert another .xls file to .csv the previously generated .csv file gets lost, i..e it is not seen, may be it get replace with new file(though names are different). Is any body getting same problem. I want to save previous .csv file also. Reply soon Thank you sujay Hi Suiay, You can use the followinf piece of code in any subroutine you like: ActiveWorkbook.SaveAs Filename:="FileName", FileFormat:= _ xlCSVMSDOS, CreateBackup:=False FileName: is the Complete file path you want to save the CSV in it. hope it works. Hesham Elhadad |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to convert .xls to .csv in VB ?
Hi Hesham Elhadad
Thank you ! but it will work only one time, i.e. if I convert another .xls to .csv, the previously generated .csv file get lost and new file get generated how can i solve this problem. Thank you sujay. wrote: sujay wrote: Hi all, I am new to VBA and Excel stuff. I am trying to convert .xls file to .html. I am successeded in that, but when i am trying to convert another .xls file to .csv the previously generated .csv file gets lost, i..e it is not seen, may be it get replace with new file(though names are different). Is any body getting same problem. I want to save previous .csv file also. Reply soon Thank you sujay Hi Suiay, You can use the followinf piece of code in any subroutine you like: ActiveWorkbook.SaveAs Filename:="FileName", FileFormat:= _ xlCSVMSDOS, CreateBackup:=False FileName: is the Complete file path you want to save the CSV in it. hope it works. Hesham Elhadad |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to convert .xls to .csv in VB ?
sujay wrote:
Hi Hesham Elhadad Thank you ! but it will work only one time, i.e. if I convert another .xls to .csv, the previously generated .csv file get lost and new file get generated how can i solve this problem. Thank you sujay. wrote: sujay wrote: Hi all, I am new to VBA and Excel stuff. I am trying to convert .xls file to .html. I am successeded in that, but when i am trying to convert another .xls file to .csv the previously generated .csv file gets lost, i..e it is not seen, may be it get replace with new file(though names are different). Is any body getting same problem. I want to save previous .csv file also. Reply soon Thank you sujay Hi Suiay, You can use the followinf piece of code in any subroutine you like: ActiveWorkbook.SaveAs Filename:="FileName", FileFormat:= _ xlCSVMSDOS, CreateBackup:=False FileName: is the Complete file path you want to save the CSV in it. hope it works. Hesham Elhadad If you are using the same file name ...it should do what you said... However, if you use another file name it will be another file and keep both of them the following code may help and you can change to customize your needs: DestFile = InputBox(Filename) ActiveWorkbook.SaveAs Filename:=DestFile, FileFormat:= _ xlCSVMSDOS, CreateBackup:=False the DestFile is the complete Path and File name you want to save ... it will save it and keep the old one as it is a new file... Regards, Hesham Elhadad |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to convert .xls to .csv? | Excel Discussion (Misc queries) | |||
HOW DO I CONVERT .CSV FILE TO .XLS? | Excel Discussion (Misc queries) | |||
convert from .xls format to .csv format | Excel Discussion (Misc queries) | |||
Convert .csv files | Excel Discussion (Misc queries) | |||
When converting an .xls file to .csv I get too many commas at the. | Excel Discussion (Misc queries) |