Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 05-08-2017, 07:05 AM
mihnea96 mihnea96 is offline how to copy different text from word into excel on consecutive rows Windows 7 32bit how to copy different text from word into excel on consecutive rows Office 2010 32bit
Novice
how to copy different text from word into excel on consecutive rows
 
Join Date: Apr 2017
Posts: 26
mihnea96 is on a distinguished road
Default how to copy different text from word into excel on consecutive rows

Hi! Could you kindly help me with my problem: I want to copy some text from Word into Excel, using a command button. The idea is that i select some text, press the button and it pastes the selected text in b2, for example, and when I select another text, I cannot make it to paste the secondly selected text in b3, and so on.
This is the code i'm trying to use. Could you explain me, please, what's wrong about it and help me fix it?

Thank you!



Code:
Private Sub CommandButton2_Click()
Selection.Copy
Dim objXL As Object
Set objXL = GetObject(, "excel.application")

Dim NumRows As Long
Dim xlsRow As Row
xlsRow = xlsRow + 1
objXL.Application.Cells(xlsRow, 2) = Selection.Text
Selection.Paste

End Sub
Reply With Quote
 

Tags
word to excel text

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to copy different text from word into excel on consecutive rows Excel VBA macro to copy specific rows and delete it pourmalla Excel Programming 2 04-02-2017 12:09 AM
Counting Consecutive Periods In Rows Using Numbers Yaaseen23 Excel 18 03-24-2017 11:15 AM
Copy Underline text from Word and Paste into excel rfaris Excel Programming 7 10-05-2015 05:56 AM
how to copy different text from word into excel on consecutive rows Is it possible to copy non-contiguous rows of a Table and paste them as a separate Table in Word? Joey Cheung Word Tables 1 08-12-2014 05:15 PM
how to copy different text from word into excel on consecutive rows Find Results in excel copy the rows to another sheet khalidfazeli Excel 2 02-06-2013 09:38 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:29 AM.


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