ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How can I insert a screen print into a cell (https://www.excelbanter.com/excel-discussion-misc-queries/174221-how-can-i-insert-screen-print-into-cell.html)

jloyzaga

How can I insert a screen print into a cell
 
I want to insert the screen capture into an excel cell. I would preferrably
like to do this via .vbs Desktop.CaptureBitmap(sFile) command and then put
whats in the copybook into the cell

FSt1

How can I insert a screen print into a cell
 
hi
not sure about 2007 but for all version back, images cannot be put into a
cell.
images (such as bitmaps) are display on the sheet in a image control which
floats on top of the sheet. they can be sized and moved with cells.
as a suggestion, they can be pasted into a comment which may be the closest
you can get to "putting it in the cell". see this site.
http://www.contextures.com/xlcomments02.html#Picture
and i wouldn't do the bitmap. i would paste the print screen into paint and
save as a jpeg.

regards
FSt1
"jloyzaga" wrote:

I want to insert the screen capture into an excel cell. I would preferrably
like to do this via .vbs Desktop.CaptureBitmap(sFile) command and then put
whats in the copybook into the cell



All times are GMT +1. The time now is 12:13 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com