digitalcourage.social

Profoundly NerdyCan 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.<a href="https://bitbang.social/tags/Excel" class="mention hashtag" rel="nofollow noopener" target="_blank">#Excel</a> <a href="https://bitbang.social/tags/VBA" class="mention hashtag" rel="nofollow noopener" target="_blank">#VBA</a> <a href="https://bitbang.social/tags/Python" class="mention hashtag" rel="nofollow noopener" target="_blank">#Python</a> <a href="https://bitbang.social/tags/programming" class="mention hashtag" rel="nofollow noopener" target="_blank">#programming</a>

Prof. Dr. Trepurine<a href="https://muenchen.social/tags/Automatisierung" class="mention hashtag" rel="nofollow noopener" target="_blank">#Automatisierung</a> unter <a href="https://muenchen.social/tags/M365" class="mention hashtag" rel="nofollow noopener" target="_blank">#M365</a> <a href="https://muenchen.social/tags/vba" class="mention hashtag" rel="nofollow noopener" target="_blank">#vba</a> war gestern. Heute began ich mit dem nächsten flow unter <a href="https://muenchen.social/tags/powerautomate" class="mention hashtag" rel="nofollow noopener" target="_blank">#powerautomate</a> . Deutlich effizienter, strukturierter und schneller. Auch schaue ich mir Tipps von den Profis ab. Die lernkurve zeigt nach oben...

Profoundly NerdyThose of you who like and continue to use <a href="https://bitbang.social/tags/BASIC" class="mention hashtag" rel="nofollow noopener" target="_blank">#BASIC</a>, 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?<a href="https://bitbang.social/tags/programming" class="mention hashtag" rel="nofollow noopener" target="_blank">#programming</a> <a href="https://bitbang.social/tags/FreeBASIC" class="mention hashtag" rel="nofollow noopener" target="_blank">#FreeBASIC</a> <a href="https://bitbang.social/tags/qbasic" class="mention hashtag" rel="nofollow noopener" target="_blank">#qbasic</a> <a href="https://bitbang.social/tags/vb" class="mention hashtag" rel="nofollow noopener" target="_blank">#vb</a> <a href="https://bitbang.social/tags/vba" class="mention hashtag" rel="nofollow noopener" target="_blank">#vba</a>

Vintage Buses 🚌 🏴󠁧󠁢󠁳󠁣󠁴󠁿My question is - why?Libreoffice already has Calc, which can read and save Excel files as long as there are no macros.<a href="https://mastodon.social/tags/linux" class="mention hashtag" rel="nofollow noopener" target="_blank">#linux</a> <a href="https://mastodon.social/tags/excel" class="mention hashtag" rel="nofollow noopener" target="_blank">#excel</a> <a href="https://mastodon.social/tags/libreoffice" class="mention hashtag" rel="nofollow noopener" target="_blank">#libreoffice</a> <a href="https://mastodon.social/tags/microsoft" class="mention hashtag" rel="nofollow noopener" target="_blank">#microsoft</a> <a href="https://mastodon.social/tags/vba" class="mention hashtag" rel="nofollow noopener" target="_blank">#vba</a> theregister.com: Linux in Excel? Sure, why not ruin both <a href="https://www.theregister.com/2025/05/01/linux_in_microsoft_excel/" rel="nofollow noopener" translate="no" target="_blank">https://www.theregister.com/2025/05/01/linux_in_microsoft_excel/</a>

bimmerIndexes starting with 1 in <a href="https://mastodon.social/tags/VBA" class="mention hashtag" rel="nofollow noopener" target="_blank">#VBA</a> is oppression

