The best online resource for all your Excel & VBA requirements

xlDynamic.com Home Page

Create a Table of Contents This code creates/updates a Table of Contents for a specific workbook.

This is a Microsoft Office Visual Basic for Applications Discussion Forum and Code Center

Excel VBA || Learn what is VBA and lots more. Also get access to the excel VBA programming Code for how to create a message box, input box, etc. Read on.

An update to the original concept that allows us to Refresh Power Queries with VBA. This approach will ONLY update Power Queries.

Spotify has a massive music database, and in this article we're going to look at how to connect to Spotify using Power Query.

Learn more about: Power Query M function reference

Best practices when working with Power Query

Power Query is used to filter, combine, and mash-up data from one or more supported data sources.

Glossary of terms for Visual Basic for Applications (VBA).

Glossary of terms for Visual Basic Editor (VBE).

Beautiful UI components and templates by the creators of Tailwind CSS.

Self-documenting makefiles · GitHub

Python Enhancement Proposals (PEPs)

A very opinionated set of tools and practices for my Python projects.

Modern JavaScript Tutorial: simple, but detailed explanations with examples and tasks, including: closures, document and events, object oriented programming and more.

JavaScript playground for macOS, Windows and Linux. Write and run code with instant feedback and access to Node.js and browser APIs.

A few tips on using bootstrap 5 popovers in Shiny

Grow wiser and retain books better: Readwise sends you a daily email resurfacing your best highlights from Kindle, Instapaper, iBooks, and more.

Explore Terraform product documentation, tutorials, and examples.

How to split up your large, complex, frontend codebases into simple, composable, independently deliverable apps.

Typer, build great CLIs. Easy to code. Based on Python type hints.

Access the documentation and tutorials for our Cloud universes to deploy and use our solutions.

Characteristics of microservices, best practices of microservice architecture, and tips for developers.

null

OpenAPI.tools is a comprehensive and open source list of resources for developers working with Open API.