AnalystCave

VBA to Python – 10 Simple Python vs VBA Examples #VBA, #Excel analystcave.com/vba-to-python-…

@ExcelAnalytics Precisely why VBA isn't the right solution for capturing web data anymore. Albeit I've built many solutions on it, I feel nowadays Python is just so much easier - and portable to Mac, Windows and Linux. On top of being able to use Selenium for browser interactions

Office Scripts vs VBA – Microsoft’s take on VBA in 2022 #VBA #Excel analystcave.com/office-scripts…

@ExcelAnalytics Totally agree there. For those use cases Power Automate Desktop is the way to go probably. I love, how, now there is a low code Microsoft Power tool for any imaginable use case :).

Excel VBA Fuzzy Match text against a table #VBA, #Excel analystcave.com/excel-vba-fuzz…

How to create a Twitter Power BI dashboard (with Azure) #VBA, #Excel analystcave.com/how-to-create-…

Get Google Maps address coordinates (latitude & longitude) in Excel VBA #VBA, #Excel analystcave.com/excel-get-geol…

Shorter VBA code! #VBA, #Excel analystcave.com/vba-shorter-vb…

VBA Substring vs Excel Substring – How to get a Substring in Excel? #VBA, #Excel analystcave.com/excel-substrin…

Excel VBA Calculate distance between two addresses or coordinates #VBA, #Excel analystcave.com/excel-calculat…

AutoFit Excel Rows and Columns #VBA, #Excel analystcave.com/autofit-excel-…

Making proper VBA Comments #VBA, #Excel analystcave.com/tip-day-making…

Automatically save Lync conversations (when feature is blocked) #VBA, #Excel analystcave.com/lync-automatic…

VBA VLOOKUP – Using VLOOKUP in VBA #VBA, #Excel analystcave.com/vba-vlookup-us…

Working with XML files in VBA (VBA XML) #VBA, #Excel analystcave.com/vba-xml-workin…

How to unhide sheets in Excel? Unhide all Sheets in Excel VBA #VBA, #Excel analystcave.com/unhide-sheets-…

Writing files in VBA (txt, xml, csv, binary) #VBA, #Excel analystcave.com/vba-write-file…

Microsoft Excel Shortcut Keys #VBA, #Excel analystcave.com/microsoft-exce…

Excel VBA Cheat sheet #VBA, #Excel analystcave.com/vba-cheat-shee…

Excel Pivot Table Tabular layout #VBA, #Excel analystcave.com/excel-tip-of-t…