Kevin Karhan :verified:<a href="https://social.lansky.name/@hn50" class="u-url mention" rel="nofollow noopener" target="_blank">@hn50</a> this sounds geckibg <a href="https://infosec.space/tags/cursed" class="mention hashtag" rel="nofollow noopener" target="_blank">#cursed</a>.<ul><li>Only missing <a href="https://infosec.space/tags/API" class="mention hashtag" rel="nofollow noopener" target="_blank">#API</a> in <a href="https://infosec.space/tags/VisualBasic" class="mention hashtag" rel="nofollow noopener" target="_blank">#VisualBasic</a> and usibg <a href="https://infosec.space/tags/VBA" class="mention hashtag" rel="nofollow noopener" target="_blank">#VBA</a> <a href="https://infosec.space/tags/macros" class="mention hashtag" rel="nofollow noopener" target="_blank">#macros</a> on legacy <a href="https://infosec.space/tags/MicrosoftOffice" class="mention hashtag" rel="nofollow noopener" target="_blank">#MicrosoftOffice</a>!</li></ul>

🚀 Несерьёзный Выдумщик 👨‍🔬В блоге, а потом и в книге Joel Spolsky была расписана история появления <a href="https://shitpost.poridge.club/tags/VBA" rel="nofollow noopener" target="_blank">#VBA</a> в том самом Microsoft <a href="https://shitpost.poridge.club/tags/Excel" rel="nofollow noopener" target="_blank">#Excel</a>. Этот персонаж так же потом сделал <a href="https://shitpost.poridge.club/tags/stackoverflow" rel="nofollow noopener" target="_blank">#stackoverflow</a> и вообще известный графоман от <a href="https://shitpost.poridge.club/tags/softwaredevelopment" rel="nofollow noopener" target="_blank">#softwaredevelopment</a>, сродни Лебедеву от дизайна — <a href="https://neolurk.org/wiki/Джоэл_Спольски" rel="nofollow noopener" target="_blank">https://neolurk.org/wiki/Джоэл_Спольски</a> ——— История в приложенном файле (ограничение на число символов не позволяет разместить в посте). ——— Перевод на русский язык этой публикации найти более не удаётся, взято из книги «Джоэл: и снова о программировании» ISBN 978-5-93286-144-8

TanquistWhy??? Apparently <a href="https://masto.ai/tags/Microsoft" class="mention hashtag" rel="nofollow noopener" target="_blank">#Microsoft</a> messed with the fonts in <a href="https://masto.ai/tags/Windows11" class="mention hashtag" rel="nofollow noopener" target="_blank">#Windows11</a> <a href="https://masto.ai/tags/VBA" class="mention hashtag" rel="nofollow noopener" target="_blank">#VBA</a> forms so now a bunch of the <a href="https://masto.ai/tags/Excel" class="mention hashtag" rel="nofollow noopener" target="_blank">#Excel</a> 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 <a href="https://masto.ai/tags/Linux" class="mention hashtag" rel="nofollow noopener" target="_blank">#Linux</a> and <a href="https://masto.ai/tags/LibreOffice" class="mention hashtag" rel="nofollow noopener" target="_blank">#LibreOffice</a>.

G. ClavierAnother proof <a href="https://social.sciences.re/tags/Excel" class="mention hashtag" rel="nofollow noopener" target="_blank">#Excel</a> and <a href="https://social.sciences.re/tags/VBA" class="mention hashtag" rel="nofollow noopener" target="_blank">#VBA</a> are the dumbest pieces of shit ever brought up to computing: you can't use a "Sleep" equivalent natively, the "Wait" native function has a plus or minus 1 second accuracy.This. Software. Is. A. Piece. Of. Shit.

atteroI've just written my first <a href="https://mastodon.social/tags/VBA" class="mention hashtag" rel="nofollow noopener" target="_blank">#VBA</a> macro and I'm amazed how cursed it is.I love it.

Jensi :antifa:‎Warum heißt es eigentlich <a href="https://don.linxx.net/tags/VBA" class="mention hashtag" rel="nofollow noopener" target="_blank">#VBA</a> - Programmierer und nicht Subcommandante? 🤔

