Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can I exclude a heading but show that heading in sheet.
I want to make a spreadsheet(table) which then saved into CSV but in this
table(spreadsheet) there are some headings and I want to exclude those headings please suggest me how can I do it so that my CSV will not have those heading as values.I just want the cells not headings in my CSV. thanks in advance HUNTER |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can I exclude a heading but show that heading in sheet.
I suggest that you record a short macro which deletes the header row(s),
exports the sheet as a CSV file and then restores (undoes the deletion of) the header rows Regards Trevor "HUNTER" wrote in message ... I want to make a spreadsheet(table) which then saved into CSV but in this table(spreadsheet) there are some headings and I want to exclude those headings please suggest me how can I do it so that my CSV will not have those heading as values.I just want the cells not headings in my CSV. thanks in advance HUNTER |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can I exclude a heading but show that heading in sheet.
Another idea...
record a macro when you copy the worksheet to a new workbook. Delete the header rows from that copy. Then save that newly created workbook as .csv and close it without saving Your recorded code should be pretty close to what you need. HUNTER wrote: I want to make a spreadsheet(table) which then saved into CSV but in this table(spreadsheet) there are some headings and I want to exclude those headings please suggest me how can I do it so that my CSV will not have those heading as values.I just want the cells not headings in my CSV. thanks in advance HUNTER -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can I exclude a heading but show that heading in sheet.
Can you have any Idea how to write that micro which will delete the req(header) row and col and transfer the excel sheet to CSV......please let me know if you have any Idea it will be a great help ........and i appreciate you response thanks "Trevor Shuttleworth" wrote: I suggest that you record a short macro which deletes the header row(s), exports the sheet as a CSV file and then restores (undoes the deletion of) the header rows Regards Trevor "HUNTER" wrote in message ... I want to make a spreadsheet(table) which then saved into CSV but in this table(spreadsheet) there are some headings and I want to exclude those headings please suggest me how can I do it so that my CSV will not have those heading as values.I just want the cells not headings in my CSV. thanks in advance HUNTER |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can I exclude a heading but show that heading in sheet.
Can you have any Idea how to write that micro which will delete the
req(header) row and col and transfer the excel sheet to CSV......please let me know if you have any Idea it will be a great help ........and i appreciate you response thanks "Dave Peterson" wrote: Another idea... record a macro when you copy the worksheet to a new workbook. Delete the header rows from that copy. Then save that newly created workbook as .csv and close it without saving Your recorded code should be pretty close to what you need. HUNTER wrote: I want to make a spreadsheet(table) which then saved into CSV but in this table(spreadsheet) there are some headings and I want to exclude those headings please suggest me how can I do it so that my CSV will not have those heading as values.I just want the cells not headings in my CSV. thanks in advance HUNTER -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro | Excel Discussion (Misc queries) | |||
Sum up columns in different sheet with error check | Excel Discussion (Misc queries) | |||
Asked previously...can this not be done in excel | Excel Discussion (Misc queries) | |||
Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
Why can't I show or hide rows in an outline on a protected sheet? | Excel Discussion (Misc queries) |