TransferSpreadsheet Macro Problem

[njgreen2001@gmail.com]

I have three of these that run off queries. They work for the most
part except that on every cell, it inserts an apostrophe ( ' ) before
all text. I can't seem to figure out why. The transfer type is
"Export" and the spreadsheet type is "Microsoft Excel 8-10." I am
using Access/Excel 2003. Any suggestions?

[Kc-Mass]

Re: TransferSpreads heet Macro Problem


<njgreen2001@gm ail.comwrote in message
news:1167686429 .570344.86830@k 21g2000cwa.goog legroups.com...

>I have three of these that run off queries. They work for the most
part except that on every cell, it inserts an apostrophe ( ' ) before
all text. I can't seem to figure out why. The transfer type is
"Export" and the spreadsheet type is "Microsoft Excel 8-10." I am
using Access/Excel 2003. Any suggestions?
>

I do not know where your data originates but It is pretty common for server
level data to arrive in a spreadsheet with what I call quoted numerics as
in '2345634 .

When that is the case access 2003 will show a colored triangle in
the cell. If you then highlight an area of those values you will see
a diamond shaped object with a "!" in it. If you click on that it will
offer to convert the cell's content to numbers.

If that is your situation, you can either fix them interatively
as noted above or programatically set a range to
include all the cells so affected and then simply execute a command
of "xlsheet.Range. Value = xlsheet.Range.v alue" and all quoted numerals
are converted to numbers.

They will then right align and behave in equations as numbers
because they now are numbers.

Good Luck

Kevin C