Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-13-2015, 02:54 AM
roderh roderh is offline VBA: Replacement of words based on a list Windows 7 64bit VBA: Replacement of words based on a list Office 2010 32bit
Novice
VBA: Replacement of words based on a list
 
Join Date: May 2014
Posts: 17
roderh is on a distinguished road
Default VBA: Replacement of words based on a list

Hi,



my problem is, that i want to replace some words within files based on a list of abbreviations provided by an other file.

The VBA should open the input-files, create corresponding output-files, write the words, that are not to be abbreviated, as well as the replacements provided by the abbreviations-file into the output-files (without altering other cells) and save them. All files will be in the same directory.

Please have a look at the attached the example-files:

It would be very nice, if someone could help me.
Thank you in advance!
Attached Files
File Type: xlsx Inputfile (example).xlsx (10.5 KB, 13 views)
File Type: xlsx List of abbreviations (example).xlsx (8.7 KB, 12 views)
File Type: xlsx Outputfile (example).xlsx (8.7 KB, 10 views)
Reply With Quote
  #2  
Old 09-06-2015, 11:12 AM
charlesdh charlesdh is offline VBA: Replacement of words based on a list Windows 7 32bit VBA: Replacement of words based on a list Office 2010 32bit
Expert
 
Join Date: Apr 2014
Location: Mississippi
Posts: 382
charlesdh is on a distinguished road
Default

Cross post...it appears some one is trying to help. Sorry we did not respond. But,
it would have been nice that you let us know.

http://www.excelforum.com/excel-prog...on-a-list.html
Reply With Quote
  #3  
Old 09-06-2015, 08:54 PM
roderh roderh is offline VBA: Replacement of words based on a list Windows 7 64bit VBA: Replacement of words based on a list Office 2010 32bit
Novice
VBA: Replacement of words based on a list
 
Join Date: May 2014
Posts: 17
roderh is on a distinguished road
Default

Yes, sorry, your are right.

Thankfully this problem is solved.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA: Replacement of words based on a list Macro to highlight a list of words bakerkr Word VBA 4 10-19-2017 02:23 PM
VBA: Replacement of words based on a list Automatic Words replacement psychologist Word VBA 3 11-22-2014 11:40 AM
VBA: Replacement of words based on a list Highlight Words from a Word List JSC6 Word VBA 1 09-30-2014 08:22 PM
VBA: Replacement of words based on a list Making a list of words in an article JohnR1948 Word 1 02-11-2013 04:36 PM
VBA: Replacement of words based on a list Making a list of the words in an article JohnR1948 Word VBA 1 02-11-2013 04:14 PM

Other Forums: Access Forums

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