这是我正在尝试运行的VBA代码：

Option Explicit
Sub RunPythonScript()

'Declare Variables
Dim objShell As Object
Dim PythonExe, PythonScript As String

'Create a new Object shell.
Set objShell = VBA.CreateObject("Wscript.Shell")

PythonExe = """C:\Users\me\AppData\Local\Programs\Python\Python39\python.exe """
PythonScript = """C:\Users\me\test\VBAult\auth.py"""

'Run the Python Script
objShell.Run PythonExe & PythonScript, 0, True

MsgBox "Executed!"

End Sub

这是我的Python代码：

import pandas as pd
from pandas import json_normalize
import requests
import json

url_auth = 'https://api-gateway.com/uaa/oauth/token'

payload_auth = {'grant_type': 'client'} 

username = "username"
password = "password"
  
response_auth = requests.post(url_auth, auth=(username, password), data=payload_auth)
 
data = response_auth.json()

url_f = 'https://api-gateway.com/api/test'

headers = {
    'Content-Type': 'application/json',
    'Authorization': 'Bearer '+ data['access_token'],
}

payload_f = json.dumps([
  {
    "operation": "xxxxx",
    "reference": "xxxxx",
    "status": "xxx"
  }
])

response_f = requests.get(url_f, headers=headers, data=payload_f, verify=True)

json_data = json.loads(response_f.text)

df_json_data = pd.json_normalize(json_data)

df_json_data.to_excel('C:\Users\me\Downloads\convertjson.xlsx', index=False)

它进行一些API调用，并在最后将JSON响应转换为Excel文件。当我从我的笔记本执行它时，它工作得很好，但是当我使用上面的代码从VBA执行它时，它什么也不做。只返回msgbox，但不创建我需要的excel文件。
如何通过使VBA和我的Python脚本一起工作来归档我所需要的内容？