is it possible for epdm admin to set environment variable on all host PCs? With that I mean drive letter %EPDM% = C or full drectory to EPDM?
Why do you think you need to do this? Typically all EPDM operations are unaware of what drive the local view is installed on.
I would need this for referencing in my excel.
I once tried to use the environment variables in VBA SolidWorks macro.
I do not remember why, but at me it did not turn out.
Perhaps because I wanted to place a macro in PDM. And maybe for other reason.
There can be what you want to make has alternative or ready solution in PDM?
What, specifically are you trying to do? If you're looking to create a hyperlink to a document in PDM, then you should probably read this:
Graphics Systems' SolidNotes: How to Use Enterprise PDM's Smart Hyperlinks in Other Applications
Only thing you'd need to be able to do is to query your PDM database to find the IDs for the Project (folder) and Document.
In excel file I am trying to reference from another excel file that's on EPDM. But the fist excel file is also on epdm and it's used by everyone. However not everyone has the same EPDM path as other.
I think reading from registry is a solution. VBA seems to be able to do so.
In that case, it's actually much simpler than all that.
Per that old blog post I linked (from my VAR days):
You can get the path to the vault root from the registry if you want:
HKLM\SOFTWARE\SolidWorks\Applications\PDMWorks Enterprise\Databases\<database name>\ShellRoot
Alternatively, you can use the PDM API method RootFolderPath.
Hi scott, this location is empty in my case.
Retrieving data ...