Category: xlGenie

These posts will focus on my insights into the proper use of Excel VBA for development. It will also showcase my collection of Excel VBA tools.

Expanded Topic Search for Index and Match

Here is a Topic Search that identifies various resources for Index and Match.

This is a reposting of an earlier report. This new report integrates results from the Ordinal Google Search along with results from Google Image Searching.

As of yet, reporting on YouTube finds, does not include and detailed metadata about the YouTube.

Some links are well known and some are not so well known.

My topic search report begins with a list of search strings which are passed individually to Google Search.

The resulting Google source page is captured and parsed for each search string.

There are three sub reports that are extracted from the Google source page:

  1. Landing page for each discovered URL
  2. Title for each discovered URL
  3. List of Google suggested search terms (Search terms are not returned by Google Image search)

Once the list of search terms has been processed, then a secondary process is executed to aggregate the collection of sub reports that were generated for each of the input search terms.

Collection of URLs – landing pages listed by the number of occurrences for the individual search strings. Scanning this list of landing pages can bring to light new resources. Note that since this is PDF document – each URL is a hyperlink. Some of the links listed in the search string count PDF may not function because I have prefixed “www.” to the landing URL. This prefix may need to be removed.

Index and Match Search_String_CountsDownload

Collection of Direct URLs – details of each discovered URL, giving its title and identifying the search string that returned the URL. Again, note this is a PDF document hence the URLs are hyperlinks. Double click and your browser will open to the web page.

Index and Match Direct_URLsDownload

Collection of Google Suggested Search Terms – note that the reports presented here made use of this feature to expand the original search!

Google Suggestions Index and MatchDownload

The workbook that was the source of the other reports is included here in case the user would like to generate focused reports

Index and MatchDownload

Topic Search Excel Advanced Filter

Here is a Topic Search that identifies various resources for the Excel Advanced Filter

Some are well known and some are not so well known.

My topic search report begins with a list of search strings which are passed individually to Google Search.

The resulting Google source page is captured and parsed for each search string.

There are three sub reports that are extracted from the Google source page:

  1. Landing page for each discovered URL
  2. Title for each discovered URL
  3. List of Google suggested search terms

Once the list of search terms has been processed, then a secondary process is executed to aggregate the collection of sub reports that were generated for each of the input search terms.

Collection of URLs – landing pages listed by the number of occurrences for the individual search strings. Scanning this list of landing pages can bring to light new resources. Note that since this is PDF document – each URL is a hyperlink. Some of the links listed in the search string count PDF may not function because I have prefixed “www.” to the landing URL. This prefix may need to be removed.

Advanced Filter Search_String_CountsDownload

Collection of Direct URLs – details of each discovered URL, giving its title and identifying the search string that returned the URL. Again, note this is a PDF document hence the URLs are hyperlinks. Double click and your browser will open to the web page.

Advanced Filter Direct_URLsDownload

Collection of Google Suggested Search Terms – note that the reports presented here made use of this feature to expand the original search!

Google Suggestions Advanced FilterDownload

The workbook that was the source of the other reports is included here in case the user would like to generate focused reports.

Advanced FilterDownload

Topic Search that identifies various resources for Index and Match.

Some are well known and some are not so well known.

My topic search report begins with a list of search strings which are passed individually to Google Search.

The resulting Google source page is captured and parsed for each search string.

There are three sub reports that are extracted from the Google source page:

  1. Landing page for each discovered URL
  2. Title for each discovered URL
  3. List of Google suggested search terms

Once the list of search terms has been processed, then a secondary process is executed to aggregate the collection of sub reports that were generated for each of the input search terms.

Collection of URLs – landing pages listed by the number of occurrences for the individual search strings. Scanning this list of landing pages can bring to light new resources. Note that since this is PDF document – each URL is a hyperlink. Some of the links listed in the search string count PDF may not function because I have prefixed “www.” to the landing URL. This prefix may need to be removed.

Index and Match Search_String_CountsDownload

Collection of Direct URLs – details of each discovered URL, giving its title and identifying the search string that returned the URL. Again, note this is a PDF document hence the URLs are hyperlinks. Double click and your browser will open to the web page.

Index and Match Direct_URLsDownload

Collection of Google Suggested Search Terms – note that the reports presented here made use of this feature to expand the original search!

Google Suggestions Index and MatchDownload

The workbook that was the source of the other reports is included here in case the user would like to generate focused reports.

Index and MatchDownload

Topic Search Parse Excel Formulas

Here is a Topic Search that identifies various resources for Parsing Excel Formulas.

Some are well known and some are not so well known.

My topic search report begins with a list of search strings which are passed individually to Google Search.

The resulting Google source page is captured and parsed for each search string.

There are three sub reports that are extracted from the Google source page:

  1. Landing page for each discovered URL
  2. Title for each discovered URL
  3. List of Google suggested search terms

Once the list of search terms has been processed, then a secondary process is executed to aggregate the collection of sub reports that were generated for each of the input search terms.

