Can someone suggest VBA and Python resources specifically for Excel?
I'm helping someone from the Windows world upskill. Her biggest technical skill is Excel, so we're staring with that.
I can point her towards a Byte of Python for starters, but it has nothing about Excel integration and I really want to cover that. Thanks, folks.
#Automatisierung unter #M365
#vba war gestern.
Heute began ich mit dem nächsten flow unter #powerautomate .
Deutlich effizienter, strukturierter und schneller.
Auch schaue ich mir Tipps von den Profis ab.
Die lernkurve zeigt nach oben...
Those of you who like and continue to use #BASIC, what do you like? What do you miss when you're coding in something else? Yes, embedded BASIC dialects count.
Do you think BASIC still has life left in it?
Just let my way-more-complicated-than-anticipated #VBA script loose on our #SharePoint directory.
Estimated processing time: 4.35 hours 
Pray for me and the souls of all those (hopefully not) lost files. 
Do any of you #LibreOffice fans use the built-in #BASIC functionality? How does it compare to #VBA?
My question is - why?
Libreoffice already has Calc, which can read and save Excel files as long as there are no macros.
#linux #excel #libreoffice #microsoft #vba
theregister.com: Linux in Excel? Sure, why not ruin both
https://www.theregister.com/2025/05/01/linux_in_microsoft_excel/
…you really can’t pull a list of all table names in an #Excel workbook and reference it in a formula without using #VBA?
That’s… insane.
Yeah yeah, data models and #powerquery and such. These are better options when starting from the beginning, but we’re hundreds of workbooks in now and I need something (a formula) I can just drop in to be even remotely realistic in terms of feasibility.
When your colleague messages you on Friday afternoon and casually mentions he’s been editing files in the directory you set up for standardizing files after QC… 
That… was meant to be a protected directory where files are moved and modified by scripts and automatons. Is that why my scripts aren’t working?!!?
Apparently the optimal VBA code to save a record in Access is:
If Me.Dirty Then
Me.Dirty = False
End If
I have a newfound respect for coders. The overwhelming desire to put my fist through my monitor and burn the entire house down while debugging this week is real.
#VBA #debugging
Indexes starting with 1 in #VBA is oppression
On my 4th iteration of this process, having to overhaul it after discovering #Microsoft #PowerAutomate triggers for #SharePoint won’t fire on file movements w/in the same library 
. This doesn’t do exactly what I want but it’s close enough.
Now I just gotta build out all these #flows, #VBA #scripts, #PowerBI analyses, & the #PBI #dashboard.
Making more work for myself than is necessary, but I don’t want to be embarrassed by a sloppy, inconsistent product.
@Antiqueight yes I'd have to know what MSOffice app the VBA is hosted in, where the data comes from, and how to get the data into SAP programmatically.
Might help to add: #VBA #SAP #automation
@hn50 this sounds geckibg #cursed.
The lengths to which I will go to avoid repetitive, monotonous grunt work.
https://www.annapost.com/386535/ 【愕然】VBAの限界！？Pythonなら衝撃の○行で終わるExcel自動化３選！ #Announcers #FemaleAnnouncers #Python #pythonクラス #Python入門 #Python基礎 #python関数 #VBA #VbaFuncithon #VBA入門 #VBA基礎 #vba関数 #女子アナ #渡辺美佳
Why???
Apparently #Microsoft messed with the fonts in #Windows11 #VBA forms so now a bunch of the #Excel files I maintain at work have text that doesn't fit in the text boxes.
I decided long ago that Windows 11 will never be on my personal computers. I'm switching to #Linux and #LibreOffice.
Phase III is kicking off next week, and I am again tasked with generating the #FMEA portions of our analysis based on our Phase I work. No one knows but I’ve automated it with #SharePoint, #PowerBI, #ReportBuilder, and #Excel #VBA. This should keep me “busy” as far as my boss & colleagues are concerned through April, maybe May.
God I love #automation.
Kind Animals Little Cards – version 0.1 Duckling and dandelions
https://dimalinkeng.blogspot.com/2025/01/kind-animals-little-cards-version-01.html
