Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro editing Skeeter Excel Discussion (Misc queries) 5 August 6th 07 01:40 AM
Editing a macro pm Excel Discussion (Misc queries) 5 June 6th 07 11:33 PM
Editing a macro Dtmos01 Excel Discussion (Misc queries) 6 April 3rd 07 06:36 PM
Editing Macro heitorfjr Excel Discussion (Misc queries) 1 January 15th 06 07:02 PM
in cell editing macro ynissel Excel Discussion (Misc queries) 2 July 27th 05 07:28 PM


All times are GMT +1. The time now is 01:35 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"