Automating Cut and Paste Special?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

IainH124A - 12 Sep 2006 11:49 GMT

I am having to cut hundreds of images out of a Word document and 'paste
special' them back in a different format (jpg). Does any one know of a way to
automate this process for all the images in the document?

I have tried using a Macro but that only seems to work with a single image.
Thanks

Reply to this Message

Jezebel - 12 Sep 2006 13:50 GMT

If your macro worked with only one, I suspect you tried to create the macro
by recording it. You need to *write* the macro properly for this sort of
task.

> I am having to cut hundreds of images out of a Word document and 'paste
> special' them back in a different format (jpg). Does any one know of a way
[quoted text clipped - 4 lines]
> image.
> Thanks

Reply to this Message

IainH124A - 12 Sep 2006 14:38 GMT

Thanks for the reply. I did try to record it. Is there a better way doing it
using scripts or something similar?

> If your macro worked with only one, I suspect you tried to create the macro
> by recording it. You need to *write* the macro properly for this sort of
[quoted text clipped - 8 lines]
> > image.
> > Thanks

Reply to this Message

Jonathan West - 12 Sep 2006 16:25 GMT

> Thanks for the reply. I did try to record it. Is there a better way doing
> it
> using scripts or something similar?

Take a look at these articles

Creating a macro with no programming experience using the recorder
http://www.word.mvps.org/FAQs/MacrosVBA/UsingRecorder.htm

Getting To Grips With VBA Basics In 15 Minutes
http://www.word.mvps.org/FAQs/MacrosVBA/VBABasicsIn15Mins.htm

Signature

Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup
Keep your VBA code safe, sign the ClassicVB petition www.classicvb.org

Reply to this Message