Screen capture and paste it in doc

[sai charan]

Can someone please help me with a macro to do the following activity
Firstly when we click on print screen it has to automatically open a word doc and paste the image in it

 

[dermie_72]

you could try something like:

sub paste_existing_screencap_to_word()
Dim word As Object
Dim doc As Object
On Error Resume Next

Set word = GetObject(, "word.application") 'gives error 429 if Word is not open
If Err = 429 Then
    Set word = CreateObject("word.application") 'creates a Word application
    Err.Clear
End If

With word
    .Visible = True
    .Documents.Add
End With

With word.Selection
        .Range.PasteSpecial
End With

End Sub

 

[sai charan]

Thanks for sharing the code.
This works fine when we have some data in the clip board only for once.
What i need is when i click print screen it has to paste in the same document for n number of times.

 

[Jaafar Tribak]

See if you can adapt the codes in the following threads

Post 4

or

Post 3

 

[dermie_72]

Thanks for sharing the code.
This works fine when we have some data in the clip board only for once.
What i need is when i click print screen it has to paste in the same document for n number of times.

Can you qualify n number of times. For future reference, this is the first time you have mentione needing it for n number of times. That sort of information would have been extremel handy in the first post.

So, please explain how many times you want to paste it, is this always the same, is it a variable captured in a file/cell or inputbox? Is it being pasted into the same document or a new document each time.

Are you able to just loop the code yourself?

 

[sai charan]

Thanks for your valuable suggestion,I would have communicated the same in first post.
The thing is we need to start the macro,then whenever we are giving print screen the image has to be posted in the same document which is opened ,then if we stop the macro code all the screenshots should be in the same doc.
I am trying to paste every screen shot(image) in the same document.
No i am not able to loop the code.
So please help me in solving this

 

[dermie_72]

If you're just adding a screen dump to an existing file, can't you just paste it into the bottom of the word doc once you have captured the screen?
You can't loop a code where you haven't captured the screen shots yet.
It would be easier to just press Control + Printscreen, go to word, press control + V