Collection of URLs – landing pages listed by the number of occurrences for the individual search strings. Scanning this list of landing pages can bring to light new resources. Note that since this is PDF document – each URL is a hyperlink. Some of the links listed in the search string count PDF may not function because I have prefixed “www.” to the landing URL. This prefix may need to be removed.

Excel VBA Parse Formulas Search_String_CountsDownload

Collection of Direct URLs – details of each discovered URL, giving its title and identifying the search string that returned the URL. Again, note this is a PDF document hence the URLs are hyperlinks. Double click and your browser will open to the web page.

Excel VBA Parse Formulas Direct_URLsDownload

Collection of Google Suggested Search Terms – note that the reports presented here made use of this feature to expand the original search!

Google Suggestions for Excel VBA Parse FormulasDownload

The workbook that was the source of the other reports is included here in case the user would like to generate focused reports.

Excel VBA Parse FormulasDownload

Topic Search Excel VBA Memory Leaks

Here is a Topic Search that identifies various resources for identifying and controlling Excel VBA memory leaks

Some are well known and some are not so well known.

My topic search report begins with a list of search strings which are passed individually to Google Search.

The resulting Google source page is captured and parsed for each search string.

There are three sub reports that are extracted from the Google source page:

  1. Landing page for each discovered URL
  2. Title for each discovered URL
  3. List of Google suggested search terms

Once the list of search terms has been processed, then a secondary process is executed to aggregate the collection of sub reports that were generated for each of the input search terms.

Collection of URLs – landing pages listed by the number of occurrences for the individual search strings. Scanning this list of landing pages can bring to light new resources. Note that since this is PDF document – each URL is a hyperlink. Some of the links listed in the search string count PDF may not function because I have prefixed “www.” to the landing URL. This prefix may need to be removed.

Excel VBA Memory Leaks Search_String_CountsDownload

Collection of Direct URLs – details of each discovered URL, giving its title and identifying the search string that returned the URL. Again, note this is a PDF document hence the URLs are hyperlinks. Double click and your browser will open to the web page.

Excel VBA Memory Leaks Direct_URLsDownload

Collection of Google Suggested Search Terms – note that the reports presented here made use of this feature to expand the original search!

Google Suggestions Excel VBA Memory LeaksDownload

The workbook that was the source of the other reports is included here in case the user would like to generate focused reports.

Excel VBA Memory LeaksDownload

Topic Search XLOOKUP

Here is a Topic Search that identifies various resources for XLOOKUP.

Some well known and some not so well known.

My topic search report begins with a list of search strings which are then passed individually to Google Search.

The resulting Google source page is captured and parsed for each search string.

There are three sub reports that are extracted from the Google source page:

  1. Landing page for each discovered URL
  2. Title for each discovered URL
  3. List of Google suggested search terms

Once the list of search terms has been processed, then a secondary process is executed to aggregate the collection of sub reports that were generated for each of the input search terms.

Collection of URLs – landing pages listed by the number of occurrences for the individual search strings. Scanning this list of landing pages can bring to light new resources. Note that since this is PDF document – each URL is a hyperlink. Some of the links listed in the search string count PDF may not function because I have prefixed “www.” to the landing URL. This prefix may need to be removed.

XLOOKUP Search_String_CountsDownload

Collection of Direct URLs – details of each discovered URL, giving its title and identifying the search string that returned the URL. Again, note this is a PDF document hence the URLs are hyperlinks. Double click and your browser will open to the web page.

XLOOKUP Direct_URLsDownload

Collection of Google Suggested Search Terms – note that the reports presented here made use of this feature to expand the original search!

XLOOKUP SuggestionsDownload

The workbook that was the source of the other reports is included here in case the user would like to generate focused reports.

XLOOKUPDownload

Topic Search Learn Excel VBA

The key to automating Microsoft Excel depends on a mastery of Excel VBA.

Here is a Topic Search that identifies various resources for learning Excel VBA.

Some well known and some not so well known.

My topic search report begins with a list of search strings which are then passed individually to Google Search.

The resulting Google source page is captured and parsed for each search string.

There are three sub reports that are extracted from the Google source page:

  1. Landing page for each discovered URL
  2. Title for each discovered URL
  3. List of Google suggested search terms

Once the list of search terms has been processed, then a secondary process is executed to aggregate the collection of sub reports that were generated for each of the input search terms.

The composite reports are presented here.

Collection of URLs – landing pages listed by the number of occurrences for the individual search strings. Scanning this list of landing pages can bring to light new resources. Note that since this is PDF document – each URL is a hyperlink. Some of the links listed in the search string count PDF may not function because I have prefixed “www.” to the landing URL. This prefix may need to be removed.

Learn Excel VBA Search_String_CountsDownload

Collection of Direct URLs – details of each discovered URL, giving its title and identifying the search string that returned the URL. Again note this is a PDF document hence the URLs are hyperlinks. Double click and your browser will open to the web page.

Learn Excel VBA Direct_URLsDownload

Collection of Google Suggested Search Terms – note that the reports presented here made use of this feature to expand the original search three times!

Google Suggestions for Learn Excel VBADownload

The workbook that was the source of the other reports is included here in case the user would like to generate a more focused reports.

Learn Excel VBADownload