Run Python Code From Excel with VBA

Поделиться
HTML-код
  • Опубликовано: 7 янв 2025

Комментарии •

  • @9785633425657
    @9785633425657 Год назад

    Thanks for the explanation. I work a lot with both python and excel+vba and this will surely be useful in my project! Have a good day, man!

  • @irfanshaikh262
    @irfanshaikh262 2 года назад +2

    This is fabulous content. I love your python videos and more importantly the concepts of python you bring to us. Really enjoyed your encrypted python logging video.
    Is also like to point out that in this video instead of adding up extra backslashes, we can pass the path as a raw string.
    For example : pd.read_excel(r"C:\Users\Admin\myfile.xlsx"

  • @melodijouningeniero
    @melodijouningeniero Год назад +1

    This is amazing content! Right to the point! Congrats and thank you!

  • @orvarmagnus
    @orvarmagnus Год назад +3

    how do you avoid the permission Error when the excel file is already open? "permissionerror: [errno 13] permission denied: '......xlsx'"

    • @sergiorojas3985
      @sergiorojas3985 Год назад

      I have the same problem, and not sure is for the side of the permissions in the excel file, or a configuration in the Python editor

  • @onlyeducation1353
    @onlyeducation1353 8 месяцев назад

    Finally i have created this visualization data with help of your videos ...thanks bro🥀

  • @li249
    @li249 10 месяцев назад

    It is so helpful! Thanks a lot!

  • @BrendaRojasDelgado
    @BrendaRojasDelgado Год назад +1

    I need help. My py file runs perfectly when executed independently. However, when I run the VBA script it throws an error that I am incapable of seeing because cmd shuts down in a blink of an eye. Thanks in advance.

    • @sannti741
      @sannti741 Год назад

      Same happen to me. Did you solve the problem?

  • @marvinl.3710
    @marvinl.3710 10 месяцев назад

    This is amazing! thank you

  • @netspeedz3397
    @netspeedz3397 Год назад

    This is off topic but how did you get your VBA Editor to have 'dark mode' or 'dark theme'? I am able to modify the code to show dark but not the panes and menu drop downs, etc.

  • @mickyguy157
    @mickyguy157 Год назад +2

    Command prompt opens but immediately closes without outputting anything. Any idea what causes this or how to fix?

    • @sannti741
      @sannti741 Год назад +1

      Same happen to me. Did you solve the problem?

    • @GuyVivet
      @GuyVivet 11 месяцев назад

      Well that's what happens to everyone using the proposed solutions by this clown
      @@sannti741

    • @vivekbharadwaj8211
      @vivekbharadwaj8211 7 месяцев назад

      @@sannti741 Check for return code for any error (try using single quote for file path)

  • @HanifMPMI
    @HanifMPMI Год назад

    It looks like I managed to open the shell but it's instantly closed and does nothing. btw I use Spyder from Anaconda. Any suggestion to tackle this issue?

  • @The_Low_Level_Guy_0x00
    @The_Low_Level_Guy_0x00 2 года назад

    I asked a question recently on a video you did 1 year ago about setting up Neovim from scratch. The problem is that I can't install any plugins. Whenever I reach the step where you enter 'PlugInstall' it tells me that no plugin to install, and it doesn't matter which plugin, all of them are failing. I have tried google but no solution. This is when I am learning Linux and tools.

  • @udaya129
    @udaya129 6 месяцев назад

    clear and concise

  • @عابثالأخير-ز9ي
    @عابثالأخير-ز9ي Год назад

    You are my teacher 🙌🏻

  • @danielbolivar1601
    @danielbolivar1601 Год назад

    You helped me a lot! Ty

  • @stephanetionfe6519
    @stephanetionfe6519 Год назад

    please how to do the same opération witch access

  • @manvirschneider9103
    @manvirschneider9103 2 года назад +1

    How to do this on macOS?

  • @manarmimi3073
    @manarmimi3073 Год назад

    Hi, how to creat database in Excel .

  • @dinohsu1019
    @dinohsu1019 Год назад

    How about pyxll? Is that any easier? Thanks again.

  • @stephanetionfe6519
    @stephanetionfe6519 Год назад +1

    please can you do the same with ms access i really need it

    • @danwallace9017
      @danwallace9017 Год назад

      Yes you can. VBA is available in all MS Office applications.

  • @shehab976
    @shehab976 2 года назад +1

    why dont you use a simple hyperlink targeting ur script,its going to work same way

  • @lawrencedoliveiro9104
    @lawrencedoliveiro9104 2 года назад +2

    That’s like saying you can stick feathers onto a frame with wax and make it fly.
    Neat trick, but why would you want to?

    • @kolavithonduraski5031
      @kolavithonduraski5031 2 года назад +3

      ??? using maybe datascience tools and visualisation with your data and give it back to excel if needed, with more advanced visualisations ?
      you can do stuff with excel, but python is way more powerfull

    • @gobinappinnai2378
      @gobinappinnai2378 Год назад

      I am getting AttributeError: 'Dataframe' object has no attribute 'Prices'

  • @nathanielsdalmeida1632
    @nathanielsdalmeida1632 Год назад

    Same voice as Trevor Noah tha'ts crazy lol

  • @tcgvsocg1458
    @tcgvsocg1458 2 года назад +3

    literally excel but Worst