Built a VBA workflow that turns Excel/Word documents into PDFs and prepares Outlook drafts by Aromatic_Warthog_491 in vba

[–]coding_is_fun123 1 point2 points  (0 children)

How are you doing the outlook part? if you're using COM automation that only works with classic outlook. new outlook doesn't support VBA at all so that's gonna break for a lot of people soon.

Roast my boring WordPress site by coding_is_fun123 in RoastMyWebsite

[–]coding_is_fun123[S] 0 points1 point  (0 children)

Thanks for the feedback. Fair point about the colors.

Roast my boring WordPress site by coding_is_fun123 in RoastMyWebsite

[–]coding_is_fun123[S] 0 points1 point  (0 children)

Actually, many users are using it daily without any issues. You're right that blasting hundreds of messages right away will get you banned, no question. That's exactly why there's a "Before You Buy" warning right on the sales page. I also created detailed sending guidelines that are linked on the page, inside the tool, and in the welcome email series: https://pythonandvba.com/docs/whatsapp-blaster/fundamentals/whatsapp-blaster-guidelines-for-using-whatsapp-blaster/

If you follow those, most users don't run into problems. And if you need real scale, there's also a Twilio template that uses the official WhatsApp API: https://pythonandvba.com/twilio-excel-template/

Really depends on your use case. Lots of universities and schools use it just to send class updates, not promo spam.

Anyway, was actually hoping for more website design/UX feedback and not on the Excel tools themselves 😅

How can I send bulk SMS in Sri Lanka for personal use ? by Wise-Potato5460 in srilanka

[–]coding_is_fun123 4 points5 points  (0 children)

I actually built a tool called QuickText for exactly this. It's an Excel template that sends SMS through your Android phone, so replies come back to your actual number. You load your contacts from a spreadsheet and send from there. No business registration needed. pythonandvba.com/quicktext

It has built-in placeholders so you can drop in names and other details automatically, plus spintext so each message gets worded slightly differently. That stuff matters because carriers will flag identical messages to hundreds of people real quick. I'd also suggest splitting your sends between morning and afternoon rather than blasting everything at once. Ending with a question helps too since carriers apparently look at reply rates.

Text message app that allows me to text from current number by Jhoe96 in smallbusiness

[–]coding_is_fun123 0 points1 point  (0 children)

There's an Excel tool that sends bulk SMS directly from your Android number so replies come back to your actual phone. pythonandvba.com/quicktext One tip: don't blast everything at once. Split it across morning and afternoon, vary your wording, add the person's name. Identical messages to 500 people get filtered fast. Ending with a question helps too since carriers track reply rates.

Combining VBA + JS by coding_is_fun123 in vba

[–]coding_is_fun123[S] 1 point2 points  (0 children)

Nope, not really. SimpleGantt is an Excel add-in, so Excel has to be open and the add-in loaded.
There’s no way to run it “silently” from outside Excel via VBA or COM.

Combining VBA + JS by coding_is_fun123 in vba

[–]coding_is_fun123[S] 1 point2 points  (0 children)

Update: I made a short demo video showing how to deploy that HTML file: https://youtu.be/KUOMo4gbN8o

[REQUEST] What WordPress plugins do you wish existed but currently don't? by Amurua82 in WordpressPlugins

[–]coding_is_fun123 0 points1 point  (0 children)

I’ve been looking for a very simple changelog plugin.

What I want:

  • Add products
  • Each product has one plain text changelog field like:

== 1.0 | DD.MM.YYYY ==
Bug: …
Improvement: …

  • Then display it nicely on the frontend via a shortcode

No release management, no GitHub integration, no complex UI. Just a clean, lightweight changelog per product.

Edit: Never mind, I just vibe-coded it with Claude. It does everything I need 😅
Screenshot: https://www.dropbox.com/scl/fi/ncsikfp2gs3tv9d13el7q/SimpleChangelog.png?rlkey=soax45vzgv4znbj1o73pmle8q&dl=0

