vba to copy from Excel to Word Doc

Can somebody please help me move forward with my coding? The code I have constructed so far is attached, may be very crude and incomplete but it works to a point.

What I am trying to do is; From command button on the active Excel Worksheet, open a specific Word doc, copy and paste a specific range from the Active Worksheet to a Bookmarked position in the Word doc, then run SaveAs. Would then do some manual editing to the Word Doc before closing it and returning to Excel.

Please Login or Register  to view this content.

What I am struggling with is:

1) Bringing the Word Doc into view, (so is the active window)
2) Prevent the Copy&Paste routine from being run again until the SaveAs operation has been completed and the Word Doc been closed ( so look to see if the Template Word Doc is already open and message to say it is and do you want to
continue working on it, if yes - bring it back into view, if no – just close message leaving Word Doc open but reduced)
3) Run SaveAs, but want to manually select/input the new file name. ( So need the SaveAs file dialogue box to be in view showing the other Word Docs in the folder, which is the same folder that the Word Doc Template is in)
4) Ideally I would like skip/not copy blank rows, which where will almost certainly be somewhere in the middle of the range selected to copy.

I hope that makes sense and someone out there can help me.

Many thanks
julhs

Gentle nudge.

I am actively working on this myself as well.

Try nudge one last time

Having said one last nudge!!

I so need some help with this.