I'm trying to connect Excel to the EPDM vault so I can click on a cell with a part number and open the .sldprt in Solidworks. I've had limited success but am seeing a very weird thing happen. My script doesn't find the files until I manually find them in the vault AND CLICK ON IT TO START THE PREVIEW. Once I've previewed the file, my code can see it. I'm not creating a vault object, just using typical search code.
Is someone else doing something like this and if so, is there a way to code VBA to give me the results without manually touching the file?