Generate a sitemap for html static website with Excel VBA macro

Generate a site map for HTML static website with Excel macro in VBA

 

Category:

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 :

<urlset xmlns=”http://www.sitemaps.org/schemas/sitemap/0.9>
<url>
  <loc>https://www.beelicense.com/</loc>
  <priority>1.00</priority>
  </url>
<url>
  <loc>https://www.beelicense.com/contact.html</loc>
  <lastmod>2021-02-01</lastmod>
  <priority>0.80</priority>
  </url>
<url>
  <loc>https://www.beelicense.com/index.html</loc>
  <lastmod>2021-02-02</lastmod>
  <priority>0.80</priority>
  </url>
<url>
  <loc>https://www.beelicense.com/lesseropenbeelicensev1-3_1.pdf</loc>
  <lastmod>2021-01-14</lastmod>
  <priority>0.60</priority>
  </url>
  </urlset>

 

 

Reviews

There are no reviews yet.

Be the first to review “Generate a sitemap for html static website with Excel VBA macro”

Your email address will not be published. Required fields are marked *