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
 
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
 
Upvote 0

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.
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
 
Upvote 0
Perhaps

Code:
Private Sub CommandButton1_Click()
With Me
    .Paste .Range("A1")
    .PrintOut
    .Pictures(.Pictures.Count).Copy
    Sheets("Sheet2").Paste
End With
End Sub
 
Upvote 0
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.
 
Upvote 0
hi andrewman are you able to provide a macro for this?

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

Forum statistics

Threads
1,213,549
Messages
6,114,264
Members
448,558
Latest member
aivin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top