Lightning-fast way to manage SOLIDWORKS custom properties from Excel (x64)

[@Xarial]

Similar functionality is now available in the Properties+ (cadplus.xarial.com/properties/). It is not required to request the Document Manager license to use it within the Properties+ and Properties+ can also read and write cut-list custom properties and extract all references and files from the folder automatically. It will also work with any version of Excel

[@Woeliboeli89]

Usefull! is it also possible to read the "Evaluated Value" instead of the Value/text expression of SW?

[@msantos1005]

Excellent work! It is a great tool! Is it possible to change resources/component suppressions, change component configuration in an assembly and change dimensions values? Thank you!

[@Xarial]

I am afraid this will only be possible through SOLIDWORKS API (SOLIDWORKS Document Manager does not support those type of changes)

[@ben.e__9]

Hi, Could this method be used for one part with multiple configurations?

[@SamJohnson-s5m]

Excellent work, thank you. Unfortunately I am having trouble as it is only getting 'custom' prps, whilst 'Configuration Specific' prps are not returning a value. Any thoughts on how to troubleshoot this?

[@SamJohnson-s5m]

SOLVED: =getSWPRP($A2,B$1,state your config name here - ie 'default'])

[@ivanfernandez6480]

Hello! Thank you for upload this content, it's really helpful. I would like to ask you what whould you do in case u had to parametrize a few diferent compenents which are included in a assembly, and their geometry depends of just a few (10 aprox) values. I tried to do that with desing tables but maybe it's not the best way. Thank you again!

[@Xarial]

Thank you for your comment. You can create a macro or app to manage the parameters. Take a look at these examples: blog.xarial.com/vscode-solidworks-api/, www.codestack.net/solidworks-api/getting-started/scripts/power-shell/model-generator/

[@ddaareekk]

Hello, is it possible to implement in this macro GetPreviewPNGBitmapBytes Method for vba? just looking for simple answer, not code itself

The formulas have stopped working after updating to Solidworks 2024. Does anyone know why?

[@austinschukar3400]

Are there settings in Excel that allow the UDF to populate ranges like this? I cannot get the range outputs to work.

[@Xarial]

Yes, you can pass and return ranges via Variant, but if I am not mistaken, this is only available in the latest versions of Excel

[@LowellAndersonJ]

@@Xarial Would you know what version they started including it?

[@paulanzio4343]

Hai good evening, This seems to be very useful but I have one question, by using this can I remove unwanted custom properties from parts and to keep only required custom property for a part....

[@Xarial]

Hi, this macro cannot delete properties, but this tool can: cadplus.xarial.com/properties/

[@ramosmor1]

good afternoon, it's an excellent macro, it would help me a lot with my work, and is it possible to make it work without a developer license? would there be another way?

[@Xarial]

Hello Tiago. Thank you for your question. You can try this tool: kzbin.info/www/bejne/g5mkiH6cp7yWbc0. It is based on similar technology but does not require the key (and it has more features such as cut list properties). This will be a paid tool and it is currently in private alpha with the plans to be released to public beta later this week. If you have any questions please contact us on [e-mail]

[@ramosmor1]

@@Xarial good morning, get the license to use your macro, but it's giving an error, that the = sign, can only be used in operations, what should I do to resolve this issue.

[@Xarial]

@@ramosmor1 Could you please share the snapshot of this error pops up? Is this within the macro or Excel?

[@mikkok7578]

