Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell Editing Macro
I am looking for a way to edit a cell and put quotation marks around the
contents of that cell using a macro (or some way of automating this). The reason being that this file is being imported into another program and the syntax requires quotation marks around each value. The original file is comma delimited and the contents are both numbers and words. Any help towards a solution is greatly appreciated. thanks Tyler mcleant at hotmail dot com |
#2
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell Editing Macro
Styler,
Try writing the file with the Text Write program at www.tushar-mehta.com. It has an option to put all fields in quotes. -- Regards from Virginia Beach, EarlK ------------------------------------------------------------- "styler" wrote in message .159... I am looking for a way to edit a cell and put quotation marks around the contents of that cell using a macro (or some way of automating this). The reason being that this file is being imported into another program and the syntax requires quotation marks around each value. The original file is comma delimited and the contents are both numbers and words. Any help towards a solution is greatly appreciated. thanks Tyler mcleant at hotmail dot com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro editing | Excel Discussion (Misc queries) | |||
Editing a macro | Excel Discussion (Misc queries) | |||
Editing a macro | Excel Discussion (Misc queries) | |||
Editing Macro | Excel Discussion (Misc queries) | |||
in cell editing macro | Excel Discussion (Misc queries) |