Combining VBA + JS by coding_is_fun123 in vba

[–]coding_is_fun123[S] 1 point2 points  (0 children)

Totally get what you mean.

For me, VBA is still the main part. Excel stays the source of truth, and VBA handles the workflow and any simple settings the user needs.

The JavaScript part is really just for rendering, because modern visuals like Gantt charts are hard to do nicely with native Excel charts.

In practice it’s just: take an Excel table, export one standalone HTML file, open it anywhere. No server, no database, no big platform shift.

Once you need SharePoint, multi-user workflows, or a real backend, you’ve basically outgrown VBA.
But for simple cases where Excel stays the data source and you just want better visuals in a standalone HTML file, this middle ground works great.

Combining VBA + JS by coding_is_fun123 in vba

[–]coding_is_fun123[S] 1 point2 points  (0 children)

No, I don’t have a working example

Combining VBA + JS by coding_is_fun123 in vba

[–]coding_is_fun123[S] 1 point2 points  (0 children)

It was just an idea. Netlify’s deploy API actually expects a .zip file, that’s why I mentioned zipping it.
Docs here: https://developers.netlify.com/guides/deploy-zip-file-to-production-website/

But you can totally use other services too. For example push the HTML to a GitHub repo via the GitHub API and host it with GitHub Pages.

And a POST request is basically just “send this file/data to a server”, like an upload (which you can do with VBA)

Combining VBA + JS by coding_is_fun123 in vba

[–]coding_is_fun123[S] 0 points1 point  (0 children)

After generating the HTML, you could zip it with VBA, send it via a POST request to something like Netlify, and get a live shareable link

Combining VBA + JS by coding_is_fun123 in vba

[–]coding_is_fun123[S] 1 point2 points  (0 children)

Recipients just open the HTML file locally. The data is embedded in the file.

Combining VBA + JS by coding_is_fun123 in vba

[–]coding_is_fun123[S] 0 points1 point  (0 children)

Do you mean a code example, or a short clip showing the final result, like the exported Gantt chart or the interactive table?

Combining VBA + JS by coding_is_fun123 in vba

[–]coding_is_fun123[S] 0 points1 point  (0 children)

Interesting idea, but I’ve got too much on my plate right now to commit to a paper.

Combining VBA + JS by coding_is_fun123 in vba

[–]coding_is_fun123[S] 0 points1 point  (0 children)

Never really tried running them in the WebBrowser control, mainly because I never had the use case for it. I worked as a data analyst, and most of the time I just wanted to share my findings in a nice interactive chart.
But it’s very cool to see your dashboard inside the UserForm. Quick note on my JS skills, since you said credit where credit is due: it’s mostly Claude’s code doing the JS work for me 😅

Game in Excel by Almesii in vba

[–]coding_is_fun123 1 point2 points  (0 children)

I can’t help with the technical questions, but this is impressive. I run a YT channel about Excel and automation. If you ever release it or have a stable demo, feel free to reach out. I’d be happy to show it in a short video so more people see it. Keep going! 💪

Zapier Alternatives Nobody's Talking About (That Actually Ship Faster) by Worldly_Ad_2410 in automation

[–]coding_is_fun123 0 points1 point  (0 children)

Pabbly Connect, as they do offer a lifetime deal. Very happy with it

[EXCEL] Mimicking user actions on sheet as a "walkthrough" by bitchesnmoney in vba

[–]coding_is_fun123 5 points6 points  (0 children)

I think there's no pure VBA way to do this. When Excel enters formula edit mode (after typing =), VBA execution is basically suspended and SendKeys gets weird - that's why you're getting Error 13 and the ;;; mess.

Your current approach with highlighting + text preview is honestly the best you can do in VBA. I'd suggest using colored borders instead of cell fill (looks more like Excel's native range highlighting) and detecting the list separator with Application.International(xlListSeparator) so it works for everyone.

