file.open with password when file is open elsewhere

[DiegoTurpentine]

Hi,

This is driving me mad. Have written some VBA code to open a specific file and do some things. If it opens in read only mode, then it closes the file, waits 5 seconds and reopens on a loop until it gets in with write access. Which is fine, the file is only accessed very briefly to populate with production data, but multiple times a day from multiple production files.

However, we now have a password on the file, which I've added to the code and it works fine, except when another person is already in the file. Then it asks the user for the password which I can't have. I'm sort of sure it's related to the additional 'file in use' box which would appear if you tried to open a password protected file and somebody else was in it. I can't get around it though.

Any ideas?

Cheers

 

[Trevor_S]

Have you tried putting Application.DisplayAlerts = False before the code to open the workbook, and Application.DisplayAlerts = True once it has successfully opened? This should prevent the warning message being displayed, and just select the default option - which is to open as read-only.