Does EPDM2011 API support VBA or is VB.NET required?
Does EPDM2011 API support VBA or is VB.NET required?
After considerable searching and several dismal attempts to connect to the EPDM API I've been forced to conclude that it does not in fact support VBA.
I'd like to be able to perform some simple vault tasks from an Excel macro, but it just isn't possible.
Oh well... I'll have to find another way.
Come on Brian where is that "go to" spirit?!
I use Excell all the time to integrate with EPDM, SW macros too. I'll grant there some some things that I can't get to work in VBA (that revision manager object is stupid), but most commands work without any problem.
Heck look at Office2PDM, that is doing a ton of stuff in Excel, Word and Outlook.
I'm ready give me a challenge. Gimme an example of something you cannot do in Excel.
OK, Jeff... you asked for it
If I could read and set datacard variables that would be a great start. Creating and deleting file references would be smashing, also. Those two things would be about 95% of what I want right now.
Ah, well... I stand corrected; and very pleased! The code you posted works well and I got it working with only minor adjustments (you referred to IEdmFolder7 and my version of the library only goes to IEdmFolder6, but it was an easy fix).
I've only played with the reading variables part, but it seems from the code that it may be reading directly from the file, which is OK for Solidworks files, but I don't know if this is going to work if I'm looking for variables of other file types, such as xlsx... In particular I noticed that the GetVar method requires the inclusion of the configuration, but of course this would not be relevant to a non-SolidWorks file. What would you suggest for dealing with them?
I don't see why not as I have used VBScript and PHP. Anything that can use COM should work.