AnsweredAssumed Answered

VBA error Lock and Unlock file

Question asked by David Watkins on Jul 8, 2019
Latest reply on Jul 8, 2019 by David Watkins

I am making an Excel VBA macro to update data card values, everything but checking in and out. I keep getting errors when trying to lock or unlock the files. 

 When locking a file and getting this error but the file gets checked out to me correctly. When unlocking I get the error but the fill is not checked in. SW is not open and I don't have the file "open" in PDM so I don't have any ideas what app could have it opened? I have rebooted and all that fun, any ideas?

 

Set File = Vault.GetFileFromPath(Result.Path, folder5)

If File.IsLocked Then
   If File.LockedByUser.Name = user.Name Then
      setvalues Variable, Value
      File.UnlockFile 0, "" 'Error

   End If
Else
   File.LockFile folder5.ID, 0, 0 'Error
   setvalues Variable, Value
   File.UnlockFile 0, ""
End If

 

Thanks,

David

Outcomes