Hacking VBA to support native scripting runtime with no COM dependencies

https://github.com/ECP-Solutions/ASF

24•n013•1mo ago

Comments

moron4hire•1mo ago

This will be really useful for my coworkers who get stuck in SCIFs with nothing but Excel available to them.

password4321•1mo ago

Also: https://github.com/PerditionC/VBAChromeDevProtocol

VBA (Excel) based wrapper for Chrome Developer Protocol (CDP) - sorta a VBA version of Puppeteer/Selenium

blargthorwars•1mo ago

Friendly reminder for MS Access fiends:

It's ok to store code in tables and then pass it to VBA for evaluation via Eval, or to ASF via the engine.Compile

cyanydeez•1mo ago

But what if i want to debug my code?

blargthorwars•1mo ago

Great question! Programmatically copy your snippet to a module, then call it:

Public Sub AppendCode() Dim cm As Object Set cm = Application.VBE.VBProjects(1).VBComponents("GeneratedLogic").CodeModule

    cm.InsertLines cm.CountOfLines + 1, _
        "Public Sub NewProc()" & vbCrLf & _
        "    MsgBox ""Dynamically added""" & vbCrLf & _
        "End Sub"

End Sub

mschuster91•1mo ago

I've written my fair share of evil shit in VBA.

But... what is effectively eval() just in VB? Yikes.

moron4hire•1mo ago

For the people who would be using this, they would almost never even have other people's code, say nothing of whether it's untrusted.

n013•1mo ago

Honestly, ASF is literally sandboxed. Objects cannot be injected in the runtime. Also, VBA Expressions is intentionally limited to receive and return VBA strings. So, the system is safe for execute code from (almost) anyone.

n013•1mo ago

You can inspect the AST in order to debug your code. For syntax highlighting, use tools like Notepad++ (ASF shares most of the syntax with Javascript). Each piece of code is commented, no obscure machine code.

fibers•1mo ago

This looks so useful.

OpenCiv3: Open-source, cross-platform reimagining of Civilization III

The Waymo World Model

How we made geo joins 400× faster with H3 indexes

Show HN: Look Ma, No Linux: Shell, App Installer, Vi, Cc on ESP32-S3 / BreezyBox

Monty: A minimal, secure Python interpreter written in Rust for use by AI

Unseen Footage of Atari Battlezone Arcade Cabinet Production

Show HN: I spent 4 years building a UI design tool with only the features I use

Microsoft open-sources LiteBox, a security-focused library OS

Dark Alley Mathematics

Sheldon Brown's Bicycle Technical Info

Hackers (1995) Animated Experience

Delimited Continuations vs. Lwt for Threads

Show HN: If you lose your memory, how to regain access to your computer?

PC Floppy Copy Protection: Vault Prolok

An Update on Heroku

What Is Ruliology?

How to effectively write quality code with AI

Why I Joined OpenAI

Show HN: ARM64 Android Dev Kit

Female Asian Elephant Calf Born at the Smithsonian National Zoo

Learning from context is harder than we thought

Show HN: R3forth, a ColorForth-inspired language with a tiny VM

I spent 5 years in DevOps – Solutions engineering gave me what I was missing

Introducing the Developer Knowledge API and MCP Server

Understanding Neural Network, Visually

I now assume that all ads on Apple news are scams

Zlob.h 100% POSIX and glibc compatible globbing lib that is faste and better

FORTH? Really!?

Show HN: Smooth CLI – Token-efficient browser for AI agents

WebView performance significantly slower than PWA