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
A sitemap generator is a tool that creates a list of all the pages on a website and their relative hierarchy, which helps search engines understand the structure of the site.
Example of automatic sitemap with Excel VBA macro :
Creating a sitemap generator using Excel VBA can be a powerful tool for web developers. Not only does it help you understand the structure of a website, but it can also help you extract data from that site and link it to your own Excel spreadsheet. This can save time and increase efficiency in your workflow.
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
way you can use to create dynamic hyperlinks