Custom file property recovery to excel

2D plans Layout
1

Hello;

Smartproperties, via the "property of the summary" tab,  offer to enter the value of a variable directly in the property/custom tab of a file (here a slddrw).

How, and in VBA, can I retrieve the value of the variable "REVISION" from the file (not opened) to enter it in an excel table?

 

2

Can't you do it with the SmartBOM utility and then export the result to Excel?

2 Likes
3
Hello It is possible to access all the advanced properties (Summary tab) using the "Microsoft Shell Controls and Automation" library, see here: http://silkyroad.developpez.com/VBA/ProprietesClasseurs/#LIV-C However, I'm not sure that this retrieves all the advanced properties of a SolidWorks file. In this case and if you have the MyCAD utilities, I advise you to use BatchProperties, which allows you to export all the properties (of all the files in a folder for example) to an Excel file. See in the help, "Saving and reading a list of properties": "[You can] save the list of properties by generating a file in Excel format."
4

Thank you Flegendre;

I already use SmartBom for my classic bills of materials and the management of my MEP sheets, in this case no problems.

My request is for another Excel project of file census of MEP+dwg+pdf to verify their existence or not (See:http://www.lynkoa.com/forum/3d/quelle-mise-en-plan-reste-faire-0?page=0#answer-496652)

SmartBom does not meet my expectations in this area.

1 Like
5

.PL;

Thanks for the answer, I had already tried this model, and it doesn't retrieve all the properties and I can't identify only the names of the ones I want to import.

1 Like
6

Hello

In fact, what do you want to do?

Scan a folder or directory and list existing documents by retrieving their properties?

 

Edit: Try axemble's Excel PilotAssembly workbook.

7

Remrem;

Yes, that's a bit like that;

I created an Excel macro that scans a directory for MEPs associated with my parts/assemblies (if they exist).

(see link to previous message)

This Macro also checks if there are copies of these MEPs in dwg and PDF

My PDF and DWG files include the current hint when saved in their name.

What I want is to be able to compare the latest index of my MEP with that of my pdf and DWG documents to check that my files are up to date.

1 Like
8

I don't really see what "PilotAssembly" can bring to this level.

1 Like
9

PilotAssembly retrieves the properties as you want to. No?

How can you retrieve your revision property on a pdf or dwg file to compare it to that of your slddrw file?

10

Remrem;

I use the BatchConverter utility to save my MEPs in dwg and pdf.

This utility allows you to concatenate the name of the slddrw file with a property:

for example my drawing is called George.slddrw and is at index B

so my *.dwg will be called George_(B).dwg

-> export option, add last characters =_(<And><SW:Revision><And>)

On the other hand, PilotAssembly, as its name suggests, only intervenes on open assemblies, while I am looking to use closed MEPs.

 

1 Like
11
So sorry I don't think there is a solution with Excel or VBA. Batchproperties that I proposed in my first link is the only solution I think.
12

Smartbom can make you bills of materials but can also list files in a directory.

1 Like
13

Phew, it wasn't easy but I managed to solve my problem and without going through the Axembles tools (which are getting worse and worse every year...)

1 Like
14

Hello Maclane,

 

How did you solve your problem?

I also need to retrieve parent/child file properties in order to concatenate a filename but without the files being opened or modified (revision index).

 

Thank you for your feedback