Kevin Karhan :verified:<a href="https://osna.social/@razze" class="u-url mention" rel="nofollow noopener" target="_blank">@razze</a> I disagree because <a href="https://infosec.space/tags/JavaScript" class="mention hashtag" rel="nofollow noopener" target="_blank">#JavaScript</a> violates basic security standards and should be, like <a href="https://infosec.space/tags/VBA" class="mention hashtag" rel="nofollow noopener" target="_blank">#VBA</a> <a href="https://infosec.space/tags/macros" class="mention hashtag" rel="nofollow noopener" target="_blank">#macros</a>, <a href="https://infosec.space/tags/OOXML" class="mention hashtag" rel="nofollow noopener" target="_blank">#OOXML</a> and <a href="https://infosec.space/tags/Windows" class="mention hashtag" rel="nofollow noopener" target="_blank">#Windows</a>-<a href="https://infosec.space/tags/Executeables" class="mention hashtag" rel="nofollow noopener" target="_blank">#Executeables</a> be deemed inacceptable.If in doubt, test your website with <a href="https://infosec.space/tags/LynxBrowser" class="mention hashtag" rel="nofollow noopener" target="_blank">#LynxBrowser</a> <a href="https://en.wikipedia.org/wiki/Lynx_(web_browser)" rel="nofollow noopener" target="_blank">1</a> <a href="https://lynx.invisible-island.net/" rel="nofollow noopener" target="_blank">2</a> over Iridium speeds (@ 2400 bit/s) and with <a href="https://infosec.space/tags/TorBrowser" class="mention hashtag" rel="nofollow noopener" target="_blank">#TorBrowser</a> in it's strictest security settings (no <a href="https://infosec.space/tags/JS" class="mention hashtag" rel="nofollow noopener" target="_blank">#JS</a> allowed!) and then tell me that's accessible, because in many <a href="https://infosec.space/tags/eReaders" class="mention hashtag" rel="nofollow noopener" target="_blank">#eReaders</a> and applianced <a href="https://infosec.space/tags/BrailleScreens" class="mention hashtag" rel="nofollow noopener" target="_blank">#BrailleScreens</a> and <a href="https://infosec.space/tags/TTS" class="mention hashtag" rel="nofollow noopener" target="_blank">#TTS</a> devices you'll only have the output of <a href="https://infosec.space/tags/Lynx" class="mention hashtag" rel="nofollow noopener" target="_blank">#Lynx</a> as <a href="https://infosec.space/tags/Browser" class="mention hashtag" rel="nofollow noopener" target="_blank">#Browser</a> and not everyone has even <a href="https://infosec.space/tags/2G" class="mention hashtag" rel="nofollow noopener" target="_blank">#2G</a> speeds available.Otherwise you may fall into the trap of "<a href="https://infosec.space/tags/EliteProjection" class="mention hashtag" rel="nofollow noopener" target="_blank">#EliteProjection</a>" in that you assume <a href="https://humantransit.org/2017/07/the-dangers-of-elite-projection.html" rel="nofollow noopener" target="_blank">that everyone has as good of an access to tech, broadband</a>, <a href="https://infosec.space/tags/TechLiteracy" class="mention hashtag" rel="nofollow noopener" target="_blank">#TechLiteracy</a> and means to use them as we have them.Which is <a href="https://infosec.space/@kkarhan/112871529534554357" rel="nofollow noopener" target="_blank">my point of criticism</a> all along!

