View Single Post
 
Old 08-13-2015, 02:54 AM
roderh roderh is offline Windows 7 64bit Office 2010 32bit
Novice
 
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, 16 views)
File Type: xlsx List of abbreviations (example).xlsx (8.7 KB, 15 views)
File Type: xlsx Outputfile (example).xlsx (8.7 KB, 13 views)
Reply With Quote