I am trying to create a macro that would auto create XML files using a macro. The content would stay the same just need to change 1 line in the XML file. Below is one of the xml files and the URL needs to be changed from a list of 100 urls and then save the file as an xml file... Any help would be appreciated!
<?xml version="1.0" encoding="UTF-8"?>
<MineParams xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<StartURL>
<url>http://www.NEEDTOCHAGETHISURL.COM/(GETS ALL THE DATA FROM A LIST OF URLS)</url>
</StartURL>
<FieldList>
<DATAFIELD>
<type>Text</type>
<name>Company</name>
<xpath>HTML[0][ie9 ie js]\BODY[1][country-us logged-out ytype jquery]\DIV[1][lang-en]\DIV[4][ ]\DIV[2][container indexed-biz-archive]\DIV[2][clearfix layout-block layout-a scroll-map-container search-results-block]\DIV[0][column column-alpha ]\DIV[0][results-wrapper]\DIV[0][content]\UL[0][ylist ylist-bordered search-results]\LI[1][ ]\DIV[0][search-result natural-search-result biz-listing-large]\DIV[0][media-block clearfix media-block-large main-attributes]\DIV[1][media-story]\H3[0][search-result-title]\SPAN[0][indexed-biz-name]\A[0][biz-name]\</xpath>
<pattern>true</pattern>
<regex />
</DATAFIELD>
<DATAFIELD>
<type>Text</type>
<name>address</name>
<xpath>HTML[0][ie9 ie js]\BODY[1][country-us logged-out ytype jquery]\DIV[1][lang-en]\DIV[4][ ]\DIV[2][container indexed-biz-archive]\DIV[2][clearfix layout-block layout-a scroll-map-container search-results-block]\DIV[0][column column-alpha ]\DIV[0][results-wrapper]\DIV[0][content]\UL[0][ylist ylist-bordered search-results]\LI[1][ ]\DIV[0][search-result natural-search-result biz-listing-large]\DIV[1][secondary-attributes]\DIV[0][service-area]\</xpath>
<pattern>true</pattern>
<regex />
</DATAFIELD>
<DATAFIELD>
<type>Text</type>
<name>phone</name>
<xpath>HTML[0][ie9 ie js]\BODY[1][country-us logged-out ytype jquery]\DIV[1][lang-en]\DIV[4][ ]\DIV[2][container indexed-biz-archive]\DIV[2][clearfix layout-block layout-a scroll-map-container search-results-block]\DIV[0][column column-alpha ]\DIV[0][results-wrapper]\DIV[0][content]\UL[0][ylist ylist-bordered search-results]\LI[1][ ]\DIV[0][search-result natural-search-result biz-listing-large]\DIV[1][secondary-attributes]\SPAN[2][biz-phone]\</xpath>
<pattern>true</pattern>
<regex />
</DATAFIELD>
<DATAFIELD>
<type>Link_NextPage</type>
<name> → </name>
<xpath>HTML[0][ie9 ie js]\BODY[1][country-us logged-out ytype jquery]\DIV[1][lang-en]\DIV[4][ ]\DIV[2][container indexed-biz-archive]\DIV[2][clearfix layout-block layout-a scroll-map-container search-results-block]\DIV[0][column column-alpha ]\DIV[0][results-wrapper]\DIV[0][content]\DIV[1][search-pagination]\DIV[0][pagination-block clearfix]\UL[1][pagination-links]\LI[9][ ]\A[0][page-option prev-next]\</xpath>
<pattern>true</pattern>
<regex />
</DATAFIELD>
</FieldList>
<CategoryList />
<KeywordList />
</MineParams>
Bookmarks