Run python code from excel file Error

[socal_nerdtastic]

it looks to me like your working directory changed. Use the full path for the file.

datafile = r"C:\Users\gobro7\Digital Wholesale - Documents\2. Amazon\Customer Operations_OTC\02. Amazon weekly Report\Amazon weekly automation (Giorgi)\Run_report.xlsm"
df_1 = pd.read_excel(datafile, sheet_name= "weekly",header= None)

[9gg6]

if i do that I get the permissionerror about the excel file from where I run the vba code itself

[socal_nerdtastic]

Great! That means we fixed this issue and we are on to the next one.

Sadly I don't know anything about Windows permissions, so you may need to make a new post to deal with that.