|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
VBA to insert Excel, sheet1 cell H5 into where my cursor resides in MS Word
Hi everyone,
I'm a newbie and need to create a code to insert "Sheet1" cell "H5" into the MS Word file where my cursor resides. Much appreciated! |
#2
|
||||
|
||||
That would require a lot of code for something that can be done quite simply via copy/paste. Is there a particular reason it needs to be done with a macro?
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
I have over 100+ records/documents to create in a MS word format from the worksheets in MS Excel.
For the 100+ records/documents, I have created a table template format and for the cells within this MS Word table represents data from the same cells in each of the excel worksheets. Is there an easier method? |
#4
|
||||
|
||||
So now there are multiple documents and worksheets??? How can all the worksheets be named "Sheet1" unless they're also in different workbooks?
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
ComboBox : select image to insert in Sheet1 | smallxyz | Excel Programming | 0 | 02-07-2016 05:41 PM |
How to populate cells in Sheet2 with Data Source query using cell data from Sheet1 | bobznkazoo | Excel | 2 | 03-27-2014 11:14 AM |
Insert a Word Table into an Excel cell | Kapoof | Excel | 1 | 02-18-2014 02:12 PM |
How to merge two cells from sheet1 to one cell in sheet2 in next sheet | KIM SOLIS | Excel | 6 | 10-30-2011 11:14 PM |
Insert an item to excel specific cell | apjneeraj | Excel | 0 | 01-18-2011 03:39 AM |