ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Cell Editing Macro (https://www.excelbanter.com/excel-programming/273223-cell-editing-macro.html)

styler

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

EarlK

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





All times are GMT +1. The time now is 03:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com