Speeding up a replace macro running through a long text

[_frudo]

if you provide the file itself, as well as what sTEXT and what sREPLACETEXT needs to be changed, I could solve this problem.

Thanks for your interest! You can find an example xml file here (2,7 MB ZIP):
https://upload.disroot.org/r/ofHPFsD...5nAw5oSeqt8Gg=

For this file, the first two lines in the macro would be

Public Const sTEXT = "k=""archaeological_site"""
Public Const sREPLACETEXT = "k=""site_type"""