Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-12-2020, 08:04 PM
macropod's Avatar
macropod macropod is offline Extract Text from textboxes in converted PDFs Windows 7 64bit Extract Text from textboxes in converted PDFs Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by Cendrinne View Post
But how can I understand more in dept in Word VBA programming?
There are doubtless some good books and tutorials around but, since I don't use any of that stuff, I can't recommend any. All my VBA expertise is self-taught, though studying code that others have posted on different forums over the years has been a great help, too.
Quote:
Originally Posted by Cendrinne View Post
This is my typical Find and Replace programming (as a novice):


Selection.Find.ClearFormatting
Selection.Find.Replacement.ClearFormatting


With Selection.Find
.Text = "^13"
.Replacement.Text = "^p"
.Forward = False
.Wrap = wdFindStop
.Format = False
.MatchCase = False
.MatchWildcards = False
End With
Selection.Find.Execute Replace:=wdReplaceAll
Yes, that's typical macro-recorder code. The macro recorder's not much smarter than a box of rocks. For an idea of what's possible with Find/Replace coding, see: https://www.msofficeforums.com/140662-post2.html
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #2  
Old 05-12-2020, 08:27 PM
Cendrinne's Avatar
Cendrinne Cendrinne is offline Extract Text from textboxes in converted PDFs Windows 10 Extract Text from textboxes in converted PDFs Office 2013
Competent Performer
Extract Text from textboxes in converted PDFs
 
Join Date: Aug 2019
Location: Montreal Quebec Canada
Posts: 200
Cendrinne is on a distinguished road
Default Thank you. When I have more time, I'll take a look :)

Very sweet of you to guide me with script to analyze to understand


Cendrinne


Quote:
Originally Posted by macropod View Post
There are doubtless some good books and tutorials around but, since I don't use any of that stuff, I can't recommend any. All my VBA expertise is self-taught, though studying code that others have posted on different forums over the years has been a great help, too.

Yes, that's typical macro-recorder code. The macro recorder's not much smarter than a box of rocks. For an idea of what's possible with Find/Replace coding, see: https://www.msofficeforums.com/140662-post2.html
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Text in two textboxes guest_gast PowerPoint 5 03-26-2018 01:21 PM
Extract Text from textboxes in converted PDFs Format Multiple Textboxes Based On the Contents of One Text Box dmcgettigan Word VBA 1 02-27-2017 08:50 PM
Extract Text from textboxes in converted PDFs Replace text of textboxes tng Word VBA 1 12-22-2013 05:23 PM
My plain text post got converted to rich text in a reply, how to convert it back? david.karr Outlook 0 01-05-2012 09:46 AM
Extract Text from textboxes in converted PDFs Incoming Mail Converted to Text luke1438 Outlook 4 03-13-2011 07:47 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:37 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