MSWord VB Macro

[VisualBasicHelp]

Hi,

I am trying to insert a page before pasting using macro. So that when pasted, it is pasted in a new page. I could do this using the paste icon on the standard toolbar like this -

CommandBars("standard").Controls("Paste").OnAction = "countPaste"

But if I try to do the paste by ctrl+v , I am not getting the required, can anybody please help me in this.

Thanks

 

[fumei]

Selection.InsertBreak Type:=wdPageBreak

will make a page break at the Selection point. Depening on where your paste is coming from:

With Selection
   .InsertBreak Type:=wdPageBreak
   .Paste
End With

will make a page break, then paste.

Gerry

 

[VisualBasicHelp]

But if I use this code means, what will happen is, whatever is in the clipboard will be pasted.

Actually I wanted to know if the user has opted for paste, that's why I have used "onaction". If so a function will be called which will check whether he is in the first page, if so it will paste or else, it will insert a page break and paste.

is there any other way out.

 

[PHV]

Why not attach the Ctrl+V keyboard to the countPaste macro ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[VisualBasicHelp]

Thanks a lot, it worked with such a simple solution.

I was strugling with it from past 2 days. Thanks again.

 

[VisualBasicHelp]

one more question, using macro in word, can I do a ALT+Printscreen in another application and it should be automatically pasted in active word document.

Thanks