Create multiple document folders on EPDM using VBA

Hello

I am looking to create a program that would allow me, with the help of an Excel table where the necessary data would have been entered beforehand, a set of files (but not "simple" files, files with a data card).

Concretely, I have to create more than 100 folders in the same place, incrementing as follows: 001_NomDocn°1 / 002_NomDocn°2 / etc... by filling in a data card for each one (see PJ). That's why I'm looking to create this type of program, which can be used later for other cases.

I am therefore looking for a few programs / leads that will allow me to:

- Identify the different attributes of the data card for future use

- to create the "special" folder (I manage to create a "simple" folder in the safe).

Thank you in advance for your help.

Yours sincerely.


carte_de_donnees_du_dossier.png
1 Like

Hello 

You need to create the folder with the PDM APIs, take a look at the API documentation

http://help.solidworks.com/2017/english/api/epdmapi/add_folder_example_vbnet.htm

Otherwise there is a tool in myPDMtools DataRecovery that allows you to create folders from an Excel file and to value PDM artibuts, it also allows you to modify the attributes of the files specified in the Excel file

http://www.lynkoa.com/store/mycadfr/mypdmtools.html

A+

Philippe

2 Likes

Hello Philippe,

Sorry for the late reply, I had a lot of work!

Thank you for your answer, but unfortunately, I can't use VB and can't buy/install these PDM extensions either, which seem very interesting to me...

Any other ideas?

Roman