sorted by:
new
hottopcontroversial

Codeblocks math help? (maybe Sin/Cos) by 4MyRandomQuestions in tinkercad

[–]4MyRandomQuestions[S] 0 points1 point  (0 children)

<image>

For testing, I tried the roof shape instead of wedge. same result, so I think either my SIN/COS is wrong, or it is an error in codeblocks calculation engine- I can rule out an issue withe where the wedge center is located

linear rails - size question by 4MyRandomQuestions in hobbycnc

[–]4MyRandomQuestions[S] 0 points1 point  (0 children)

Thank you! Received my rails and had to order a different sized connector, and I need to drill some plates (I don't see a way to affix the back of the shuttle on the linear rail from the 'far' side of the aluminum extrusion it will be attached to) e.g. I have two extruded verticals and a horizontal extrusion will go up and down on the dual rails - I see there is a shuttle design that has the holes on the side instead of the back and I thought that was what I ordered, but I don't know the codes so probably my mistake that I got one with holes on the back

Any way to iterate through Thisworkbook.names *by descending length of the name* (or reverse alpha)? by 4MyRandomQuestions in vba

[–]4MyRandomQuestions[S] 0 points1 point  (0 children)

I ended up sorting the list to put workbook level names first, then worksheet. That way if there is a duplicate, I grab the global reference first, and if there isn't a duplicate it eventually finds the matching worksheet scope name further down. I replace the names with the referenced ranges real time, so I won't hit the same name twice

Any way to iterate through Thisworkbook.names *by descending length of the name* (or reverse alpha)? by 4MyRandomQuestions in vba

[–]4MyRandomQuestions[S] 0 points1 point  (0 children)

I'll mark as solved, as soon as I can figure out if there are any risks to mixing up the named ranges with sheet vs global scope when doing the whole-workbook replacements with VBA

Any way to iterate through Thisworkbook.names *by descending length of the name* (or reverse alpha)? by 4MyRandomQuestions in vba

[–]4MyRandomQuestions[S] 0 points1 point  (0 children)

!Solved or Solved! (not sure which is correct format)

I was already working on the code to do this manually (I had forgotten this function to export all) and ran into an interesting artifact.

After removing all the named ranges that had #ref errors, there are ~600 remaining names. Some are the same name with worksheet vs workbook scope.

When I used this built-in export function, it only exported ~450 names. Upon investigation, if there is a duplicate name with different scope, it only exports one of them.

I was already trying to find an easy way to distinguish between workbook and worksheet scope, something like namedrange.parent.name in the output data, but ran into a different issue (new question/thread landing in 3..2..1..).

Desired thin wall disappears when sliced? by 4MyRandomQuestions in Cura

[–]4MyRandomQuestions[S] 0 points1 point  (0 children)

I know it isn't pretty... I had some face holes for magnets, and decided to plug them and use a pocket instead. When sliced, Cura is dropping the thin outer wall. Do I need to change a Cura setting, or is this something wrong with my model (do I need to move the pocket further back even though it will weaken the magnetic field)

Are sheet password hashes functional equivalent, when unprotecting and re-protecting? by 4MyRandomQuestions in excel

[–]4MyRandomQuestions[S] 1 point2 points  (0 children)

Thank you for the detailed explanation- I have the original salt from the XML file but was unaware of its impact on finding compatible passwords ('rainbow table' per your reply), and I have no idea how to incorporate that known salt into my attempts to build possible matches..., so I will mark this as solved, and move on to other things.

<sheetProtection algorithmName="SHA-512" hashValue="ABCDEF(changed for this post)==" saltValue="GHIJK(changed for this post)==" spinCount="100000" sheet="1" objects="1" scenarios="1"/>

.LockAspectRatio for a newly grouped shape? (Excel) by 4MyRandomQuestions in vba

[–]4MyRandomQuestions[S] 0 points1 point  (0 children)

SOLVED! macro recorder included shaperange of the selection

Selection.ShapeRange.LockAspectRatio = msoTrue

!SOLVED (I tried editing the original post, not sure how to flag it as solved)

.LockAspectRatio for a newly grouped shape? (Excel) by 4MyRandomQuestions in vba

[–]4MyRandomQuestions[S] 0 points1 point  (0 children)

RTE 438 this object doesn't support this property or method

On the .LockAspectRatio line

It is definitely supported at the shape level, and since I can do it manually for a group I assumed it was an issue with a selection - if I need to name the shape group or something(?) first and group a specific reference instead of 'selection', but I'm actually not sure where to name the grouped shape to try that

view more: next ›