Word

Scrape Google Search Results to CSV
Excel, Google API, MS Office, Outlook, PowerPoint, Web, Web Scraping, Word

Scrape Google Search Results to CSV using VBA

Google is today’s entry point to the world greatest resource – information. If something can’t be found in Google it well can mean it is not worth finding. Similarly SEO experts blog and write about how to optimize your web pages to rank best in Google Search results often ignoring other search engines which contribution […]

VBA ParamArray
Excel, MS Office, Outlook, PowerPoint, Tip of the Day, Word

The VBA ParamArray for a dynamic list of VBA arguments

Today’s VBA Tip of the Day concerns dynamic parameter declaration via the VBA ParamArray. When declaring Functions/Procedures in some cases you may need to specify Optional arguments. Let’s say we want to write a procedure that works similarly as other procedures you know natively from Excel like SUM: Now how would you create such a […]