PDA

View Full Version : Macro to append clipboard image to word doc



janith
05-08-2012, 09:51 AM
HI,

I AM LOOKING FOR A VBA MACRO WHICH WILL GET A IMAGE FROM CLIPBOARD(WHEN COPIED) AND AUTOMATICALLY APPEND IT TO THE CURRENT WORD DOCUMENT.WHEN EVER I CLICK COPY THE IMAGE SHOULD GO TO WORD AUTOMATICALLY.

THANK YOU FOR THE ASSISTANCE...

Frosty
05-08-2012, 11:12 AM
WHY DON'T YOU RECORD A MACRO WHICH WILL DO THAT (GO TO END OF DOCUMENT USING CTRL+END AND PASTE USING CTRL+V)?

SINCE VBA IS ONLY AVAILABLE WHEN YOU ARE IN WORD, WHAT YOU ARE DESCRIBING IS NOT POSSIBLE. THE ABOVE METHODOLOGY IS THE BEST YOU GET USING VBA.

Hope the above helps :)

janith
05-08-2012, 11:17 AM
hi,

i was wondering if it will not be possible to write something in vba which checks for data in clipboard viewer and pastes on word?!!!

Frosty
05-08-2012, 02:29 PM
Many things are possible. But you are not currently specific enough in your request to give you a concrete answer... you are asking whether something is possible. It probably is. I don't know.

But it will be much more simple if you define what are you trying to automate.

Record a macro which pastes at the end of a document. Post that macro here. Tell us what it does not do that you would like it to do, and when you want it to happen.

Vague questions can only receive vague answers. Sorry.