Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-16-2017, 08:08 AM
jewels jewels is offline VBA to insert Excel, sheet1 cell H5 into where my cursor resides in MS Word Windows 7 32bit VBA to insert Excel, sheet1 cell H5 into where my cursor resides in MS Word Office 2010 32bit
Novice
VBA to insert Excel, sheet1 cell H5 into where my cursor resides in MS Word
 
Join Date: Oct 2017
Posts: 2
jewels is on a distinguished road
Post 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!
Reply With Quote
  #2  
Old 10-16-2017, 03:12 PM
macropod's Avatar
macropod macropod is offline VBA to insert Excel, sheet1 cell H5 into where my cursor resides in MS Word Windows 7 64bit VBA to insert Excel, sheet1 cell H5 into where my cursor resides in MS Word Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,213
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

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]
Reply With Quote
  #3  
Old 10-17-2017, 07:21 AM
jewels jewels is offline VBA to insert Excel, sheet1 cell H5 into where my cursor resides in MS Word Windows 7 32bit VBA to insert Excel, sheet1 cell H5 into where my cursor resides in MS Word Office 2010 32bit
Novice
VBA to insert Excel, sheet1 cell H5 into where my cursor resides in MS Word
 
Join Date: Oct 2017
Posts: 2
jewels is on a distinguished road
Default

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?
Reply With Quote
  #4  
Old 10-17-2017, 01:56 PM
macropod's Avatar
macropod macropod is offline VBA to insert Excel, sheet1 cell H5 into where my cursor resides in MS Word Windows 7 64bit VBA to insert Excel, sheet1 cell H5 into where my cursor resides in MS Word Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,213
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

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]
Reply With Quote
Reply

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
VBA to insert Excel, sheet1 cell H5 into where my cursor resides in MS Word Insert a Word Table into an Excel cell Kapoof Excel 1 02-18-2014 02:12 PM
VBA to insert Excel, sheet1 cell H5 into where my cursor resides in MS Word 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

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 12:44 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft