I am trying to create a macro the finds solidworks files in EPDM but I am stuck on understanding how to make it.

I am trying to write a macro that goes into EPDM finds a file name that matches one on an excel bom and adds it to an assembly.

all i have for this macro is

Sub Search_EPDM()

Dim SWapp           As SldWorks.SldWorks

Dim VaultApp        As EdmVault5

Dim Vault           As IEdmVault14

Dim File            As IEdmFile5

Dim EPDMSearch      As IEdmSearch7

Dim EPDMSearchR     As IEdmSearchResult5

Set Vault = New EdmVault5

'Vault.GetLoggedInWindowsUserID ("MO-Test")

EPDMSearch = Vault.CreateSearch()

EPDMSearchR = EPDMSearch.GetFirstResult

End Sub

I cant figure out how to add the criteria to search or if i can use any of my excising macro for adding components into an assembly

I am also trying to pull information from the file like size and type