afternoon all

i have a simple part of my VBA code below

the rest of the code opens / closes various workbooks and moves data around

for the below workbook i can only let 1 user in at a time and the code was working great until today
(i made lots of changes to the macro but on the specific code below i moved the destination of the target file to a shared drive)

i now get the error message box...
MsgBox "A Colleague On your Team is saving there data. Please wait 5 seconds and try again"

but the file is 100% not in use by someone else
the password is correct
the file name / destination is correct
i have tried moving back to the old drive aswell

could anything else be making my macro believe this file is read only???
or can anyone else see an error in there ???

thanks in advance

mike




'set reference to export master
Set EXPORTMASTER = Workbooks.Open("S:\Auth Model\FLT EXPORT MASTER.xls", Password:="LOKI")


'  OPEN MASTER SHEET
    
        
        '   Check to see if file is already open
    If EXPORTMASTER.ReadOnly Then
    MsgBox "A Colleague On your Team is saving there data.  Please wait 5 seconds and try again"

        ActiveWorkbook.Close False
        
        
        Exit Sub
    End If

Windows("FLT EXPORT MASTER.xls").Activate
    Calculate