Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 08-28-2014, 07:28 AM
caj1980 caj1980 is offline Macro to replace SSN in all files within a folder Windows 7 64bit Macro to replace SSN in all files within a folder Office 2010 64bit
Novice
Macro to replace SSN in all files within a folder
 
Join Date: Aug 2014
Posts: 6
caj1980 is on a distinguished road
Default Macro to replace SSN in all files within a folder

I am looking for help creating a macro that will replace all social security numbers in each document in a folder. Search string would be "???-??-" to be replaced with "XXX-XX-" so that we keep the last 4 of the SSN. I need to be able to run the macro against a folder of multiple documents with each document containing multiple instances of the SSN to be replaced. I have found some solutions on-line in various places but this is all new to me. I am not a programmer! We currently spend about 2 hours a day manually replacing all of the SSN's in each document.



THANK YOU SO MUCH!!!
Reply With Quote
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to replace SSN in all files within a folder macro to change name of files in a folder in order expert4knowledge Word VBA 5 07-10-2014 03:54 PM
Remove title property from all files in a folder konopca Word VBA 2 12-04-2012 10:54 AM
Macro to replace SSN in all files within a folder Move files from one folder to another obasanla Word 1 09-28-2012 04:42 PM
Macro to replace SSN in all files within a folder Word Macro - change date in footer for all files in a folder patidallas22 Word VBA 2 03-09-2012 08:14 AM
Adding a field to a folder of PDF files. Balliol Windows 0 11-22-2009 02:02 PM

Other Forums: Access Forums

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