How can I insert a screen print into a cell

  • Thread starter Thread starter jloyzaga
  • Start date Start date
J

jloyzaga

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top