printing and saving screenshots at the same time

Chuthry

New Member
Joined
Mar 28, 2010
Messages
33
Hi, i need to create a excel macro that can send a independent application screenshot to print out to printer and at the same time save the image in excel spreadsheet. The saving portion would be append.

Example the 1st screenshot is saved till row5, i need the macro to save the second screenshot starting from row6, is this possible?

If Not , how do i create a macro to save/paste a image after 5rows in excel?
example, row1 to row5 is for first image, row6 to row10 is for second image and row11 to row15 is for third image and so on.

Would appreciate any expert help on this. Thanks
 

Chuthry

New Member
Joined
Mar 28, 2010
Messages
33
hi i do not understand the code A1:F5?

First of all the macro must perform the following function

user capture a screenshot from a 3rd party application using alt+print screen key.
Next user click on a button with the macro assigned to it
once user click on the button, the macro would perform the following
1) Paste the screenshot in sheet1 and printout to printer
2) paste the screenshot in sheet2 from row1 to row5 (1st screenshot)
3) Macro would repeat action for point 1 and paste 2nd screenshot in sheet2 row6 to row10.
4) In sheet2, there should be a selection for user to print out the screenshot again based on user selection

Could you be able to advise? Thanks
 

Some videos you may like

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

Chuthry

New Member
Joined
Mar 28, 2010
Messages
33
Hi our company could not install software due to protection of client information thus would need to use excel.

Could you be able to advise ? Thanks
 

VoG

Legend
Joined
Jun 19, 2002
Messages
63,650
Perhaps

Code:
Private Sub CommandButton1_Click()
With Me
    .Paste .Range("A1")
    .PrintOut
    .Pictures(.Pictures.Count).Copy
    Sheets("Sheet2").Paste
End With
End Sub
 

andrewman

Board Regular
Joined
Jul 16, 2008
Messages
206

ADVERTISEMENT

Hi Chuthry,

The workflow should be following:-

1) User click on a button with the marco
2) Excel swift to capture a screenshot from a 3rd party application
3) User press a specify key 1
3) Excel Paste the screenshot in sheet1 and printout to printer
4) Paste the screenshot in sheet2 from row1 to row5 (1st screenshot)
5) Macro would repeat action for point 1 and paste 2nd screenshot in sheet2 row6 to row10.
6) User press a specify key 2 to stop the marco or press key 1 to continue.

In sheet2, there should be a selection for user to print out the screenshot again based on user selection.
 

Chuthry

New Member
Joined
Mar 28, 2010
Messages
33
hi andrewman are you able to provide a macro for this?

Hi Mr excel, is the macro able to repeat for 2nd screenshot?
 

Watch MrExcel Video

Forum statistics

Threads
1,108,931
Messages
5,525,684
Members
409,660
Latest member
1817538628

This Week's Hot Topics

Top