Kevin Karhan :verified:<a href="https://mastodon.sdf.org/@gnemmi" class="u-url mention" rel="nofollow noopener" target="_blank">@gnemmi</a> <a href="https://phpc.social/@andrewfeeney" class="u-url mention" rel="nofollow noopener" target="_blank">@andrewfeeney</a> <a href="https://minidisc.tokyo/@SuperDicq" class="u-url mention" rel="nofollow noopener" target="_blank">@SuperDicq</a> <a href="https://limepeeps.perchinup.top/@radmin" class="u-url mention" rel="nofollow noopener" target="_blank">@radmin</a> also <a href="https://infosec.space/tags/JS" class="mention hashtag" rel="nofollow noopener" target="_blank">#JS</a> died the day <a href="https://infosec.space/tags/CoinHive" class="mention hashtag" rel="nofollow noopener" target="_blank">#CoinHive</a> weaponized it and <a href="https://infosec.space/tags/WebAssembly" class="mention hashtag" rel="nofollow noopener" target="_blank">#WebAssembly</a> / <a href="https://infosec.space/tags/WASM" class="mention hashtag" rel="nofollow noopener" target="_blank">#WASM</a> for <a href="https://infosec.space/tags/Mining" class="mention hashtag" rel="nofollow noopener" target="_blank">#Mining</a>-<a href="https://infosec.space/tags/Malware" class="mention hashtag" rel="nofollow noopener" target="_blank">#Malware</a>...<a href="https://infosec.space/tags/JavaScript" class="mention hashtag" rel="nofollow noopener" target="_blank">#JavaScript</a> is like <a href="https://infosec.space/tags/VBA" class="mention hashtag" rel="nofollow noopener" target="_blank">#VBA</a> <a href="https://infosec.space/tags/macros" class="mention hashtag" rel="nofollow noopener" target="_blank">#macros</a> to me: it has no legitimate reason to exist! <a href="https://infosec.space/@kkarhan/112869008234682351" translate="no" rel="nofollow noopener" target="_blank">https://infosec.space/@kkarhan/112869008234682351</a>

MagnusSchon wieder ist ein Monat rum, das heißt, es gibt auch eine neue <a href="https://zug.network/tags/statistik" class="mention hashtag" rel="nofollow noopener" target="_blank">#statistik</a> 🥳 - 164 Fahrten - 3.802,94 km (Ø 23,19 km) - dafür 58 Stunden und 58 Minuten (Ø 21,57 min) - was insgesamt 162 Minuten zu lange waren (davon entfallen aber über 70 Minuten auf eine einzige Fahrt) (Ø 6,2 min länger jede Fahrt). - Insgesamt 1017 Punkte (Ø 6,2/Fahrt)Alles also etwas weniger als im Mai, aber immer noch ganz ordentlich. <a href="https://chaos.social/@traewelling" class="u-url mention" rel="nofollow noopener" target="_blank">@traewelling</a> <a href="https://zug.network/tags/bahnfahren" class="mention hashtag" rel="nofollow noopener" target="_blank">#bahnfahren</a> <a href="https://zug.network/tags/spnv" class="mention hashtag" rel="nofollow noopener" target="_blank">#spnv</a> <a href="https://zug.network/tags/spfv" class="mention hashtag" rel="nofollow noopener" target="_blank">#spfv</a> <a href="https://zug.network/tags/opnv" class="mention hashtag" rel="nofollow noopener" target="_blank">#opnv</a> Und so sieht das übrigens aus, wenn mein <a href="https://zug.network/tags/excel" class="mention hashtag" rel="nofollow noopener" target="_blank">#excel</a>-<a href="https://zug.network/tags/vba" class="mention hashtag" rel="nofollow noopener" target="_blank">#vba</a>-Makro durchgelaufen ist und alles berechnet hat:

Kevin Karhan :verified:<a href="https://tldr.nettime.org/@jean" class="u-url mention" rel="nofollow noopener" target="_blank">@jean</a> WTF?Aber <a href="https://infosec.space/tags/OOXML" class="mention hashtag" rel="nofollow noopener" target="_blank">#OOXML</a> wird akzeptiert obwohl es "<a href="https://infosec.space/tags/TuringComplete" class="mention hashtag" rel="nofollow noopener" target="_blank">#TuringComplete</a>" und am meisten für <a href="https://infosec.space/tags/Malware" class="mention hashtag" rel="nofollow noopener" target="_blank">#Malware</a> (<a href="https://infosec.space/tags/VBA" class="mention hashtag" rel="nofollow noopener" target="_blank">#VBA</a>) genutzt wird...

