home.social

#vba — Public Fediverse posts

Live and recent posts from across the Fediverse tagged #vba, aggregated by home.social.

  1. CW: Ich hätte mal wieder eine Frage zu #Microsoft #Excel #VBA mit #DigitaleSignatur

    2/2
    #Microsoft #Excel #VBA #DigitaleSignatur

    Wenn ich im VB-Editor diese digitale SIgnatur auswähle, kann diese ohne Fehlermeldung hinzugefügt werden.

    Beim Speichern der Daten jedoch kommt die Meldung "das Projekt konnte nicht digital signiert werden".

    Hat jemand eine Idee, wo der Fehler liegen könnte?

  2. CW: Ich hätte mal wieder eine Frage zu #Microsoft #Excel #VBA mit #DigitaleSignatur

    1/2
    #Excel #VBA #DigitaleSignatur

    Ich besitze ein Zertifikat zur #CodesIgnatur, das aktuell gültig ist. Das Token ist eingesteckt, die Vewaltungssoftware ist installiert und zeigt die Zertifikatsdaten korrekt an.

    Ich habe in einer Excel-Datei (*.xlsm) ein VBA-Makro, das benutzerdefinierte Tabellenfunktionen bereitstellt. Das Verzeichnis dieser Datei ist als vertrauenswürdig eingerichtet, alles funktioniert.

  3. This was a great exercise for me. I've never done VBA in Word before. I'm probably going to automate a bunch more of the laborous actions I need to do in Word frequently.

    #vba #word #msWord #msOffice #scripting

  4. This was a great exercise for me. I've never done VBA in Word before. I'm probably going to automate a bunch more of the laborous actions I need to do in Word frequently.

    #vba #word #msWord #msOffice #scripting

  5. This was a great exercise for me. I've never done VBA in Word before. I'm probably going to automate a bunch more of the laborous actions I need to do in Word frequently.

    #vba #word #msWord #msOffice #scripting

  6. shr @BasementDweller3000 ·

    This was a great exercise for me. I've never done VBA in Word before. I'm probably going to automate a bunch more of the laborous actions I need to do in Word frequently.

  7. This was a great exercise for me. I've never done VBA in Word before. I'm probably going to automate a bunch more of the laborous actions I need to do in Word frequently.

    #vba #word #msWord #msOffice #scripting

  8. In Word I do this a lot with images:

    1. Set wrapping to top/bottom
    2. Make image equal body width
    3. Set image to follow text
    4. Set image below text
    5. Turn off allow overlap
    6. Lock anchor

    I finally decided to write some vba to do this:

    pastebin.com/a2gGS6VS

    It should work with any number of selected objects.

    If you add this to the "Normal" template you can access it in any Word document. I also added it as a button in Word's toolbar. #vba #word #msWord #msOffice #scripting

  9. In Word I do this a lot with images:

    1. Set wrapping to top/bottom
    2. Make image equal body width
    3. Set image to follow text
    4. Set image below text
    5. Turn off allow overlap
    6. Lock anchor

    I finally decided to write some vba to do this:

    pastebin.com/a2gGS6VS

    It should work with any number of selected objects.

    If you add this to the "Normal" template you can access it in any Word document. I also added it as a button in Word's toolbar. #vba #word #msWord #msOffice #scripting

  10. In Word I do this a lot with images:

    1. Set wrapping to top/bottom
    2. Make image equal body width
    3. Set image to follow text
    4. Set image below text
    5. Turn off allow overlap
    6. Lock anchor

    I finally decided to write some vba to do this:

    pastebin.com/a2gGS6VS

    It should work with any number of selected objects.

    If you add this to the "Normal" template you can access it in any Word document. I also added it as a button in Word's toolbar. #vba #word #msWord #msOffice #scripting

  11. shr @BasementDweller3000 ·

    In Word I do this a lot with images:

    1. Set wrapping to top/bottom
    2. Make image equal body width
    3. Set image to follow text
    4. Set image below text
    5. Turn off allow overlap
    6. Lock anchor

    I finally decided to write some vba to do this:

    pastebin.com/a2gGS6VS

    It should work with any number of selected objects.

    If you add this to the "Normal" template you can access it in any Word document. I also added it as a button in Word's toolbar.

  12. In Word I do this a lot with images:

    1. Set wrapping to top/bottom
    2. Make image equal body width
    3. Set image to follow text
    4. Set image below text
    5. Turn off allow overlap
    6. Lock anchor

    I finally decided to write some vba to do this:

    pastebin.com/a2gGS6VS

    It should work with any number of selected objects.

    If you add this to the "Normal" template you can access it in any Word document. I also added it as a button in Word's toolbar. #vba #word #msWord #msOffice #scripting

  13. Je viens de publier une formation complète VBA pour Excel sur GitHub.

    📚 23 chapitres du niveau débutant à avancé
    ⚙️ macros, automation, objets Excel, UserForms
    💡 projets pratiques inclus
    ➡️ github.com/NDXDeveloper/format

    #VBA #Excel #OpenSource

  14. Je viens de publier une formation complète VBA pour Excel sur GitHub.

    📚 23 chapitres du niveau débutant à avancé
    ⚙️ macros, automation, objets Excel, UserForms
    💡 projets pratiques inclus
    ➡️ github.com/NDXDeveloper/format

    #VBA #Excel #OpenSource

  15. Je viens de publier une formation complète VBA pour Excel sur GitHub.

    📚 23 chapitres du niveau débutant à avancé
    ⚙️ macros, automation, objets Excel, UserForms
    💡 projets pratiques inclus
    ➡️ github.com/NDXDeveloper/format

    #VBA #Excel #OpenSource

  16. Excelで画像をドット絵にしてみた話 #VBA - Qiita
    qiita.com/hetare001/items/bd1c

    さばんちゃんかよ

  17. Preiprogrammeur

    Ik ben in Wageningen afgestudeerd als bioloog. Mijn afstudeervakken waren bij plantenfysiologie (Moleculaire mechanismen van fotoinhibitie van de fotosynthese) en biochemie (De rol van ATP in werkingsmechanisme van nitrogenase). Behalve een voor de studiepunten gevolgd practicum Pascal, ik had een hardloopwedstrijd ontworpen met de dwergen uit de Hobbit als renners, had ik verder helemaal niets met programmeren. Als je toen tegen mij gezegd had dat ik later nog eens in de IT terecht zou komen had ik je vierkant uitgelachen.

    schrijfselsvansjaan.wordpress.
    #Preiprogrammeur #VBA #RoR #SharePoint

  18. Preiprogrammeur

    Ik ben in Wageningen afgestudeerd als bioloog. Mijn afstudeervakken waren bij plantenfysiologie (Moleculaire mechanismen van fotoinhibitie van de fotosynthese) en biochemie (De rol van ATP in werkingsmechanisme van nitrogenase). Behalve een voor de studiepunten gevolgd practicum Pascal, ik had een hardloopwedstrijd ontworpen met de dwergen uit de Hobbit als renners, had ik verder helemaal niets met programmeren. Als je toen tegen mij gezegd had dat ik later nog eens in de IT terecht zou komen had ik je vierkant uitgelachen.

    schrijfselsvansjaan.wordpress.
    #Preiprogrammeur #VBA #RoR #SharePoint

  19. Preiprogrammeur

    Ik ben in Wageningen afgestudeerd als bioloog. Mijn afstudeervakken waren bij plantenfysiologie (Moleculaire mechanismen van fotoinhibitie van de fotosynthese) en biochemie (De rol van ATP in werkingsmechanisme van nitrogenase). Behalve een voor de studiepunten gevolgd practicum Pascal, ik had een hardloopwedstrijd ontworpen met de dwergen uit de Hobbit als renners, had ik verder helemaal niets met programmeren. Als je toen tegen mij gezegd had dat ik later nog eens in de IT terecht zou komen had ik je vierkant uitgelachen.

    schrijfselsvansjaan.wordpress.
    #Preiprogrammeur #VBA #RoR #SharePoint

  20. Preiprogrammeur

    Ik ben in Wageningen afgestudeerd als bioloog. Mijn afstudeervakken waren bij plantenfysiologie (Moleculaire mechanismen van fotoinhibitie van de fotosynthese) en biochemie (De rol van ATP in werkingsmechanisme van nitrogenase). Behalve een voor de studiepunten gevolgd practicum Pascal, ik had een hardloopwedstrijd ontworpen met de dwergen uit de Hobbit als renners, had ik verder helemaal niets met programmeren. Als je toen tegen mij gezegd had dat ik later nog eens in de IT terecht zou komen had ik je vierkant uitgelachen.

    schrijfselsvansjaan.wordpress.
    #Preiprogrammeur #VBA #RoR #SharePoint

  21. #Excel では日時がシリアル値で表現されることは知っていたが、 #VBA で扱うと代入先が文字列Stringか数値Long / Doubleかで入る値が違うとか気持ち悪いな

    VBAでシリアル値(日付、時間)を扱う時の注意点 qiita.com/qiiChan/items/603063 #Qiita

  22. #Excel では日時がシリアル値で表現されることは知っていたが、 #VBA で扱うと代入先が文字列Stringか数値Long / Doubleかで入る値が違うとか気持ち悪いな

    VBAでシリアル値(日付、時間)を扱う時の注意点 qiita.com/qiiChan/items/603063 #Qiita

  23. #Excel では日時がシリアル値で表現されることは知っていたが、 #VBA で扱うと代入先が文字列Stringか数値Long / Doubleかで入る値が違うとか気持ち悪いな

    VBAでシリアル値(日付、時間)を扱う時の注意点 qiita.com/qiiChan/items/603063 #Qiita

  24. @kkarhan @echo_xc

    I wish that 10 years ago #Nextcloud and #OwnCloud hadn't dissipated their energy arguing and forking, as if it had been a viable solution then my employers would have gone for them rather than #MS365 and now we are stuck with it as Sharepoint is to be fair quite useful (it basically gets used as a giant NAS) and has even had UI and usability improvements.

    You can run the whole of the web-based MS365 part on Linux (I've tried it with success) but I still need the desktop app #VBA for some stuff I do (and also I have OBD2 control software (VCDS) for VW group cars that will *only* work on Windows, the devs have flat out refused to port it to Linux (I suspect because they don't want the dongle being reverse engineered)

  25. @kkarhan @echo_xc

    I wish that 10 years ago #Nextcloud and #OwnCloud hadn't dissipated their energy arguing and forking, as if it had been a viable solution then my employers would have gone for them rather than #MS365 and now we are stuck with it as Sharepoint is to be fair quite useful (it basically gets used as a giant NAS) and has even had UI and usability improvements.

    You can run the whole of the web-based MS365 part on Linux (I've tried it with success) but I still need the desktop app #VBA for some stuff I do (and also I have OBD2 control software (VCDS) for VW group cars that will *only* work on Windows, the devs have flat out refused to port it to Linux (I suspect because they don't want the dongle being reverse engineered)

  26. @kkarhan @echo_xc

    I wish that 10 years ago #Nextcloud and #OwnCloud hadn't dissipated their energy arguing and forking, as if it had been a viable solution then my employers would have gone for them rather than #MS365 and now we are stuck with it as Sharepoint is to be fair quite useful (it basically gets used as a giant NAS) and has even had UI and usability improvements.

    You can run the whole of the web-based MS365 part on Linux (I've tried it with success) but I still need the desktop app #VBA for some stuff I do (and also I have OBD2 control software (VCDS) for VW group cars that will *only* work on Windows, the devs have flat out refused to port it to Linux (I suspect because they don't want the dongle being reverse engineered)

  27. @kkarhan @echo_xc

    I wish that 10 years ago #Nextcloud and #OwnCloud hadn't dissipated their energy arguing and forking, as if it had been a viable solution then my employers would have gone for them rather than #MS365 and now we are stuck with it as Sharepoint is to be fair quite useful (it basically gets used as a giant NAS) and has even had UI and usability improvements.

    You can run the whole of the web-based MS365 part on Linux (I've tried it with success) but I still need the desktop app #VBA for some stuff I do (and also I have OBD2 control software (VCDS) for VW group cars that will *only* work on Windows, the devs have flat out refused to port it to Linux (I suspect because they don't want the dongle being reverse engineered)

  28. @kkarhan @echo_xc

    I wish that 10 years ago #Nextcloud and #OwnCloud hadn't dissipated their energy arguing and forking, as if it had been a viable solution then my employers would have gone for them rather than #MS365 and now we are stuck with it as Sharepoint is to be fair quite useful (it basically gets used as a giant NAS) and has even had UI and usability improvements.

    You can run the whole of the web-based MS365 part on Linux (I've tried it with success) but I still need the desktop app #VBA for some stuff I do (and also I have OBD2 control software (VCDS) for VW group cars that will *only* work on Windows, the devs have flat out refused to port it to Linux (I suspect because they don't want the dongle being reverse engineered)

  29. 「Excel」→「LibreOffice」移行をマクロでも、VBAっぽく使えるPythonライブラリが仮公開/その名も「Excel Like UNO」、モダンな設計でIDEの開発支援や保守の面でもメリット
    forest.watch.impress.co.jp/doc

    #forest_watch_impress #Excel #LibreOffice #Python #VBA #Excel_Like_UNO #UNO_API #LibreOffice_Calc #オフィス_ドキュメント #オフィス #Windows #Mac #Linux #プログラミング