@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
В блоге, а потом и в книге Joel Spolsky была расписана история появления #VBA в том самом Microsoft #Excel.
Этот персонаж так же потом сделал #stackoverflow и вообще известный графоман от #softwaredevelopment, сродни Лебедеву от дизайна — https://neolurk.org/wiki/Джоэл_Спольски
———
История в приложенном файле (ограничение на число символов не позволяет разместить в посте).
———
Перевод на русский язык этой публикации найти более не удаётся, взято из книги «Джоэл: и снова о программировании» ISBN 978-5-93286-144-8
Warum heißt es eigentlich #VBA - Programmierer und nicht Subcommandante?
Vous reprendrez bien un peu de #VBA ? Si vous avez l’habitude de développer vos #macro dans #Excel, alors vous aurez peut-être besoin de faire de la gestion d’erreur :
https://zestedesavoir.com/billets/4490/la-gestion-des-erreurs-en-vba/
https://zestedesavoir.com/billets/4490/la-gestion-des-erreurs-en-vba/
Déboguer ses macros #VBA dans #Excel, c’est possible ! Vk nous le montre avec ce petit billet :
https://zestedesavoir.com/billets/4433/deboguer-ses-macros-vba-dans-excel/
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)
AgentTesla sempre più evasivo. L’utilizzo del CLR .NET consente attacchi fileless
Nell’ambito della recente campagna #malware #AgentTesla, discussa in dettaglio da #SonicWall, gli aggressori hanno utilizzato #macro #VBA nei documenti #Word per eseguire un #attacco fileless #injection, in cui il #payload dannoso viene caricato direttamente nella #RAM del computer.
#redhotcyber #online #it #ai #hacking #innovation #privacy #cybersecurity #technology #engineering #cybercrime #intelligence #intelligenzaartificiale #informationsecurity #ethicalhacking #dataprotection #cybersecurityawareness #cybersecuritytraining #cybersecuritynews #infosecurity
Return the factors of a number as a string:
Function Factors(x As Integer) As String
Application.Volatile
Dim i As Integer
Factors = x
For i = x - 1 To 1 Step -1
If x / i = Int(x / i) Then
Factors = Factors & ", " & i
End If
Next i
End Function
Why do people use #VBA?
https://sancarn.github.io/vba-articles/why-do-people-use-vba.html
@Weirdaholic @kkarhan #VBA feels a bit like dying tech. Have you tried Office Scripts & Power Automate? Some really cool automation solutions are possible there
@rootsworks I'm sorry to hear of the lay off. I boosted this post, if you don't mind.
You have talent... just need to find the right pair of eyes.
Gibts hier #VBA-Cracks? Ich benötige für #Outlook ein Makro:
- Kopiere die Absenderdomain der ausgewählten Mail inkl. @-Zeichen
- Füge sie in der bestehenden Regel "PR01" in der Liste "Mailadresse enthält" hinzu.
- Führe die Regel PR01 aus
Mit ChatGPT bin ich nicht sehr weit gekommen (siehe auch https://forum.pctipp.ch/index.php?threads/outlook-koennte-dieses-vba-makro-aus-dem-chatgpt-vorschlag-funktionieren-ziel-absender-domain-zu-bestehender-regel-hinzufuegen.47592/).
I had completely forgotten how unpleasant the entire Excel VBA experience is.
- Coding without useful code completion. Kill me now.
- I accidentally made an infinite loop. I had to power-cycle my machine it wedged so hard!
- That "special" VB syntax. "loop? wend? end? who knows!"
https://paste.erratic.cloud/?114ae5be9268d4e9#HykwmG2SM7LdVQ3V64cvdaKf9zQXS2fogtf1NVFMpL8k
I am so grateful that this isn't something I routinely have to touch!
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.
Cybercrime e Phishing: componenti XLL di Excel come vettore iniziale di attacco
Gli analisti di #CiscoTalos affermano che dopo che #Microsoft ha iniziato a bloccare le #macro #VBA nei documenti Office scaricati da Internet, tali documenti (contrassegnati come Mark Of The Web) hanno costretto gli #aggressori a ripensare le loro catene di #attacco.
Ad esempio, i criminali informatii utilizzano sempre più i file dei componenti aggiuntivi di #Excel (.#XLL) come vettore di #compromissione iniziale.
#redhotcyber #informationsecurity #ethicalhacking #dataprotection #hacking #cybersecurity #cybercrime #cybersecurityawareness #cybersecuritytraining #cybersecuritynews #privacy #infosecurity
https://www.pyxll.com/
(commercial)
"Write Excel Add-Ins in Python
Use Microsoft #Excel as a user friendly front-end to your #Python code. No #VBA, just Python! " spreadsheet #dontuseexcel