Paste a screen shot in Excel

Help Studio
, ,
1

Hi,
I need to paste screen shots in Excel tabs. Is there a way to resize the screen shot and paste in Excel sheet to fit reasonably?

2

@A_Learner

There is no direct way…you need to go with vba

Cheers

3

Hi @A_Learner

Check the below thread

Regards,

4

Thank you, @Anil_G
Cannot use VBA.

5

@A_Learner

Without using vba this requirement cannot be acheived

If not you need to go with frontend which is not preferred on excel

Cheers

6

Is VBA involved in this?
How to get the image activities? Which package needs install?

Thank you,

7

@A_Learner

No, VBA is not involved in this

There is no image activities. By using Invoke Method and KeyBoard Shortcuts

Regards,

1 Like
8

I have played with the VBA to insert images in Excel. It’s a hassle.

It’s simpler to save the image to a folder and then just put a link to it in Excel.

1 Like
9

Thank you, It works. This pastes in a cell only. I cannot specify range like A1: P20

Is there a way to re-size image after pasting in Excel without VBA or can I specify the range of cells to paste?

Thanks so much

10

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.