AnalystCave

Passionate #Excel, #VBA, #Programming and #Analytics expert. Learn advanced #VBA and #Excel tips and tricks! Creator of the VBA Multithreading Tool

[AnalystCave @AnalystCave]

VBA to Python – 10 Simple Python vs VBA Examples #VBA, #Excel https://t.co/s4rJkWM7ve

[AnalystCave @AnalystCave]

@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

[AnalystCave @AnalystCave]

Office Scripts vs VBA – Microsoft’s take on VBA in 2022 #VBA #Excel
https://t.co/r06jLkpIOQ

[AnalystCave @AnalystCave]

@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 :).

[AnalystCave @AnalystCave]

Excel VBA Fuzzy Match text against a table #VBA, #Excel https://t.co/hr2irSeaDE

[AnalystCave @AnalystCave]

How to create a Twitter Power BI dashboard (with Azure) #VBA, #Excel https://t.co/n0QAM1jCcU

[AnalystCave @AnalystCave]

Get Google Maps address coordinates (latitude & longitude) in Excel VBA #VBA, #Excel https://t.co/GC1lQcyppr

[AnalystCave @AnalystCave]

Shorter VBA code! #VBA, #Excel https://t.co/pxBkiKFPx1

[AnalystCave @AnalystCave]

VBA Substring vs Excel Substring – How to get a Substring in Excel? #VBA, #Excel https://t.co/IkUb5gjNiS

[AnalystCave @AnalystCave]

Excel VBA Calculate distance between two addresses or coordinates #VBA, #Excel https://t.co/O1Mftvhu19

[AnalystCave @AnalystCave]

AutoFit Excel Rows and Columns #VBA, #Excel https://t.co/xdxzXxxPCX

[AnalystCave @AnalystCave]

Making proper VBA Comments #VBA, #Excel https://t.co/UYdPBVg1wP

[AnalystCave @AnalystCave]

Automatically save Lync conversations (when feature is blocked) #VBA, #Excel https://t.co/fDyZtKQn7t

[AnalystCave @AnalystCave]

VBA VLOOKUP – Using VLOOKUP in VBA #VBA, #Excel https://t.co/rRnwe9Ecp3

[AnalystCave @AnalystCave]

Working with XML files in VBA (VBA XML) #VBA, #Excel https://t.co/Q58FrnR98V

[AnalystCave @AnalystCave]

How to unhide sheets in Excel? Unhide all Sheets in Excel VBA #VBA, #Excel https://t.co/0sjD9A6Dqz

[AnalystCave @AnalystCave]

Writing files in VBA (txt, xml, csv, binary) #VBA, #Excel https://t.co/y5v3AdOrCK

[AnalystCave @AnalystCave]

Microsoft Excel Shortcut Keys #VBA, #Excel https://t.co/UbyLG4EF5Y

[AnalystCave @AnalystCave]

Excel VBA Cheat sheet #VBA, #Excel https://t.co/1D5h650Roh

[AnalystCave @AnalystCave]

Excel Pivot Table Tabular layout #VBA, #Excel https://t.co/FvPB2WHYfZ