about frame and screen shot of a frame
I have one frame in VBA and some objects in in (text boxes in my
case). I would like to copy the content of this frame into frame in excell... How is this possible... I tried using .picture but this only copies a picture from one frame to the other not the entire content... So, basiclly a screen shot of the frame is what I need. Hope someone knows... Thanks |
about frame and screen shot of a frame
In order to get a screen shot of anything in Windows, I would assume the
object/control would need to expose a handle (hwnd). As most standard control from the Forms2 library do not, this may prove a problem. The Form does, so maybe one of the methods listed under the "PrintScreen" section here may help: http://vbnet.mvps.org/code/screen/index.html NickHK "Monte0682" wrote in message ups.com... I have one frame in VBA and some objects in in (text boxes in my case). I would like to copy the content of this frame into frame in excell... How is this possible... I tried using .picture but this only copies a picture from one frame to the other not the entire content... So, basiclly a screen shot of the frame is what I need. Hope someone knows... Thanks |
All times are GMT +1. The time now is 12:12 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com