[VBA]VBA调用Python

import xlwings as xw

def DailyAward():

    # 配置表读打开

    app = xw.App(visible=False, add_book=False)

    app.display_alerts=False

    app.screen_updating=False

    wb = app.books.open(r'C:\Users\Administrator\Desktop\数值模板相关\配置表\Mod_Level.csv')

     
    # 配置表读取
    level = wb.sheet[1].range("B6").value = outPut_ticket;


    # 配置表写入
    xw.Book.caller().sheets[3].range("B6").value = outPut_ticket;
    xw.Book.caller().sheets[3].range("B7").value = input_BaseLevel;
    
    #配置表存储离开
    wb.save()
    wb.close()
    app.quit()

    

Private Sub CommandButton1_Click()
    RunPython "from myproject import DailyAward; DailyAward()"
End Sub