copy, open named doc and then paste etc

  • Thread starter Thread starter Johnnyboy5
  • Start date Start date
J

Johnnyboy5

Hi

I have a open document with a macro to copy a particular section,
what I would like to then do is for the macro to open another named
document and paste that selection in it, then to “shift” “control”
“F9” that pasted section.

Sub Macro2()
'
' Macro2 Macro
' Macro recorded 04/09/2010 by john
'
Selection.MoveDown Unit:=wdLine, Count:=123
Selection.MoveLeft Unit:=wdCharacter, Count:=6
Selection.MoveDown Unit:=wdLine, Count:=75, Extend:=wdExtend
Selection.Copy
End Sub


Any ideas

Thanks
 
One thought: instead of pasting and then unlinking, why not just paste as
unformatted text to begin with?

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

Hi

I have a open document with a macro to copy a particular section,
what I would like to then do is for the macro to open another named
document and paste that selection in it, then to “shift” “control”
“F9” that pasted section.

Sub Macro2()
'
' Macro2 Macro
' Macro recorded 04/09/2010 by john
'
Selection.MoveDown Unit:=wdLine, Count:=123
Selection.MoveLeft Unit:=wdCharacter, Count:=6
Selection.MoveDown Unit:=wdLine, Count:=75, Extend:=wdExtend
Selection.Copy
End Sub


Any ideas

Thanks
 
One thought: instead of pasting and then unlinking, why not just paste as
unformatted text to begin with?

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USAhttp://word.mvps.org


Hi

I have a open document with a macro to copy a particular section,
what I would like to then do is for the macro to open another named
document and paste that selection in it,  then to “shift” “control”
“F9”  that pasted section.

Sub Macro2()
'
' Macro2 Macro
' Macro recorded 04/09/2010 by john
'
    Selection.MoveDown Unit:=wdLine, Count:=123
    Selection.MoveLeft Unit:=wdCharacter, Count:=6
    Selection.MoveDown Unit:=wdLine, Count:=75, Extend:=wdExtend
    Selection.Copy
End Sub

Any ideas

Thanks
Click to expand...

Hi

coz the text is linked to a form with lots of fields and other "ref"
links to a table etc... its a bit messy but I something I use everyday
for my job,

I have sorted it out now...

thanks for your thoughts though.

Johnny
 
Back
Top