Errno 13 Permission denied while running Python Script through VBA

Question

Although I have verified using Powershell that my system has the necessary permissions to open it, I am attempting to perform some data analysis on an.xlsm file using a Python script that is opened by VBA.

Interested Python file excerpt:

import pandas as pd
import csv

df = pd.read_excel('2020 csv prices_less_till_thu called from vba1.xlsm')
df.to_csv('2020 csv prices_less_till_thu called from vba1.csv')

filename = '2020 csv prices_less_till_thu called from vba1.csv'

with open(filename) as csv_file:

Knowing that this could be a permissions error (have tried the solution to this), I checked, using the Powershell that the file was not restricted in its access:

I nonetheless, while running the VBA module:

Set objShell = VBA.CreateObject("Wscript.Shell")
    
    PythonExePath = """C:\Users\[REDACTED]\python.exe """
    PythonScriptPath = """C:\Users\[REDACTED]\Price analysis\Check 2020 from VBA.py"""
    
    objShell.Run PythonExePath & PythonScriptPath

get an Errno13 error:

Answer 1

According to the error message, the.xlsm file requested by the Python script cannot be opened because it is being used by another process. This may occur if another application is using the file or if the file is already open in an instance of Excel.

Try closing all instances of Excel and any other programmes that could be utilising the file in order to fix this problem. After that, try rerunning the Python script to see whether the issue persists.

You might try utilising the openpyxl library as an all-in-one library for data analysis on.xlsm files. You may read, write, and execute different data analysis activities on Excel files, including.xlsm files, with this library. Moreover, managing macros and VBA code in Excel files is well supported. Here is an illustration of how to read an.xlsm file using openpyxl:

import openpyxl
import pandas as pd
    wb = openpyxl.load_workbook('file.xlsm', read_only=True, keep_vba=True)
    ws = wb['Sheet1']
    data = []
    for row in ws.iter_rows(values_only=True):
        data.append(row)
    df = pd.DataFrame(data, columns=['Column1', 'Column2', 'Column3'])
    wb.close()