PC Review


Reply
Thread Tools Rate Thread

copy, open named doc and then paste etc

 
 
Johnnyboy5
Guest
Posts: n/a
 
      4th Sep 2010
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
 
Reply With Quote
 
 
 
 
Suzanne S. Barnhill
Guest
Posts: n/a
 
      4th Sep 2010
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

"Johnnyboy5" <(E-Mail Removed)> wrote in message
news:e491e4b4-4f06-443e-a52a-(E-Mail Removed)...
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

 
Reply With Quote
 
Johnnyboy5
Guest
Posts: n/a
 
      5th Sep 2010
On 4 Sep, 19:04, "Suzanne S. Barnhill" <sbarnh...@mvps.org> wrote:
> 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
>
> "Johnnyboy5" <intermediatec...@gmail.com> wrote in message
>
> news:e491e4b4-4f06-443e-a52a-(E-Mail Removed)...
> 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


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
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
copy named range & paste J.W. Aldridge Microsoft Excel Programming 2 8th Oct 2009 04:38 PM
copy and paste named cells greg Microsoft Excel Discussion 2 17th Jun 2008 05:10 AM
Copy and paste Named Ranges Robert H Microsoft Excel Programming 6 6th Feb 2007 04:13 PM
Copy and Paste 2 columns from a named range? Simon Lloyd Microsoft Excel Programming 2 28th May 2006 08:10 PM
Copy and paste two named ranges together. =?Utf-8?B?QUNEZW52ZXI=?= Microsoft Excel Discussion 3 20th Oct 2005 11:36 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:31 AM.