Tag: VBA

VBA Function vs VBA Sub
Excel, MS Office, Outlook, PowerPoint, Word

Excel VBA Function vs VBA Sub – Excel Functions and Procedures

A VBA Function can accept parameters and return results. Functions, however, can’t be executed directly. On the other hand a VBA Sub procedure can be executed directly and can also accept parameters. Procedures, however, do not return values. We often use Subs and Functions often not thinking about their true potential and how much we […]

VBA Web Scraping Kit
Excel, MS Office, Outlook, PowerPoint, Web, Web Scraping, Word

Web Scraping Kit – use Excel to get that Web data

I am proud to present the next Kit coming from AnalystCave.com! The Web Scraping Kit is a simple kit for VBA Web Scrapers, contains a set of ready examples for different scraping scenarios. The kit is equipped with several tools letting you leverage HTTP GET&POST, IE, proxies, XPath, Regex and more Web Scraping tools. Get […]