I can help with that. It's vb.net and it will take a few minutes to dig it up.
That's awesome! Thanks....
It's setup as a menu command but can easily be converted to execute on state change. I have used this numerous times with templates and various other quick tasks.
There are two sections of code:
- Open existing Word doc, add text, save, & close.
- Open new Word doc, add text, save, & close.
You'll need to handle the code for checking out/in. I don't have code for creating PDF but I have seen some.
Ok, here it is!
<Removed attachment due to being incomplete>
I tried to upload the dlls into the ePDM Administration but got some error messages that the files cannot be loaded.
which of the files supposed to be the one to be use?
Could you Upload new Zip file of the relevant file (as a close application)?
I manage Word documents (linked to the vault using Custom properties and fields on the Document), but in order to update these Fields use the "AutoOpen" + "Save Active Doc" and "Close Active Doc". This is Manual Action
Could you mange your application to do this (Open-->Update Fields-->Save-->Close) to be used with ePDM Task?
Just to clarify, this DLL will not do what you are wanting to do as is.
- This addin is programmed to run when the "Tools > OpenWord" pull-down menu is clicked
- The addin opens a new Word file
- Inserts some the phrase "This is how it's done. Sup dawg!? :-)"
- Saves & closes the Word file
To answer your question, you need to load the "OpenWord.dll" & "Interop.EdmLib.dll" files.
The code is merely a starting point without a lot of content. It needs work and customization for each person's specific needs and since Joy is a programmer I knew she could finish writing the code to do what she needs.
I also try to avoid posting specific code on updating DocProps or CustomProps because I don't know the specific way each person manages their properties either through cells, named ranges, bookmarks, or whatever.
Lastly, to make the add-in fit your specific needs, the add-in needs to filter out "which" word document or excel file to take action on, otherwise the addin will act on every document or excel file flowing through your EPDM system.
Then the addin can filter which files to process by a parent folder (i.e. "\Engineering\ECOs\" or "\Production\Job Cards\" or "\Parts Room\Parts BINs\"), source state & destination state, document name (i.e. "ECO-" or "JC-" or "BIN-" assuming the files are named ECO-9999, JC-9999, BIN-9999, etc.), when files are added, copied, deleted, shared, etc. or any combination of all of these.
Orionl, if you want to make a specific customized add-in, contact me by PM and we can work out the details.
Best regards gang,
Just to be clear, I am NOT a programmer (more like a hack). For anything serious I consult an expert.
Woops. Hey, sorry bout that. With that in mind, I may need to finish this out a little better.
Joy, see if this does the trick.
This teaser custom EPDM add-in to open & save Microsoft Word document(s) during a transition to the 'Pending Approval' state.
NOTE: This add-in makes the assumption your word file will use VBA to push updated values into the word file. Otherwise the addin will issue the checkin after trying to save the Word file but EPDM won't see a difference in the file being checked in compared with the one checked out and EPDM will issue the undo checkout command.
- Load the OpenWord.dll and Interop.EdmLib.dll if you add a "New add-in" in the EPDM admin tool
- Load the OpenWord.dll only if you add a "Debug add-in" in the EPDM admin tool
There is a brief teaser messagebox that runs each time it is called but only runs once per transition even if transitioning 50 files.
OpenWord.dll is a product of equivaQ Software, LLC.
OpenWord.dll software is provided as-is and without warranty express or implied.
For more info about products and services visit www.equivaq.com
OpenWord.zip 69.1 KB
If works if I'm logged in as the admin user but not as a regular user. How do I fix this?
I figured it out... users must have Check out file permission at the Pending Approval state.
Works awesome then