copy each range as bitmap into word file

Hi experts

I have set of range table in sheet tripplanner! i want copy each range of table and paste into new word file one by one as bitmap image

by doing it manually it really hard for me

please help on this

See if this works for you;

Please Login or Register  to view this content.

I've put a one second delay in before it pastes as for some reason it was causing it to randomly error out with a clipboard error, it wouldn't always do it so I assume it's a problem with memory or caching somewhere.

You can try and remove it to speed things up for you and put it back in if you get the same error.

Hope that helps.

HI brother

It works perfectly i just want make small change
i want move all bitimage into seperate folder instead of wordfile , can u make these changes in code please

thanks alot

Sorry - I don't understand what you mean.

You want the pictures saving into a folder and not going into a Word document?

yes i want move pic saving to folder not word thanks

OK. Well, that's something else entirely from what you originally asked for - This isn't a "small change"

I'd ask you to think about what it is you actually want before posting a question next time.

Please Login or Register  to view this content.

Some of that work isn't mine, I had to use; Spreadsheet Guru Code to work out the size formatting.

(Least I've learnt something!)

Thanks brother it works perfect