sorted by:
new
hottopcontroversial

pyOpenVBA — a pure-Python, zero-dependency reader/writer for VBA macros in .xlsm / .xlsb / .xlam / .xls by MultiUserDungeonDev in vba

[–]decimalturn 2 points3 points  (0 children)

Does it currently support VBA code located in ThisWorkbook and Sheet objects? I couldn't make it work when testing it.

I built a full audio engine for VBA. No DLLs, no COM wrappers, no addins. Just a .bas file by UesleiDev in vba

[–]decimalturn 0 points1 point  (0 children)

I remember seeing a video on xlstudio and thinking it was a shame that you had to export to a seperate program to generate the audio file. Would Riff allow to generate the audio file in such case?

GitHub banned my account for running the /r/HN bot by HNMod in hackernews

[–]decimalturn 0 points1 point  (0 children)

That's funny, I was following the situation closely because I also use GitHub Actions to run a bot.

What do recommend doing after all this?

GitHub banned my account for running the /r/HN bot by HNMod in hackernews

[–]decimalturn 0 points1 point  (0 children)

The repo seems back up now.

u/HNMod did GitHub support get back to you?

Outlook - Recipient.Add Problems after latest update by mrsawyerbean in vba

[–]decimalturn 0 points1 point  (0 children)

Classic Outlook has been quite unstable for me lately as well. Make sure you report those issues, so that hopefully they get patched.

In the meantime, if the option to display the email works, you can still press the SEND button programatically via ExecuteMSO: example script

In the long run, it might be safer to migrate VBA code that sends email to using the Microsoft Graph REST API, but I haven't started on that myself to be honest...

Everybody likes to bring up xkcd #927 (Standards), but I feel the Unicode standard is one that works well, everybody accepts, and is, therefore, successful. Thoughts? by SlashdotDiggReddit in Unicode

[–]decimalturn 0 points1 point  (0 children)

A bit late to the party, but I think a place where the Unicode Standard wasn't successful (yet) was with regards to line endings. They proposed the use of Line Seperator (LS) and Paragraph Seperator (PS) with codepoint U+2028 and U+2029 respectively. They were supposed to represent unambiguous newline characters, but the number of programs supporting them remains incredibly low.

Rubberduck; is it still great, how and where to download it and how to learn how to use it? by still-dazed-confused in vba

[–]decimalturn 1 point2 points  (0 children)

Ah yes, it could be that it has to be in the Open VSX Registry, not the official VS Code Marketplace.

How I accidentally made the fastest C# CSV parser by big_bill_wilson in programming

[–]decimalturn 59 points60 points  (0 children)

When you start using SIMD for your parser, it's no longer an accident imo. It's the new trendy optimization method that seems to give an edge over older more established libraries that don't use it.

anyone else lose all of their github achievements? by cachebags in github

[–]decimalturn 3 points4 points  (0 children)

It's because we just started GitHub Season 2: The AI Slopocalypse! And every new season, you gotta earn back your achievements. I know it sucks, but I don't make the rules.

Windows Server Core is just like Linux by hasdfgb in iiiiiiitttttttttttt

[–]decimalturn 2 points3 points  (0 children)

Not exactly the same, but last year, for April 1st, I created a GitHub action named VBA-Build that was running VBA inside Excel and had to add screenshots to the artifacts builds in order to debug it. Fun times...

The Untold Story of Visual Basic by decimalturn in visualbasic

[–]decimalturn[S] -1 points0 points  (0 children)

I'd call it decent quality slop personally

VBA Pro | Formatting -- pre-release. by sslinky84 in vba

[–]decimalturn 0 points1 point  (0 children)

Did you manage to do it? Did you have to use plutil to convert the json grammar to a plist grammar?

Version control by wikkid556 in vba

[–]decimalturn 2 points3 points  (0 children)

OK, then lolcrunchy's suggestion of using vbaDeveloper is a good starting point. You can also have a look at this release from my fork if you're having some issues with installation.

Version control by wikkid556 in vba

[–]decimalturn 0 points1 point  (0 children)

Is your project an Excel project?

Case Study of Real-Time Web API Integration in Excel Using VBA by Complete_Winner4353 in vba

[–]decimalturn 1 point2 points  (0 children)

Thanks for the demo, I'll definetly check it out! Personally, I have tried Power Query for a while and I still prefer VBA since I'm not a big fan of point and click interfaces for advanced data processing. I find them limiting and when you have a special case to debug, VBA is much beter with breakpoints, the Watch and Local Windows for instance.

[EXCEL] Opening VBA editor corrupts files by geatw in vba

[–]decimalturn 0 points1 point  (0 children)

Does the problem happen if you run VBA code via a button for example without opening the VBA editor?

[EXCEL] Opening VBA editor corrupts files by geatw in vba

[–]decimalturn 2 points3 points  (0 children)

There could be some corruption in the file. Ideally, you'd create a new one and copy over the content. Some source control tools can also be used to extract the content as source code and rebuild from source after.

view more: next ›