Hello all,

Thanks for reading this. I have experience writing macros in Excel but I don't have any experience with the PDM API. After a lot of searches on the internet I still don't really know where to start, all I have so far is being able to login to the vault. 

What I would like is when I have a filename (file path included, if that helps) to create a conisio hyperlink (ie. conisio://PDM/open?projectid=11895&documentid=214481&objecttype=1) this because the files that have to be opened are PDF's and don't open if they haven't been cached before yet. 

The thing is that I will need the projectID (folder ID) and the documentID (file ID) to make this work. Is there a way to retrieve these via a macro using the PDM API?

Any help at all would be greatly appreciated! 

Thanks in advance, 

Ruud