How to update Excel with links to password protected Excels using Python

Question

I am trying to update Excel file containing direct links to other Excels to keep it updated. Updated Excel file is protected with password. Function below apply to list of files and their passwords. It works.

def Update_Workbook(file_path, pwd = None):
    try:
        xlapp = win32com.client.DispatchEx("Excel.Application")
        xlapp.Visible = False
        xlapp.DisplayAlerts = False
        xlapp.CalculateUntilAsyncQueriesDone()
        if pwd == None:
            wb = xlapp.workbooks.Open(file_path, True, False, None)
        else:
            wb = xlapp.workbooks.Open(file_path, True, False, None, pwd)
            wb.UpdateLink(Name=wb.LinkSources())
        wb.Save()
        wb.Close()
        del wb
        xlapp.Application.Quit()
        xlapp.Quit()
        del xlapp
    except Exception as e:
        print('Something wrong!')

Unfortunately, file its content is linked to the proceeded file is protected with the same password.

It opens the file, but asking for password of linked file(s), which causes Exception.

I need to unlock (if necessary) all files at once even those linked in cells.

Any idea?

question from:https://stackoverflow.com/questions/66045774/how-to-update-excel-with-links-to-password-protected-excels-using-python

Answer 1

Waitting for answers