Copy data from Excel2007 to MS Works 4.0

[kataevag]

I use to be able to copy data from Excel 2000 to MS Works 4.0 using
copy/paste. After upgrading to Office 2007 the data are pasted in the MS
Works as a picture. How to transfer data from Excel 2007 into the MS Works
4.0?

 

[Harlan Grove]

I use to be able to copy data from Excel 2000 to MS Works 4.0 using
copy/paste. After upgrading to Office 2007 the data are pasted in
the MS Works as a picture. How to transfer data from Excel 2007 into
the MS Works 4.0?

Does Works 4.0 have a Paste Special command? If so, with a range from
Excel 2007 in the clipboard, does Work's Paste Special dialog show an
option for pasting Text? If so, try that. If not, you may need to
paste into Notepad or Wordpad, then copy from Notepad or Wordpad and
paste into Works.

Also, are you pasting into the Works spreadsheet or the Works word
processor?

 

[kataevag]

Does Works 4.0 have a Paste Special command? If so, with a range from
Excel 2007 in the clipboard, does Work's Paste Special dialog show an
option for pasting Text? If so, try that. If not, you may need to
paste into Notepad or Wordpad, then copy from Notepad or Wordpad and
paste into Works.

Also, are you pasting into the Works spreadsheet or the Works word
processor?

Harland, thank you for your reply.

Unfortunately “Works 4.0†does not have the “paste special†command.
Transferring data through text files does work but it is an additional step
I would like to avoid.

 

[Harlan Grove]

Unfortunately “Works 4.0†does not have the “paste specialâ€
command. Transferring data through text files does work but it is an
additional step I would like to avoid.

Unfortunately is appears to be a step you won't be able to avoid when
copying from Excel 2007. You could use a macro in Excel 2007 to automate the
process, with the macro launching Notepad, pasting into it, copying
everything in Notepad to the clipboard, and closing Notepad - all via
SendKeys.