Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-04-2021, 12:44 AM
yacov yacov is offline macro from word to excel Windows 10 macro from word to excel Office 2016
Competent Performer
macro from word to excel
 
Join Date: Oct 2019
Posts: 139
yacov is on a distinguished road
Default macro from word to excel

Hi
I have a very long document that includes only text I wrote in Word. I moved it from Word to Excel.
And I would like to run on it a macro written in VBA Word. Are there any changes I need to make to the macro? every macro that work in Word will work also in Excel?


Thanks,
Reply With Quote
  #2  
Old 08-04-2021, 01:00 AM
p45cal's Avatar
p45cal p45cal is offline macro from word to excel Windows 10 macro from word to excel Office 2019
Expert
 
Join Date: Apr 2014
Posts: 867
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default

Not necessarily. Best supply the code of the macro.
Doe the text end up in one cell in Excel? Or several cells?
Reply With Quote
  #3  
Old 08-04-2021, 01:28 AM
yacov yacov is offline macro from word to excel Windows 10 macro from word to excel Office 2016
Competent Performer
macro from word to excel
 
Join Date: Oct 2019
Posts: 139
yacov is on a distinguished road
Default

https://www.msofficeforums.com/word/...-comments.html

this one of Macro Mr. Guessed has done greate work for me. but my computer fell to bring large table from excel to Word.
Reply With Quote
  #4  
Old 08-04-2021, 02:14 AM
p45cal's Avatar
p45cal p45cal is offline macro from word to excel Windows 10 macro from word to excel Office 2019
Expert
 
Join Date: Apr 2014
Posts: 867
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default

None of the code in msg#6 of that thread will work in Excel.
Best attach an Excel file with a sample of the text moved to it from Word, then explain what you want the macro to do…
Otherwise, it may be an idea to continue in that thread as Guessed will probably have a better idea of what you need.
Reply With Quote
  #5  
Old 08-04-2021, 02:42 AM
yacov yacov is offline macro from word to excel Windows 10 macro from word to excel Office 2016
Competent Performer
macro from word to excel
 
Join Date: Oct 2019
Posts: 139
yacov is on a distinguished road
Default

Thanks anyway, just one more question before I give up on the matter. Word and Axcel only work with one cpu core?
Do you think the reason I am unable to move a table with 24,000 rows from axcel to Word is an old cpu, or is it beyond the capabilities of the software itself. (My computer is 5-6 years old).
Reply With Quote
  #6  
Old 08-04-2021, 03:16 AM
p45cal's Avatar
p45cal p45cal is offline macro from word to excel Windows 10 macro from word to excel Office 2019
Expert
 
Join Date: Apr 2014
Posts: 867
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default

24000 rows of data doesn't sound too much to me. 6 years old computer should easily be able to handle it.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
macro from word to excel Trying to combine Word documents using Excel macro rotunda Word VBA 6 06-14-2021 10:42 AM
Macro to put 1 word of a MS Word file in 1 cell of a Word or Excel Table Singh_Edm Word VBA 6 11-13-2015 08:48 PM
macro from word to excel Excel Macro finding a specific word ducky831 Excel Programming 3 09-17-2015 01:36 PM
macro from word to excel Macro to determine if word or excel application is being used Catty Word VBA 2 04-01-2014 08:13 PM
Merging word files from excel macro hklein Excel Programming 0 08-05-2011 02:27 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:56 PM.


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