ExportFileFilterByIndexList: VBA code to filter Blogger XML Backup/Export file based on Entry Index List text file

Last updated on 25 Feb. 2024

25 Feb. 2024 Update: I rarely use the software covered in this post now. To see the current software for creating Blogger blogbooks that I use, please visit: Short User Guide to creating Blogger Blogbooks from Backup/Export File using ExportFileFilterAndGenBook and another VBA projects' macros/code (free and open source), https://ravisiyermisc.blogspot.com/2023/09/short-user-guide-to-creating-blogger.html . 

Also see: Ported ExportFileFilterAndGenBook and ExportFileFilterByIndexList from VBA to BlogBackupToBook VB.Net single project of Visual Studio 2022 Community Edition, https://ravisiyermisc.blogspot.com/2023/09/ported-exportfilefilterandgenbook-from.html .

Quick Info

Top-level folder share: ExportFileFilterByIndexList,  https://drive.google.com/drive/folders/1t7IPjwuU791t58EJOZEmxrSbWeFBHiSF?usp=drive_link

Version v3 sub-folder: https://drive.google.com/drive/folders/1aPLQQV6mWOelBBeiIyK9tIrV7k-qk7ZE?usp=drive_link

v3/Info.txt: https://drive.google.com/file/d/1JaJcwLPuoiZJP54hjWEiZj1vsLGJc0Zg/view?usp=drive_link

Version v2 sub-folder: https://drive.google.com/drive/folders/137f2aJoOyXtRriLJsXTukj5RTvRnlLtI?usp=drive_link

v2/Info.txt: https://drive.google.com/file/d/13FNK_qZggMYpwIXLW8jINsTSs_cZB0M-/view?usp=drive_link

v2/RunFilterPages sub-folder:  https://drive.google.com/drive/folders/1pktyfO0D4YDjtHD0QDA8MY2lPJOLew6V?usp=drive_link

v2/RunFilterPages/Runinfo.txt: https://drive.google.com/file/d/18P5zWMUF2mO70qGNqqYFUyufayRgaAAR/view?usp=drive_link

Version v1 sub-folder:  https://drive.google.com/drive/folders/1qb8RABO4pqH3A2q-zRUq6sUI6RYz78V_?usp=drive_link

v1/Info.txt: https://drive.google.com/file/d/1RyUm1Zd_WmG8jdz8X3-bG6AOMh2dtp4H/view?usp=drive_link

End Quick Info

5 Sep. 2023 Update

Version v3 fixes a typo in caption of Top Level Run Options form.

Top Level Run Options Form

End-Update 5 Sep. 2023

3 Sep. 2023 Update

At times, we may want to remove some pages/posts from the Blogger XML Backup/Export file, and use the modified file as input to Generate HTML blog book function of ExportFileFilterAndGenBook to create blog books optionally matching some search strings but none of the blogbooks created this way, having the pages/posts excluded from the Blogger XML Backup/Export file. [Ref: ExportFileFilterAndGenBook: Filter Blogger XML Backup file based on date range, produce HTML Blogbook filtered by search string, Split it and Generate Contents Links (VBA project),  https://ravisiyermisc.blogspot.com/2023/08/exportfilefilterandgenbook-vba-code-to.html .]

In particular, some of my blogs have a few pages with very long lists of posts. I would prefer to not have these pages with very long lists of posts to be part of some blogbooks I create.

How to achieve this using a combination of ExportFileFilterAndGenBook and ExportFileFilterByIndexList projects is covered in the Runinfo file here (link shared earlier but repeated here):  https://drive.google.com/file/d/18P5zWMUF2mO70qGNqqYFUyufayRgaAAR/view?usp=drive_link, which describes the run that created the data files in the associated v2/RunFilterPages sub-folder of the ExportFileFilterByIndexList project, https://drive.google.com/drive/folders/1pktyfO0D4YDjtHD0QDA8MY2lPJOLew6V?usp=drive_link.

End-Update 3 Sep. 2023

This ExportFileFilterByIndexList project takes a Blogger blog backup/export XML file and an Index list text file as input and produces an output filtered file of XML entries of posts and pages listed in the Index list along with some header XML elements and all comments. This output file can then be provided as input to ExportFileFilterAndGenBook project code to generate a blog book of these posts and pages and any comments associated with them.