search

xarial / codestack

Library of SOLIDWORKS API, SOLIDWORKS PDM API, VBA and Desktop code examples, applications macros and tutorials.
https://www.codestack.net
MIT License
193 stars 71 forks source link

Macro request: Variant of 'Excel macro to manage custom properties' #28

Open schukara opened 3 years ago

schukara commented 3 years ago

Hi CodeStack,

See below for forum question: https://forum.solidworks.com/message/1088036?commentID=1088036&et=watches.email.thread#comment-1088036

I am suggesting that CodeStack creates a variant of your existing macro to also include Cut-List item properties in an Excel command. This functionality would, in my opinion, work well with the existing macro (link below).

If the user is able to implement cut-list items in Excel similar to your existing macro, I'd imagine that they can use their user-form to populate excel with a list of SW Drawing files to read, get external references (SW Part filepaths), then use the excel functions to read their cut-list properties. https://www.codestack.net/solidworks-document-manager-api/document/get-external-references/ https://www.codestack.net/solidworks-document-manager-api/document/data-storage/custom-properties/excel-functions/

schukara commented 3 years ago

For what it's worth, I'm not requesting the whole forum question be solved by this macro (drawing-part association), just the cut-list property functionality with Excel.

schukara commented 3 years ago

I have now received a Document Manager API key and have been able to come up with my own code, although it is not quite as elegant as I'd like - it does work.

If I may add one more request to this macro: Include a tooltip that mimics Excel's formula functionality. I've seen tricks online to allow one to add formula descriptions to the Function Arguments dialog, which is probably adequate, but I thought this would be a neat challenge. Preferably without the introduction of an add-in.