I managed my woodworking projects via an Excel spreadsheet which provides me a ton of information about my project including such things as a cut list, weights and moments of inertia. Part of this process involves going back and forth between Excel and SKU 2017. I will use the SKU tape measure to get a measurement then go back to Excel to enter it.
It would be nice to have an assignable hot-key or a right click context menu in SKU to copy the value of the tape measure to the Windows clipboard so I could just paste it into my spreadsheet.
I don’t know if the SKU API’s will even support this.
Would anyone be interested in developing this tool - if possible?
Thanks - Rick
Thanks - but the scope of what my Excel spreadsheet does is massive and way beyond the scope of this conversation. A cut list is only one small thing. What I really need is a way to get the value of the tape measure into the windows clipboard.
Nice idea but Excel, by design, will not let a sub-ordinate container write to its parent container. You would have to pass the address of the consecutive cells to the SKU function - but the SKU program would be outside of the Excel object model so I just don’t see how that would work.
It would be nice to be able to select a component, execute something and capture all three dimensions and the volume in one key stroke - maybe each value space delimited and the result copied to the clipboard.
Then inside the Excel spreadsheet, you could have a cell function that reads the clipboard and parses out all four values and loads them into each cell.
Thanks for chipping in Jim - I like your thinking.
I never heard of AutoHotKey. After a brief perusal of its features it could easily be used with Excel to extract and parse clipboard contents. All we would need is a SKU tool to put the 3 dimensions and volume of an object that has focus in the clipboard; space delimited.
Dan - I am sure there are many ways to skin this cat. I really do appreciate yours and everyone else’s feedback on how I might solve this problem,
I do know that integrating back into Excel the way you suggested would be complicated and not as easy as it is to say.
The only programming I do these days is in C++ and VBA inside MS Office applications like Excel for my own benefit. I do maintain a few command line apps I have scattered around many ex-clients. I am retired and I really do not feel like learning yet another programming language after 40 years of writing code.
I either misunderstood the purpose of this community and in that case I apologize for wasting everyone’s time.
Otherwise I obviously did not make my opening statements clear.
So let me be clear - I am looking for someone to do this coding for free or for fee.
The main problem is that the native SketchUp tools do not have much interface via the API.
We can tell when they are activated and deactivated, but that is about it. The toolstate property is worthless now as all the events are queued up and dumped after the tool operation is complete.
Basically it means whenever we want to interface with a tool, we have to write a full-blown clone in Ruby or C. So this means someone will have to write a clone of the MeasureTool.
Anyhow, if you use the DimensionTool instead, you can double click the values, and use that context menu script I linked above, to get a copy command onto the SketchUp context menu. (Which puts the value onto the Clipboard.)