[vb]

I have a number of documents that contain pasted links to lengthy text
strings in Excel. First I'll give a thumbnail of the overall process, then
explain my issue.

We conduct a lot of surveys and keep the master data files in SPSS. I have
created processes that aggregate the data in SPSS and then dump the results
out into Excel. Since the save to Excel (at least at the time I wrote it)
always overwrites the existing file, I have a second spreadsheet read the raw
data from the first and perform certain corrections, resulting in a document
I can mailmerge into a template to automatically create tables. I have been
using Windows 2003 compatibility mode for these files because then I can use
DDE, and I am using DDE because then the source formatting I apply in Excel
is carried over to Word.

For open-ended comments, I bring those into Excel, then append them one
after the other with a hard return (char 13) in-between. The result used to
be that I could paste a link to a single cell in the Excel spreadsheet, and
when it updated all of the comments would appear as a single, bulleted list.

All of the links that I put in place using Word 2003 continue to work in
this fashion. I attempted to add another link for a new field now after I
have updated to Word 2007, and it's not working the same. The link now is
pasted within a set of quotation marks. When I apply bullet formatting, it
will only apply the bullet to the first line of text; even though each item
appears on a separate line as before, something about the way it's pasted
doesn't allow me to apply formatting to it, even though it was inserted as
Paste SpecialUnformatted Text.

I've played around with the Word options. I turned off smart quotes, I
turned off smart cursoring, I've turned off separate paragraph and page
breaks. Nevertheless, it keeps pasting in quotes.

I've read about a "paste text only" option, but even though I have "show
paste options buttons" turned on, I have never seen this option come up.

How can I get the link to work the way it did in Word 2003?