Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
vb vb is offline
external usenet poster
 
Posts: 4
Default Change in "paste link" from Excel source in Word 2007?

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?

  #2   Report Post  
Posted to microsoft.public.word.docmanagement
Herb Tyson [MVP] Herb Tyson [MVP] is offline
external usenet poster
 
Posts: 2,936
Default Change in "paste link" from Excel source in Word 2007?

It sounds like a manual line break character is being pasted instead of the
original chr$(13). This causes Word to treat that pasted bit as a single
paragraph, which is why you get only the one bullet.

Here, when I use Edit/Paste Special/Unformatted text, I do get the original
^13 characters instead of manual line breaks (^11). If that's not working
right for you, and if you're using a program to insert the ^13 characters,
you might try using a ^13 ^10 (carriage return, line feed) combination,
instead.

Or... if you're not otherwise deliberately using manual line breaks, you
could change them into regular paragraph breaks using Find/Replace: replace
^11 with ^13.

--
Herb Tyson MS MVP
Author of the Word 2007 Bible
Blog: http://word2007bible.herbtyson.com
Web: http://www.herbtyson.com


"vb" wrote in message
...
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?


  #3   Report Post  
Posted to microsoft.public.word.docmanagement
vb vb is offline
external usenet poster
 
Posts: 4
Default Change in "paste link" from Excel source in Word 2007?

I don't know why this field would require me to embed chr(13) and chr (10)
when all of the other fields worked fine just using chr(13). The other thing
of course is that it appears that the inability to format is tied to the fact
that the result is being pasted as a quote.

I dug up a laptop that was still running Word 2003 and to my dismay that now
also pasted the cell contents as a quoted string, so the fact that I opened
up these documents in Office 2007 and saved them in compatibility mode had
something to do with the problem.

Finally, I ended up bringing up the field codes, copying the reference from
the cell next to it, and manually adjusting the cell reference. Finally the
link worked the way I wanted it to.

To see if I could learn anything, I then repasted the link as I had been
doing and compared the field codes from the results. Both of them had the
field switch \a, but the old version had the switched \F 4 and \r, whereas
the new link had the field switch \t. The description of the \t switch sounds
like it may be responsible for treating the referent contents as a quote. So
apparently the problem is related to different switched being applied when
pasting speciallinkunformatted text. I haven't seen anything in the option
menu that would allow you to override this behavior...


"Herb Tyson [MVP]" wrote:

It sounds like a manual line break character is being pasted instead of the
original chr$(13). This causes Word to treat that pasted bit as a single
paragraph, which is why you get only the one bullet.

Here, when I use Edit/Paste Special/Unformatted text, I do get the original
^13 characters instead of manual line breaks (^11). If that's not working
right for you, and if you're using a program to insert the ^13 characters,
you might try using a ^13 ^10 (carriage return, line feed) combination,
instead.

Or... if you're not otherwise deliberately using manual line breaks, you
could change them into regular paragraph breaks using Find/Replace: replace
^11 with ^13.

--
Herb Tyson MS MVP
Author of the Word 2007 Bible
Blog: http://word2007bible.herbtyson.com
Web: http://www.herbtyson.com


"vb" wrote in message
...
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?



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
What happened to "View HTML Source" in Word 2007? Troy Microsoft Word Help 2 January 15th 08 07:13 AM
Excel merge into Word:"unable to open data source" STEVE Microsoft Word Help 3 September 21st 07 02:58 PM
Word 2007 "Read-Only" error when changing source data [email protected] Mailmerge 7 June 21st 07 06:16 PM
Link a word drop down field "text" to an excel cell [email protected] Microsoft Word Help 1 January 29th 07 03:52 PM
ASP.NET - Excel - Mail Merge in Word causes "Data Link Properties" dialog to appear. [email protected] Mailmerge 1 April 18th 06 02:38 PM


All times are GMT +1. The time now is 10:39 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"