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

	Inputfile (example).xlsx (10.5 KB, 16 views)
	List of abbreviations (example).xlsx (8.7 KB, 15 views)
	Outputfile (example).xlsx (8.7 KB, 13 views)