csv & " (re-post)
 

Still having trouble with this. Links refered to in replies from the
original post were not available, and I can't seem to reply to continue the
original posting.

I have text which includes " <inch marks. When I saveas csv, and open with
notepad there are additional " added to the text. If I re-op in excell I do
not see the additional ". For instance, a cell with < 6" shows in csv
opened with notepad as < "6""" . same csv re-opened in excel still shows
original format < 6" .

Any way to NOT get additional quotes to show when opening in Notepad?



--
Posted via a free Usenet account from http://www.teranews.com

csv & " (re-post)
 

The site is back up now.

Mike Kiekover wrote:

Still having trouble with this. Links refered to in replies from the
original post were not available, and I can't seem to reply to continue the
original posting.

I have text which includes " <inch marks. When I saveas csv, and open with
notepad there are additional " added to the text. If I re-op in excell I do
not see the additional ". For instance, a cell with < 6" shows in csv
opened with notepad as < "6""" . same csv re-opened in excel still shows
original format < 6" .

Any way to NOT get additional quotes to show when opening in Notepad?

--
Posted via a free Usenet account from http://www.teranews.com

--

Dave Peterson

csv & " (re-post)
 

Quotes in csv files are very troublesome. I would go to the original text
and replace them with in. so 6" would be 6 in.

"Mike Kiekover" wrote:

Still having trouble with this. Links refered to in replies from the
original post were not available, and I can't seem to reply to continue the
original posting.

I have text which includes " <inch marks. When I saveas csv, and open with
notepad there are additional " added to the text. If I re-op in excell I do
not see the additional ". For instance, a cell with < 6" shows in csv
opened with notepad as < "6""" . same csv re-opened in excel still shows
original format < 6" .

Any way to NOT get additional quotes to show when opening in Notepad?



--
Posted via a free Usenet account from http://www.teranews.com

csv & " (re-post)
 

that is soooo cool - the "Text files with no modification" macro work great.
One little quirk - It doesn't like the cells in the first column to be
blank. I got rid of the blank column and it did exactly what I needed. With
the blank column it only exported the first row.

Mike


"Dave Peterson" wrote in message
...
The site is back up now.

Mike Kiekover wrote:

Still having trouble with this. Links refered to in replies from the
original post were not available, and I can't seem to reply to continue
the
original posting.

I have text which includes " <inch marks. When I saveas csv, and open
with
notepad there are additional " added to the text. If I re-op in excell I
do
not see the additional ". For instance, a cell with < 6" shows in csv
opened with notepad as < "6""" . same csv re-opened in excel still shows
original format < 6" .

Any way to NOT get additional quotes to show when opening in Notepad?

--
Posted via a free Usenet account from http://www.teranews.com

--

Dave Peterson



--
Posted via a free Usenet account from http://www.teranews.com

csv & " (re-post)
 

This line in JE's code:

For Each myRecord In Range("A1:A" & _
Range("A" & Rows.Count).End(xlUp).Row)

is using column A to determine how many rows should be exported.

Can you pick out a different column that always has data in it?

If you can, you could modify that line of code:

For Each myRecord In Range("A1:A" & _
Range("X" & Rows.Count).End(xlUp).Row)

I used column X to find that last used row.



Mike Kiekover wrote:

that is soooo cool - the "Text files with no modification" macro work great.
One little quirk - It doesn't like the cells in the first column to be
blank. I got rid of the blank column and it did exactly what I needed. With
the blank column it only exported the first row.

Mike

"Dave Peterson" wrote in message
...
The site is back up now.

Mike Kiekover wrote:

Still having trouble with this. Links refered to in replies from the
original post were not available, and I can't seem to reply to continue
the
original posting.

I have text which includes " <inch marks. When I saveas csv, and open
with
notepad there are additional " added to the text. If I re-op in excell I
do
not see the additional ". For instance, a cell with < 6" shows in csv
opened with notepad as < "6""" . same csv re-opened in excel still shows
original format < 6" .

Any way to NOT get additional quotes to show when opening in Notepad?

--
Posted via a free Usenet account from http://www.teranews.com

--

Dave Peterson

--
Posted via a free Usenet account from http://www.teranews.com

--

Dave Peterson

csv & " (re-post)
 

Thanks for the info Dave - that could be useful if we want to limit the data
we export. Otherwise there isn't a reason we will not have data in all cells


"Dave Peterson" wrote in message
...
This line in JE's code:

For Each myRecord In Range("A1:A" & _
Range("A" & Rows.Count).End(xlUp).Row)

is using column A to determine how many rows should be exported.

Can you pick out a different column that always has data in it?

If you can, you could modify that line of code:

For Each myRecord In Range("A1:A" & _
Range("X" & Rows.Count).End(xlUp).Row)

I used column X to find that last used row.



Mike Kiekover wrote:

that is soooo cool - the "Text files with no modification" macro work
great.
One little quirk - It doesn't like the cells in the first column to be
blank. I got rid of the blank column and it did exactly what I needed.
With
the blank column it only exported the first row.

Mike

"Dave Peterson" wrote in message
...
The site is back up now.

Mike Kiekover wrote:

Still having trouble with this. Links refered to in replies from the
original post were not available, and I can't seem to reply to
continue
the
original posting.

I have text which includes " <inch marks. When I saveas csv, and open
with
notepad there are additional " added to the text. If I re-op in excell
I
do
not see the additional ". For instance, a cell with < 6" shows in
csv
opened with notepad as < "6""" . same csv re-opened in excel still
shows
original format < 6" .

Any way to NOT get additional quotes to show when opening in Notepad?

--
Posted via a free Usenet account from http://www.teranews.com

--

Dave Peterson

--
Posted via a free Usenet account from http://www.teranews.com

--

Dave Peterson



--
Posted via a free Usenet account from http://www.teranews.com