Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to create .csv file
Hi All,
I've a requirement to save selected sheet as .csv file through macro. The macro I designed is able to create new excel file with selected sheet. while saving I'm giving as gwbk.save "C:\Test\test.csv", Format:=XlNormal I'm getting test.csv but I'm not able to open test.csv file to see comma seperated values in note pad. Can any one help meout how to create .csv file which can be opened in notepad? Any help would be appreciated. Note: The macro code should work in excel-2003 & 2007 environment. Advanced Thanks, ~Vins |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to create .csv file
gwbk.SaveAs Filename:= _
"C:\Test\test.csv", FileFormat:=xlCSV Gord Dibben MS Excel MVP On Tue, 21 Jul 2009 14:18:01 -0700, Vinod wrote: Hi All, I've a requirement to save selected sheet as .csv file through macro. The macro I designed is able to create new excel file with selected sheet. while saving I'm giving as gwbk.save "C:\Test\test.csv", Format:=XlNormal I'm getting test.csv but I'm not able to open test.csv file to see comma seperated values in note pad. Can any one help meout how to create .csv file which can be opened in notepad? Any help would be appreciated. Note: The macro code should work in excel-2003 & 2007 environment. Advanced Thanks, ~Vins |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to create .csv file
Thanks Gord Dibben for your response.
Its working for me. "Gord Dibben" wrote: gwbk.SaveAs Filename:= _ "C:\Test\test.csv", FileFormat:=xlCSV Gord Dibben MS Excel MVP On Tue, 21 Jul 2009 14:18:01 -0700, Vinod wrote: Hi All, I've a requirement to save selected sheet as .csv file through macro. The macro I designed is able to create new excel file with selected sheet. while saving I'm giving as gwbk.save "C:\Test\test.csv", Format:=XlNormal I'm getting test.csv but I'm not able to open test.csv file to see comma seperated values in note pad. Can any one help meout how to create .csv file which can be opened in notepad? Any help would be appreciated. Note: The macro code should work in excel-2003 & 2007 environment. Advanced Thanks, ~Vins |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a CSV file? | Excel Discussion (Misc queries) | |||
Code to create dbase file from text file? | Excel Discussion (Misc queries) | |||
Possible to create XL file then run XL VBA (to format & filter XL file) from Access VBA? | Excel Discussion (Misc queries) | |||
Create a single xls file with each import csv file having its own tab | Excel Discussion (Misc queries) | |||
how do i create a help file? | Excel Discussion (Misc queries) |