Hi All,
I'm new to using vba in word but have some practice with vba in excel.
That being said I have no code to offer up for anyone to look at only
what I need to get done via VBA if possible. Oh, and thanks tons in
advance for anything that will help or at least point me in the right
direction.

We have over 100 stores and a coworker of mine is creating forms using
acrobat 8. These stores will in turn email the XML file to their DM's
to populate an Xl workbook. Useing vba is there a way I can loop thru
changing the root name , basiclly find and replace, and then save the
XML as the root name. But it would be great if the macro could use
another document or spreasheet with the store names, or even the names
nested within the macro it self.

If I wasn't clear enough, which I'm usually not, I answer questions as
best as I can.

Again Thanks for any help.