Get file variable values from PDM to Excel using VBA

Hi all,

I have an Excel file containing a list of file names and I want to create an Excel macro that will loop through all file names and send variable values to cells in Excel.

I have never been a programmer, so even VBA is on the advanced side, but i have some sample macro codes to help me. Problem is they are all based on one thing; the folder path is already known, as a static value, or part of the Excel data. Since i have only file names (i assume unique file names in vault), i can't seem to find a valid folder object. I know there are more than a few programming savvy members here, so i'm reaching out...

I have something like this:

     Dim oFile As EdmLib.IEdmFile7

     Dim oFolder As EdmLib.IEdmFolder6

     Set oVault = New EdmLib.EdmVault5

     Dim sFileName as String

I can log in fine, and i can read my Excel Sheet

     sFilename = Range("B" & i).Value

But then my struggle begin, how do i set oFile and oFolder objects using the information i have in sFileName?

Thank you in advance.

SolidworksApi macros