In a new VBA macro, add a reference to PDMWorks Enterprise 20XX type library. Then use the code below. Replace the inputbox line with a hard-coded vault name if needed.
Dim conn As EdmVault5
Set conn = New EdmVault5
Dim vaultName As String
vaultName = InputBox("Enter vault name:")
Call conn.LoginAuto(vaultName, 0)
MsgBox "Vault root folder: " & vbCrLf & conn.RootFolderPath
That's what i needed, tweaked it a bit & dropped it in & it works great!!
thanks for the remind, I just marked Michael 's reply was correct.