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.