P
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 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
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