Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 05-13-2022, 03:41 AM
Mattc1978 Mattc1978 is offline run vba script in word for removing certain characters Windows 10 run vba script in word for removing certain characters Office 2019
Novice
run vba script in word for removing certain characters
 
Join Date: May 2021
Posts: 13
Mattc1978 is on a distinguished road
Default

Hi Paul,

When the template is populated and a document is created, the document is a doc.x, I have to save as a doc. to remove the active fields. The hangover from the active fields is the brackets, speech marks, *, etc. The macro I hope will remove all of these leaving only the inputs text-wise from the eform. When the eform populates with the text it defaults to a font that can't be used for neurodiversity reasons (dyslexia) and corporate continuity. So I have to manually change to Arial using CTRL A then change to Arial. The form is the quality assured and then posted as a PDF on a tablet, for firefighters to be read as a descriptor of a premises hazards, should they attend a fire there.
If you know of a way to bulk remove empty rows and columns that haven't had input from the eform without using Kutools plus, then that would be amazing. The final bit is to remove anywhere with the word info: if there was nothing pulled through from the eform to populate that row and in turn now being blank delete said row. Many Thanks Matt
Reply With Quote
 

Tags
ctrlh, dunce, vba



Similar Threads
Thread Thread Starter Forum Replies Last Post
run vba script in word for removing certain characters Visual basic Word Script To Remove Specific Areas of a Word Doc mackied Word VBA 9 07-30-2017 03:10 PM
run vba script in word for removing certain characters Removing characters from a cell tonydoneese Excel 4 01-12-2016 07:41 AM
Strange Characters appear when selecting SHOW ALL NON PRINTING CHARACTERS ann Amber Word 1 08-01-2015 08:06 PM
Junk characters (box-like characters) in Word file Sashikala Word 1 04-20-2010 02:03 PM
Removing data between two characters Voodoo Child Excel 1 11-26-2009 01:39 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:41 PM.


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