Copy bitmap to specific word document, preferably without closing it.

[Skeidser]

I'm trying to copy a range as bitmap to a specific worddocument. The values of the range will change several times when working, so I will have to copy it several times.

My code is:

Please Login or Register  to view this content.

I'm not experienced enough with having Excel work with Word, so I don't know how to adjust the above code to make it work.
But as I explained above, I want the A1:M40 range copied to the wordname.docx, preferably without closing wordname.docx everytime.
wordname.docx will already have been created when opening the workbook (this works perfectly), so this code will have to add to it. So, I don't know if the

Please Login or Register  to view this content.

is necessary, but leaving it out doesn't help.

I hope I've explained myself well enough
Do you have any solutions to how I can copy the range with ease to the word document?

[Skeidser]

Attachment 671746

I just found out, that the reason the code doesn't is because of the message in the screenshot I've attached.
Anyway to work around this in the code?

[Skeidser]

I figured out how to do it after a lot of googling, but it has some requirements. Here it is:

First I have a macro run when opening workbook:

Please Login or Register  to view this content.

I first create the word.docx and name it. The next executes when the bitmap is ready to be copy-pasted:

Please Login or Register  to view this content.

This way it works perfectly, but it requires that the word.docx is open when working, and probably need it to be the only word.docx open.

[AliGW]

Thanks for letting us know.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

[macropod]

Your posts are confusing, to say the least. You say

wordname.docx will already have been created when opening the workbook

but then you have code to create it, which implies the document had not already been created. You also say:

I want the A1:M40 range copied to the wordname.docx, preferably without closing wordname.docx everytime

But the code you posted has one lot copying that range, but another copying A1:N40. Plus you quit Word - which necessarily closes the document.

The following code shows how to go about checking if the document is already open and, if not, creating one, then leaving the document open once the data have been pasted into it.

Please Login or Register  to view this content.

[Skeidser]

Yeah, I see that my post is confusing, but as I said I have little experience with the interaction between word and excel.

In my own reply I got an answer which is actually pretty simple.

Thanks for the input

[macropod]

If you study the code I posted, though, you'll see there is no need to activate or select anything in Excel or Word, which makes the code far more efficient.

[Skeidser]

If you study the code I posted, though, you'll see there is no need to activate or select anything in Excel or Word, which makes the code far more efficient.

Oh, I see now. Thank you