@@ramosmor1 Hey. Did you resolve the issue? I`m having the same problem...

[@ramosmor1]

@@mikkok7578 Good afternoon, I couldn't solve it.

[@QuintusAndreus]

Great job

[@kilsongee]

Nice job

[@ramosmor1]

good morning, I'm trying to use your macro, in the company where I work, but it's not working, all the commands are returning #value, what should I do?

[@Xarial]

Please check the troubleshooting section in the macro article and send me the error you have (this will be a detailed explanation of the issue)

[@wizlike1398]

This worked wonderfully until the latest windows update. Now it just crashes Excel. I don't even get a chance to look for the error. Please help us Artem!

[@davidgrandsombre2441]

Same as you !

[@Xarial]

Simply create new Excel file and copy-paste the macro. Something wrong with Excel macros using COM when Excel is upgraded.

[@codygoss7294]

I've copied your instructions and code word for word, but I keep getting the "Value" error. Do you have any troubleshooting steps?

[@Xarial]

Yes, please follow the 'Troubleshooting' section in the article. Please send me the log error to [e-mail]

[@janandrus1727]

Hello, I´m very interested into this macro to improve my solidworks workflow. I followed your tutor step by step, but I cannot make it works because of VBA problem. When I check it with Immediate window VBA still report "ActiveX component cant create object". I tried every dll registration i´ve found on internet that could cause the problem with NO result. Can you help? Can you guess where is the problem? Win 11 PRO, Office 365 (latest), SolidWorks 2022. Thank you so much

[@Xarial]

Most likely your MS Office is x32 bit (it will only work with x64 bit version of the office). Alternatively take a look at this tool which does not have this limitation and has more features: cadplus.xarial.com/properties/

[@john6653]

Keep getting the error(%1 is not a valid Win32 application)??? I use Solidworks 2021 and DocumentManager: Basic functionality DocumentManager works fine in some other software that i am using.

[@Xarial]

What Excel version do you use? Is this error happened within the VBA macro?

[@nhanlethanh5039]

I installed Document Manager. But I am getting an error "Class not registered" after pasting the document manager key in the code, Please help. Thanks in advance.

[@Xarial]

Do you use 32 or 64 bit office? This error can indicate that you are on 32 bit as Document Manager is only available in 64 now.

[@nakulperane5723]

I am getting an error "Class not registered" after pasting the document manager key in the code, Please help. Thanks in advance

[@Xarial]

You might need to reinstall/install Document Manager. Please follow this link: www.codestack.net/solidworks-document-manager-api/getting-started/create-connection#registering-document-manager

[@deepmind5979]

Hi, I can't get document manager key, can you help me please?

[@Xarial]

Hi Ali, If you have an active SOLIDWORKS subscription, you can request the free key from the customer portal (it is usually 1 business day, but send reminder to support if it takes longer). Unfortunately you cannot get this key (even purchase it) if you do not have SOLIDWORKS subscription. But I will be releasing the commercial tool soon which will have similar capabilities to this macro and you do not need to request the Document Manager key to use this tool. If you are interested please contact me via [e-mail]

[@joaodpsousa]

It's a good solution. But now when i use, after i write the formula, when I press "enter", excel closes and opens the recovered file. Its works goog with SW 2020 and office 2019, and a few months later this error appeared. I allreday update to SW 2021 and reinstall office, request new "Document Manager Key" but the problem keeps up. Thanks João

[@Xarial]

Try create new Excel file and copy macro. By some reasons the macro in Excel does crash after you upgrade Excel version

[@joaodpsousa]

@@Xarial Hello, works goog with new excel file and a macro copy from the web, but after close the excel and open again the same problem again 🤯

[@kilsongee]

Does it work with PDM?

[@Xarial]

Yes, as long as you cache the files locally in your vault. If you want writing to properties - you also need to check the files out. And as SW PDM data cards are based on the custom properties - the changes should be automatically propagated to corresponding data card fields without any additional steps.

[@tamilselvanj2887]

Hii i used your macro but face a error "ActiveX Document can't create a object"

[@Xarial]

Most likely you are using x32 bit version of Excel. Either upgrade to x64 or use this tool instead: cadplus.xarial.com/properties/

[@colthudson6369]

@@Xarial I have the same issue but I am using a x64bit version of excel (2010 Version: 14.0.4760.1000). I have made sure to add the 'SwDocumentMgr 2020 Type Library' reference and I am calling out my file exactly as you show in your video. Am I missing some other reference? Or is this an issue of me using 2010 still?

[@kubawharton]

Not available anymore

[@Xarial]

Make sure you are using x64 bit version of Excel (x32 is not supported)