Paste Table from Word in Excel - 2000 -vs- 2002

[PeteW]

Scenario-
To track certain events I have a table in Word (4 columns x multiple rows). I regularly Cut a row from Word and paste it into Excel for archiving purposes when an event is finished
Multiple people use the same files, however, they access it from different PC's running different versions of MS Office.

Method-
As the formatting in the archive isn't important, I have developed a macro in Word that selects the entire row and strips out as much formatting as possible, including special characters such as Carriage feeds, paragraph breaks etc. Essentially I end up with a big block of unformatted text across 4 cells which is fine, it suits the requirements.
The macro then cuts the row to clipboard and the user opens Excel and pastes in using another macro which simply picks the next available cell in a column and does a Paste Special (as text).
For multiple rows, the user selects multiple rows in Word and applies the Macros

Results-
On a machine running Word & Excel 2000 both single rows and multiple rows are pasted between the two fine.
On a machine running Word & Excell 2002 where the user is pasting a single row, it works fine. 4 table cells are copied across to 4 Excel cells as expected.
On a machine running Word & Excel 2002 and the user is pasting multiple rows from Word.. only the FIRST row is pasted (correctly)... but the others just disappear......no sign of them...

Any ideas...

This only affects users on 2002 and only when pasting across multiple rows..other circumstances it's fine.... where are these extra rows disappearing off to ?? (I have checked under the desk )

Apologies for the long winded first post but I wanted to get as many facts in as possible.

Your help here is greatly appreciated

[Bryan Hessey]

Hi,

To help track down where the error occurs, have you tried an intermediary
'Paste' to Notepad.

If this is sucessful and the paste to Excel is still in error, try a Copy
from the Notepad data and paste into Excel, to see if this works.

--

"PeteW" wrote:

>
> Scenario-
> To track certain events I have a table in Word (4 columns x multiple
> rows). I regularly Cut a row from Word and paste it into Excel for
> archiving purposes when an event is finished
> Multiple people use the same files, however, they access it from
> different PC's running different versions of MS Office.
>
> Method-
> As the formatting in the archive isn't important, I have developed a
> macro in Word that selects the entire row and strips out as much
> formatting as possible, including special characters such as Carriage
> feeds, paragraph breaks etc. Essentially I end up with a big block of
> unformatted text across 4 cells which is fine, it suits the
> requirements.
> The macro then cuts the row to clipboard and the user opens Excel and
> pastes in using another macro which simply picks the next available
> cell in a column and does a Paste Special (as text).
> For multiple rows, the user selects multiple rows in Word and applies
> the Macros
>
> Results-
> On a machine running Word & Excel 2000 both single rows and multiple
> rows are pasted between the two fine.
> On a machine running Word & Excell 200*2* where the user is pasting a
> single row, it works fine. 4 table cells are copied across to 4 Excel
> cells as expected.
> On a machine running Word & Excel 200*2* and the user is pasting
> *multiple* rows from Word.. only the FIRST row is pasted (correctly)...
> but the others just disappear......no sign of them...
>
> Any ideas...
>
> This only affects users on 2002 and only when pasting across multiple
> rows..other circumstances it's fine.... where are these extra rows
> disappearing off to ?? (I have checked under the desk )
>
> Apologies for the long winded first post but I wanted to get as many
> facts in as possible.
>
> Your help here is greatly appreciated
>
>
> --
> PeteW
> ------------------------------------------------------------------------
> PeteW's Profile: http://www.excelforum.com/member.php...o&userid=33480
> View this thread: http://www.excelforum.com/showthread...hreadid=532833
>
>

[PeteW]

Thanks Bryan for the reply & tip. Only just back in the office now to do some testing. It has certainly thickened the plot somewhat now though !

When I do this interim paste into Notepad I see that only the first row is pasted again. - i.e. same symptoms as pasting into Excel.
Furthermore, I have tried pasting back into Word in a New Document and see that only the first row is being pasted - I have even tried all the Paste Special options (inc. Picture) and only the first row is pasted.

This is now suggesting to me a problem with the Copy portion of the process, (note that the same happens if I use Cut instead of Copy), and only the first row is making it into the Clipboard for use in other areas.

I am now focussing on what the macro does to the formatting to see if this is the cause prior to the Copy / Cut... as when I highlight multiple rows from the table under normal circumstances the Copy Paste function works normally on multiple rows (trouble is I need to remove the formatting for it to fit into Excel properly )

Thanks, and any further tips greatly appreciated

[PeteW]

It would seem that my problem not in Excel after all but in Word.
When you highlight block of text in word then do a find & replace, in Word2000 the block of text remains highlighted throughout, in Word2002, when a character is replaced, the block of text is de-selected and therefore then cut & paste was only picking up the current row containing the cursor and not the originally highlighted text.
Right, I'm off to find a WORD forum, anybody know any good ones ?!

Thanks for those that took the time to read and / or assist.

I'll be back in good time no doubt now that I've found you !