Hi

I have a problem with creating a macro that will automatically open a password-protected, shared file *. xls

The following code works only for a file that is not shared
In the case of shared file is still asked for the password (x2)


Set xWb = New Excel.Application

xWb.Visible = True
xWb.DisplayAlerts = False

wbPath = ThisWorkbook.path & "\Sheet1.xls"

xWb.Workbooks.Open Filename:=wbPath, Password:="password"


Do you have any ideas?

Thanks in advance!