Differences Between Two Spreadsheets ?

B

Bob

Hello,

Not an expert with Excel, and a bit on the elderly side, so please bear
with me a bit. Will try to explain as best I can.
Using Excel 2007 and Windows 7.

I have a .csv spreadsheet from a few years ago that was created by
another party, who is no longer available.

No formulas, more of a "database" with some cells having a numerical
value, and others text.
Spreadsheet is Imported and used in a radio control program that Imports
these text and numerical values to automatically tune the radio. This
older one works fine.

If I create a new version, using what seems to me the Exact same Format,
column headings, etc., it will not work or be Imported.

If you look at both spreadsheets, they "seem" identical, but apparently
are not.

Text on the left of the cell, numericals on the right edge, saved as
..csv, etc. No visual difference apparent.

But, if I open up the older one in Notepad, the cells are shown with
commas between them, and the text from each text cell has quotation (")
marks around it.

My spreadsheet in Notepad has the commas, but NO quotation marks.

What might be different between these two spreadsheets ?

* Why would the older one show the quote marks in Notepad, which are
required for importing into the radio control program, and mine does
not ? *

Would really like to understand the differences, before I go into mine
and add all the quote marks around each piece of text, if I have to; a
really big job.
(any way of automating this, perhaps ?)

Any thoughts would be most appreciated.

Thanks,
Bob
 
L

lhkittle

Hello,



Not an expert with Excel, and a bit on the elderly side, so please bear

with me a bit. Will try to explain as best I can.

Using Excel 2007 and Windows 7.



I have a .csv spreadsheet from a few years ago that was created by

another party, who is no longer available.



No formulas, more of a "database" with some cells having a numerical

value, and others text.

Spreadsheet is Imported and used in a radio control program that Imports

these text and numerical values to automatically tune the radio. This

older one works fine.



If I create a new version, using what seems to me the Exact same Format,

column headings, etc., it will not work or be Imported.



If you look at both spreadsheets, they "seem" identical, but apparently

are not.



Text on the left of the cell, numericals on the right edge, saved as

.csv, etc. No visual difference apparent.



But, if I open up the older one in Notepad, the cells are shown with

commas between them, and the text from each text cell has quotation (")

marks around it.



My spreadsheet in Notepad has the commas, but NO quotation marks.



What might be different between these two spreadsheets ?



* Why would the older one show the quote marks in Notepad, which are

required for importing into the radio control program, and mine does

not ? *



Would really like to understand the differences, before I go into mine

and add all the quote marks around each piece of text, if I have to; a

really big job.

(any way of automating this, perhaps ?)



Any thoughts would be most appreciated.



Thanks,

Bob

Hi Bob,

I have no opinion on the difference 'twix the worksheets.

Give this a try on a sample of your data for adding the quotes if it comes to that. Of course change Set wsA = Range("A1:p22") to suit your range.

Option Explicit

Sub DoDem()
Dim c As Range
Dim wsA As Range
Set wsA = Range("A1:p22")

For Each c In wsA
c.Value = """" & c.Value & """"
Next
End Sub

Regards,
Howard
 
R

Ron Rosenfeld

Hello,

Not an expert with Excel, and a bit on the elderly side, so please bear
with me a bit. Will try to explain as best I can.
Using Excel 2007 and Windows 7.

I have a .csv spreadsheet from a few years ago that was created by
another party, who is no longer available.

No formulas, more of a "database" with some cells having a numerical
value, and others text.
Spreadsheet is Imported and used in a radio control program that Imports
these text and numerical values to automatically tune the radio. This
older one works fine.

If I create a new version, using what seems to me the Exact same Format,
column headings, etc., it will not work or be Imported.

If you look at both spreadsheets, they "seem" identical, but apparently
are not.

Text on the left of the cell, numericals on the right edge, saved as
.csv, etc. No visual difference apparent.

But, if I open up the older one in Notepad, the cells are shown with
commas between them, and the text from each text cell has quotation (")
marks around it.

My spreadsheet in Notepad has the commas, but NO quotation marks.

What might be different between these two spreadsheets ?

* Why would the older one show the quote marks in Notepad, which are
required for importing into the radio control program, and mine does
not ? *

Would really like to understand the differences, before I go into mine
and add all the quote marks around each piece of text, if I have to; a
really big job.
(any way of automating this, perhaps ?)

Any thoughts would be most appreciated.

Thanks,
Bob

See http://www.mcgimpsey.com/excel/textfiles.html for information on how to add text delimiters to Excel generated CSV files. Excel usually does not do that, UNLESS the text field contains a comma. And, in general (but may not apply to your specific instance, if the text field already contains a double quote, you would need to "double that up".
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top