Hacking VBA to support native scripting runtime with no COM dependencies 2 months ago (github.com) 10 comments n013 Reply Add to library moron4hire 2 months ago This will be really useful for my coworkers who get stuck in SCIFs with nothing but Excel available to them. password4321 2 months ago Also: https://github.com/PerditionC/VBAChromeDevProtocolVBA (Excel) based wrapper for Chrome Developer Protocol (CDP) - sorta a VBA version of Puppeteer/Selenium blargthorwars 2 months 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 2 months ago But what if i want to debug my code? blargthorwars 2 months 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 3 replies → n013 2 months 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 2 months ago This looks so useful.
moron4hire 2 months ago This will be really useful for my coworkers who get stuck in SCIFs with nothing but Excel available to them. password4321 2 months ago Also: https://github.com/PerditionC/VBAChromeDevProtocolVBA (Excel) based wrapper for Chrome Developer Protocol (CDP) - sorta a VBA version of Puppeteer/Selenium
password4321 2 months ago Also: https://github.com/PerditionC/VBAChromeDevProtocolVBA (Excel) based wrapper for Chrome Developer Protocol (CDP) - sorta a VBA version of Puppeteer/Selenium
blargthorwars 2 months 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 2 months ago But what if i want to debug my code? blargthorwars 2 months 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 3 replies → n013 2 months 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.
cyanydeez 2 months ago But what if i want to debug my code? blargthorwars 2 months 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 3 replies → n013 2 months 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.
blargthorwars 2 months 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 3 replies →
n013 2 months 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.
This will be really useful for my coworkers who get stuck in SCIFs with nothing but Excel available to them.
Also: https://github.com/PerditionC/VBAChromeDevProtocol
VBA (Excel) based wrapper for Chrome Developer Protocol (CDP) - sorta a VBA version of Puppeteer/Selenium
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
But what if i want to debug my code?
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
End Sub
3 replies →
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.
This looks so useful.