Consulting

Results 1 to 5 of 5

Thread: Pyhton Script Called by xlwings Addin

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Newbie
    Joined
    Oct 2017
    Posts
    1
    Location

    Pyhton Script Called by xlwings Addin

    I am attempting to use a basic example of xlwings. I have the following VBA script:


    Sub Test()
            RunPython ("import VBAtester; VBAtester.test()")
            MsgBox ("Script has run.")
        End Sub

    Which is in the same directory as the python script VBAtester.py:

    import xlwings as xw
    def test():
    wb = xw.Book.caller()
    wb.sheets[0].range('A1').value = 'TEST VALUE'


    The VBA script runs and outputs the message box; but *'TEST VALUE'* does not show in cell A1, or elsewhere. I know the python script is being called as if I purposefully put errors in my python script VBA will callback these errors when I run the VBA script that calls the python script.

    What is the error in my understanding or my approach?

    Moderator Edit: https://www.xlwings.org/
    Last edited by SamT; 10-29-2017 at 05:47 PM. Reason: Formatted Code

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •