|
|
|||||||
|
|
|
Thread Tools | Display Modes |
|
|
|
#1
10-16-2017, 08:08 AM
|
|||
|
|||
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
10-16-2017, 03:12 PM
|
||||
|
||||
|
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
10-17-2017, 07:21 AM
|
|||
|
|||
|
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
10-17-2017, 01:56 PM
|
||||
|
||||
|
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]
|
|
|
| Thread Tools | |
| Display Modes | |
|
|
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 |
Windows 7 32bit 
Office 2010 32bit
Hybrid Mode