VBA Excel Tutorial: Easy Step-by-Step Guide Exciting New Features for HTML, XML Sitemaps and More
Hey there!
Check out the exciting new version 6.2.4! The spun folder now has just the text files you need. I’ve updated the `template.html` to include placeholders for both the sitemap domain and footer.
In the new Excel file, you’ll find the Add-In ribbon tab with a button to run the macro. Once you hit the button, the macro will start processing the files in the main folder. After it’s done, make sure to review the country file—it should now have the sitemap and town links with the correct domains extracted from the Excel sheet.
The sitemap still includes all the headings and links, and we’ve also added an XML file for Google Search Console.
Let me know if this meets your expectations!
Best,
MBA