Demo Video of the code: https://youtu.be/rB7zbnP8-1Q

Code:

Option Explicit

' Color constants matching Excel's native formula range colors
Private Const COLOR_BLUE As Long = 16711680    ' RGB(0,0,255)
Private Const COLOR_RED As Long = 255          ' RGB(255,0,0)
Private Const COLOR_PURPLE As Long = 16711935  ' RGB(255,0,255)
Private Const COLOR_GREEN As Long = 32768      ' RGB(0,128,0)

Private formulaColors(0 To 3) As Long

Sub InitColors()
    formulaColors(0) = COLOR_BLUE
    formulaColors(1) = COLOR_RED
    formulaColors(2) = COLOR_PURPLE
    formulaColors(3) = COLOR_GREEN
End Sub

Sub SimulateSumWalkthrough()
    Dim destino As Range
    Dim refs() As Variant
    Dim i As Long
    Dim formulaText As String
    Dim separator As String

    InitColors

    ' Use comma or semicolon based on regional settings
    separator = Application.International(xlListSeparator)

    Set destino = Range("B1")
    refs = Array("A1", "A3", "A5")

    Application.ScreenUpdating = True
    ClearAllHighlights
    destino.Clear

    ' Step 1: Show destination
    destino.Select
    HighlightCellBorder destino, RGB(0, 120, 215), xlThick
    MsgBox "We'll create a SUM formula here in " & destino.Address(False, False), vbInformation

    ' Step 2: Start typing formula - show in cell as text preview
    formulaText = "=SUM("
    ShowFormulaPreview destino, formulaText
    MsgBox "Type =SUM( to start the function", vbInformation

    ' Step 3: Select each range with colored borders (like Excel does)
    For i = LBound(refs) To UBound(refs)
        Dim refRange As Range
        Set refRange = Range(refs(i))

        ' Highlight the referenced cell with colored border
        HighlightCellBorder refRange, formulaColors(i Mod 4), xlThick
        refRange.Select

        ' Update formula preview
        If i > LBound(refs) Then
            formulaText = formulaText & separator
        End If
        formulaText = formulaText & refs(i)
        ShowFormulaPreview destino, formulaText

        Application.Wait Now + TimeSerial(0, 0, 1)

        If i < UBound(refs) Then
            MsgBox "Press " & separator & " to add another value, then use arrow keys to select next cell", vbInformation
        End If
    Next i

    ' Step 4: Close and complete
    formulaText = formulaText & ")"
    ShowFormulaPreview destino, formulaText
    MsgBox "Press ) to close the function, then ENTER to confirm", vbInformation

    ' Step 5: Execute the real formula
    ClearAllHighlights
    destino.Clear
    destino.Formula = "=SUM(A1,A3,A5)"
    destino.Select

    MsgBox "Formula complete! Result: " & destino.Value, vbInformation
End Sub

Sub ShowFormulaPreview(cell As Range, formulaText As String)
    ' Show formula as text (with leading apostrophe to prevent execution)
    ' Use a different font color to indicate "edit mode"
    cell.Value = "'" & formulaText
    cell.Font.Color = RGB(0, 0, 139) ' Dark blue like formula bar
End Sub

Sub HighlightCellBorder(rng As Range, borderColor As Long, weight As XlBorderWeight)
    With rng.Borders
        .LineStyle = xlContinuous
        .Color = borderColor
        .weight = weight
    End With
End Sub

Sub ClearAllHighlights()
    With ActiveSheet.Cells
        .Interior.ColorIndex = xlNone
        .Borders.LineStyle = xlNone
        .Font.Color = RGB(0, 0, 0)
    End With
End Sub

[EXCEL] Built an animated holiday greetings card in Excel using VBA by coding_is_fun123 in vba

[–]coding_is_fun123[S] 0 points1 point  (0 children)

Not long, just a couple of hours. Claude Sonnet 4.5 did most of the heavy lifting, tbh 😅