Copy parts of several sheets to Word

Once a week I copy quite a lot of information from Exel to Word, to make a report. The content is in identical schedules in one Excel file and it is the same area I copy from each sheet. At present I have a macro making the exact copy (as picture), but I have to shift between Word and Excel all the time. I am sure there is a way to automate this, I just don't know how to - and it is here I need your help. I know it can be done with some VBA programming, but unfortunately I do not have sufficient expertise...

Because it is only a part from each pane i need to print. The schedules of each pane are similar - but it is only a part of each schedule I need to gather in a report...

By definition, a macro is automation. Without seeing your code, we would have to make alot of assumptions. If you posted the dot or doc file, it would be easier to help.

Not sure why you would switch between the 2. The macro would reference each application as an object. I am guessing that you would run the code from Excel.

Are you using CopyPicture for a Range?

You can use bookmarks in the doc file for a place to insert content. See this MrExcel thread for an example. These links show some TypeText methods.
http://www.excelforum.com/excel-prog...ml#post1946784
http://www.excelforum.com/showthread.php?p=1946784

Yes I am using "Copy Picture" for a range - and that is the only thing the macro I have created does.

Yes I would like the macro to run the code from Excel. Actually I never thought of doing it from Word.

I switch between Excel and Word because I don't know how to make a macro that does this.

The report is written in Word and the Excel input are meant to be part of this report.

Another link that might help would be to vbaexpress.com but they are offline right now. Another method using bookmarks with a copy paste routine is shown below. Notice how it differs from the standard Copy/Paste.

Please Login or Register  to view this content.