Zeroday Podcast (stefan)Hat jemand eine Idee, wie ich async eine Datei (1200MB) in den Arbeitspeicher einlesen kann, wenn ich nur VBS und VBA zur Verfügung habe? Aktuell dauert mir das einlesen in ein Array viel zu lange. Fopen bietet leider keine Möglichkeit den handle über Prozesse zu teilen. Die Reihenfolge der Daten im Array ist egal, da die Zeilen nummeriert sind(ID in Feld 0).<a href="https://podcasts.social/tags/vba" class="mention hashtag" rel="nofollow noopener" target="_blank">#vba</a> <a href="https://podcasts.social/tags/vbs" class="mention hashtag" rel="nofollow noopener" target="_blank">#vbs</a> <a href="https://podcasts.social/tags/vbscript" class="mention hashtag" rel="nofollow noopener" target="_blank">#vbscript</a> <a href="https://podcasts.social/tags/kraftakt" class="mention hashtag" rel="nofollow noopener" target="_blank">#kraftakt</a> <a href="https://podcasts.social/tags/aufreger" class="mention hashtag" rel="nofollow noopener" target="_blank">#aufreger</a> Ich Frage für einen Freund ;) 😜

PitWDJetzt wo ich seit langem noch mal an nem <a href="https://nrw.social/tags/VBA" class="mention hashtag" rel="nofollow noopener" target="_blank">#VBA</a> Projekt arbeite fällt mir wieder auf, dass ich in <a href="https://nrw.social/tags/Python" class="mention hashtag" rel="nofollow noopener" target="_blank">#Python</a> die fehlenden "End If" von <a href="https://nrw.social/tags/BASIC" class="mention hashtag" rel="nofollow noopener" target="_blank">#BASIC</a> oder "fi" oder "}" oder oder oder... immer noch 💩 finde...🤷‍♂️

Garry KeenorAnyone out there know how to lock an <a href="https://mas.to/tags/excel" class="mention hashtag" rel="nofollow noopener" target="_blank">#excel</a> <a href="https://mas.to/tags/dropdown" class="mention hashtag" rel="nofollow noopener" target="_blank">#dropdown</a> created using data validation, using <a href="https://mas.to/tags/vba" class="mention hashtag" rel="nofollow noopener" target="_blank">#vba</a>? i.e. prevent a user from expanding the dropdown and selecting a new value

SP⟁CED GO⟁TBeen working on building a <a href="https://appdot.net/tags/vba" class="mention hashtag" rel="nofollow noopener" target="_blank">#vba</a> application in <a href="https://appdot.net/tags/excel" class="mention hashtag" rel="nofollow noopener" target="_blank">#excel</a> for a client. Basically a recipe management tool that allows them to define their recipes in Excel and then dump that into an <a href="https://appdot.net/tags/XML" class="mention hashtag" rel="nofollow noopener" target="_blank">#XML</a> file to be imported into the control system. I've not done anything quite like this before, but it's coming together and working pretty well. I have this feeling though that there might be a much simpler way to do some of this, but hey, if it works well, I'm happy.

ExcelAnalytics<a href="https://fosstodon.org/@governa" class="u-url mention" rel="nofollow noopener" target="_blank">@governa</a> Because no other MS technology has the claws as deep into the <a href="https://mastodon.world/tags/Excel" class="mention hashtag" rel="nofollow noopener" target="_blank">#Excel</a> object model that <a href="https://mastodon.world/tags/VBA" class="mention hashtag" rel="nofollow noopener" target="_blank">#VBA</a> has along with a low skill level for adoption.

Recent searches

Search options

Administered by:

Server stats:

#vba