Description
Generate a standard sitemap file with a VBA macro
https://www.inventorybigdata.com/wp-content/uploads/tools/List CB Sitemap.xlsx
Use last version of CB main VBA tool. Down last CB main.xlsm file. Open it
Open “List CB Sitemap.xlsx” launch line with Crtl+Shit+Z
or launch automatically with CB main and daily planified task
Example of automatic sitemap with Excel VBA macro :
<loc>https://www.beelicense.com/</loc>
<priority>1.00</priority>
</url>
<loc>https://www.beelicense.com/contact.html</loc>
<lastmod>2021-02-01</lastmod>
<priority>0.80</priority>
</url>
<loc>https://www.beelicense.com/index.html</loc>
<lastmod>2021-02-02</lastmod>
<priority>0.80</priority>
</url>
<loc>https://www.beelicense.com/lesseropenbeelicensev1-3_1.pdf</loc>
<lastmod>2021-01-14</lastmod>
<priority>0.60</priority>
</url>
</urlset>
Here is my sitemap generator written in Excel VBA
How to extract data from a website into an Excel spreadsheet
How to link data on a website
benefits of static sites
how to layer dynamic script
use a dynamic range in VBA
way you can use to create dynamic hyperlinks