deepaksethu
11-20-2006, 07:08 AM
I need a bit of (hopefully) straightforward VBA advice. I have docments
based on a Excel Sheet and documents based on a particular
Word template. I want to copy a small selection from the active document
based on the Excel Sheet to the active document based on the Word
template. I want my VBA program to be stored in the Word template The VBA code should say:
1. Go to the active Excel document (name of document not specified
because it is might be any document based on the template, but it is the
current active document in Excel).
2. Start at the active cell (will always be Column B, but could be any
row), select this cell then copy it.
3. Go to the open Word document (name of document not specified because it might be any document based on the template, but it is the current active document in Word).
4. Paste the Excel selection at the Pre-determined slot in the Word document. Different position of cursor. Paste/Special/Unformatted
Text.
Any suggestions/advice would be very greatly appreciated.
based on a Excel Sheet and documents based on a particular
Word template. I want to copy a small selection from the active document
based on the Excel Sheet to the active document based on the Word
template. I want my VBA program to be stored in the Word template The VBA code should say:
1. Go to the active Excel document (name of document not specified
because it is might be any document based on the template, but it is the
current active document in Excel).
2. Start at the active cell (will always be Column B, but could be any
row), select this cell then copy it.
3. Go to the open Word document (name of document not specified because it might be any document based on the template, but it is the current active document in Word).
4. Paste the Excel selection at the Pre-determined slot in the Word document. Different position of cursor. Paste/Special/Unformatted
Text.
Any suggestions/advice would be very greatly appreciated.