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.
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?
Lisa Khalimonenko
Daniel from Contourz Ballet Photography 
St Petersburg, Russia (2025) Natasha Furmann Daniel from Contourz Ballet Photography St Petersburg, Russia (2024)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/
@hn50 this sounds geckibg #cursed.
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.
@razze I disagree because #JavaScript violates basic security standards and should be, like #VBA #macros, #OOXML and #Windows-#Executeables be deemed inacceptable.
If in doubt, test your website with #LynxBrowser 1 2 over Iridium speeds (@ 2400 bit/s) and with #TorBrowser in it's strictest security settings (no #JS allowed!) and then tell me that's accessible, because in many #eReaders and applianced #BrailleScreens and #TTS devices you'll only have the output of #Lynx as #Browser and not everyone has even #2G speeds available.
Otherwise you may fall into the trap of "#EliteProjection" in that you assume that everyone has as good of an access to tech, broadband, #TechLiteracy and means to use them as we have them.
Which is my point of criticism all along!
@gnemmi @andrewfeeney @SuperDicq @radmin also #JS died the day #CoinHive weaponized it and #WebAssembly / #WASM for #Mining-#Malware...
#JavaScript is like #VBA #macros to me: it has no legitimate reason to exist!
https://infosec.space/@kkarhan/112869008234682351
@jean WTF?
Aber #OOXML wird akzeptiert obwohl es "#TuringComplete" und am meisten für #Malware (#VBA) genutzt wird...
I had previously whipped up an #Excel #VisualBasic for Applications (#VBA) Erlang B function to calculate #cellular tower quality of service (#QoS), so my other big project was modeling #Comcast Cellular’s network call capacity for an overdue upgrade from the (analog!) #1980s-era Advanced #Mobile Phone System (AMPS).
My first corporate #programming lesson: toy code will be expanded regardless of scalability. (4/6)
@Weirdaholic @kkarhan #VBA feels a bit like dying tech. Have you tried Office Scripts & Power Automate? Some really cool automation solutions are possible there 
The first part of this #VBA #Excel project (to automatically populate a spreadsheet with details of vehicles staff use and confirm they have tax and MOT (inspection)) was more straightforward than I expected..
(I nicked the JSON parser from a web, rather than roll my own)
I now just need to parse the dictionary it generates to warn of errors and (if data is good) populate an array (bearing in mind name/value pairs from DVLA can arrive in any order and total amount of them can vary)
Dachte, das MS Access Gefrickel & Geraffel seit 2020 los zu sein. Leider muss ich ein Legacy Programm migrieren (lassen), der kurz vor Rente stehende Developer bekommt seine technischen Schulden nicht in den Griff, kann für diverse DB Inhalte keine Relationen liefern, da diese nur übe die GUI implementiert wurden, nicht auf Tabellen Ebene. Man müsste #Microsoft auf Schmerzensgeld verklagen 
#microsoftaccess is evil #vba #rdbms #RelationaleDatenbanken #development #normalisierung #normalform
Hi, I’m James and this is my #introduction.
I'm originally from a rural town in middle Missouri but now call #SaintLouis my home. I have a love for the American southwest (my Mom is from New Mexico) and for the coastal city of #Savannah #Georgia.
I'm single, live alone with two #dachshunds (#dogs) named Amelia and Penelope. I'm a #progressive #liberal, can't stand money in #politics, and yearn for a day when the #Democrats improve their messaging and start fighting back.
What I'm into: #Photography, #Cooking, #Grilling, #StarWars, #StarTrek, #80sMovies, #JurassicPark, #Marvel, #dinosaurs, #computers, #gadgets, #VBA, #Python, #MSExcel, #art, #archaeology, #history, #3DPrinting, #philosophy, #news, and you'll find I'm a bit of an all-around nerd.
I’m also #diabetic, suffer from #anxiety, #depression, and #panicattacks. Forgive me in advance if I reach out.
I'm sarcastic as all get out but I have a big heart, that's easily broken when I see people (or animals) hurting.
#introduction
This is the professional account of @PatrickOBeirne
Systems Modelling Ltd, Ireland, provides consultancy in #Microsoft #Excel and #VBA solution development; #training; #data #analysis.
I am chair of the European Spreadsheet Risk Interest Group (EuSpRIG.org), author of XLTest #spreadsheet #auditing add-in (xltest.com), and present on spreadsheet risks at data risk & quality conferences.
#office #macros #automation #productivity #financial #modelling / #modeling #optimization
#introduction
Interests: #classical #music, #choral #singing, #humour, #language, #positive posts.
#mastoduine
Living a quiet life in the countryside of Co. #Wexford, #Ireland 5km from the nearest town.
See my profile for links to work related topics, Twitter, LinkedIn, and my occasional blog. My account @ExcelAnalytics is for professional interests, mainly #Excel #spreadsheets and #VBA, so also comment on #tech topics here. Or anything really, usually avoid vexatious topics. He/him/yer man
