Morning All,

I am opening 6 files in a share drive and then copying the contents onto 1 master book to continue my code. I have embeded the password into the code but as it takes so long to open it seems to skip past that part of the code.

The problem I have is the first 1-2 files appear to open the file ok but when it gets to the 3-4 file it prompts me for the password, although I have coded this into the report.

Is there a way around this type of issue:

''''''Open the data workbook
Path = "\\NETWORKDRIVE\INT$\SHARED\Jan P And L - UK-Europe.XLSX"
Workbooks.Open Filename:=Path, Password:="Monday"
'''''End of Open Workbook


Regards,