Re: quotation marks before and after each input
From: Tom Ogilvy (twogilvy_at_msn.com)
Date: 02/24/04
- Next message: Tom Ogilvy: "Re: Clearing cells that only contain spaces"
- Previous message: BrianG: "Disable File-Save menu item in macro?"
- In reply to: iamalex: "quotation marks before and after each input"
- Next in thread: JE McGimpsey: "Re: quotation marks before and after each input"
- Reply: JE McGimpsey: "Re: quotation marks before and after each input"
- Reply: iamalex: "Re: quotation marks before and after each input"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 24 Feb 2004 16:42:37 -0500
do low level file io and use the write method.
>From help on write:
Unlike the Print # statement, the Write # statement inserts commas between
items and quotation marks around strings as they are written to the file.
http://support.microsoft.com/support/excel/content/fileio/fileio.asp
File Access with Visual Basic® for Applications
-- Regards, Tom Ogilvy "iamalex >" <<iamalex.125gj1@excelforum-nospam.com> wrote in message news:iamalex.125gj1@excelforum-nospam.com... > I have an excel document with about 6 columns and various > rows under each column. > I need to change it to csv comma delimited, which is no problem, but I > need to add quotations around each and every item for final text > output. > > any help would be appreciated. > > alex > > > --- > Message posted from http://www.ExcelForum.com/ >
- Next message: Tom Ogilvy: "Re: Clearing cells that only contain spaces"
- Previous message: BrianG: "Disable File-Save menu item in macro?"
- In reply to: iamalex: "quotation marks before and after each input"
- Next in thread: JE McGimpsey: "Re: quotation marks before and after each input"
- Reply: JE McGimpsey: "Re: quotation marks before and after each input"
- Reply: iamalex: "Re: quotation marks before and after each input"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
