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
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!
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?
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!
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?
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!
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/
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....
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?
Hello Tiago. Thank you for your question. You can try this tool: th-cam.com/video/MhAWKfrWc7k/w-d-xo.html. 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 info@xarial.com
@@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.
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.
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
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/
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.
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
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
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 info@xarial.com
@@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?
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.
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
Usefull! is it also possible to read the "Evaluated Value" instead of the Value/text expression of SW?
Hi,
Could this method be used for one part with multiple configurations?
The formulas have stopped working after updating to Solidworks 2024. Does anyone know why?
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!
I am afraid this will only be possible through SOLIDWORKS API (SOLIDWORKS Document Manager does not support those type of changes)
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?
SOLVED: =getSWPRP($A2,B$1,state your config name here - ie 'default'])
Are there settings in Excel that allow the UDF to populate ranges like this? I cannot get the range outputs to work.
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
@@Xarial Would you know what version they started including it?
Hello, is it possible to implement in this macro GetPreviewPNGBitmapBytes Method for vba? just looking for simple answer, not code itself
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!
Same as you !
Simply create new Excel file and copy-paste the macro. Something wrong with Excel macros using COM when Excel is upgraded.
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?
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)
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!
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/
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....
Hi, this macro cannot delete properties, but this tool can: cadplus.xarial.com/properties/
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?
Hello Tiago. Thank you for your question. You can try this tool: th-cam.com/video/MhAWKfrWc7k/w-d-xo.html. 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 info@xarial.com
@@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.
@@ramosmor1 Could you please share the snapshot of this error pops up? Is this within the macro or Excel?
@@ramosmor1 Hey. Did you resolve the issue? I`m having the same problem...
@@mikkok7578 Good afternoon, I couldn't solve it.
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.
What Excel version do you use? Is this error happened within the VBA macro?
I've copied your instructions and code word for word, but I keep getting the "Value" error. Do you have any troubleshooting steps?
Yes, please follow the 'Troubleshooting' section in the article. Please send me the log error to info@xarial.com
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
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/
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.
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.
I am getting an error "Class not registered" after pasting the document manager key in the code, Please help. Thanks in advance
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
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
Try create new Excel file and copy macro. By some reasons the macro in Excel does crash after you upgrade Excel version
@@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 🤯
Hi, I can't get document manager key, can you help me please?
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 info@xarial.com
Nice job
Great job
Hii i used your macro but face a error "ActiveX Document can't create a object"
Most likely you are using x32 bit version of Excel. Either upgrade to x64 or use this tool instead: cadplus.xarial.com/properties/
@@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?
Does it work with PDM?
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.
Not available anymore
Make sure you are using x64 bit version of Excel (x32 is not supported)