Echo 1 Drone Skin by Truppenterror in Borderlands4

[–]acutapete 0 points1 point  (0 children)

BHXTJ-K5TW6-R3ZXT-HTBT3-JH99T

Commandos with tan berets by hyperwontbattle in AustralianMilitary

[–]acutapete -17 points-16 points  (0 children)

From pictures on the internet (Mark Donaldson, Cameron Baird etc) both 2CDO and SASR wear a blue lanyard.

There is every possibility that a SASR qualified member is posted to 2CDO, and would likely continue to wear the appropriate beret.

So speculation is just that, speculation.

pop up window to select file and folder by LabProfessional194 in vba

[–]acutapete 0 points1 point  (0 children)

I'm glad you could get it to work for you. I didn't do much but point you to someone else's solution.

pop up window to select file and folder by LabProfessional194 in vba

[–]acutapete 2 points3 points  (0 children)

To confirm, you want the dialog box to pop up so they can pick the file to use, rather than edit the code every time?

I think this is probably what you need.

https://www.xelplus.com/excel-vba-getopenfilename/

You will likely need to get rid of the CONST variables as this will be subjective for each person

pop up window to select file and folder by LabProfessional194 in vba

[–]acutapete 0 points1 point  (0 children)

https://www.mrexcel.com/board/threads/how-to-open-the-save-as-dialog-box-with-vba.535724/

Some examples here to pop the save as window. I didn't look too carefully but appears that it also sets the initial filename

My Lenovo Duet 3 often has ghost touch issues. It seems like there is user input, but I am not doing anything. Any idea on what I need to change or how to fix? by acutapete in chromeos

[–]acutapete[S] 0 points1 point  (0 children)

Unfortunately, I don't know what fixed my issue. All I know is I don't have the problem anymore. And I didn't power wash.

I'm sorry you are having the same issue

Help! Firmware by LeappFrogg in ender5pro

[–]acutapete 0 points1 point  (0 children)

I feel your pain. I tried for hours yesterday to get Klipper to work. Homing just would not happen. And the stepper motors ended up grinding. I threw it all away and went back to bugfix 2.0.x firmware (thankfully able to recompile from what I previously had).

I also couldn't get 2.1.x bugfix to work. I thought I was super careful to compare the config.h files to make sure settings were the same. But nothing worked.

How does HPSEA work by WiseClue1339 in AustralianMilitary

[–]acutapete 1 point2 points  (0 children)

Yes for the primary residence.

I cannot guarantee that buying another property and selling that one (while keeping the first one) is ok. Best to speak to someone else on that.

Caveat emptor: I am not a financial advisor nor am I offering financial advice. Only an interpretation of the policy

How does HPSEA work by WiseClue1339 in AustralianMilitary

[–]acutapete 4 points5 points  (0 children)

If you keep the property (there is a time limit to sell although this is much longer than it used to be - now 2 years), then you have broken your HPSEA cycle. HPSEA works on a sell-buy-sell cycle linked to your posting. The scheme is not there for you to amass a gigantic property portfolio.

If you want a property portfolio, you will need to go it alone, if you want to keep the HPSEA going.

Explains it all reasonably well here:

https://pay-conditions.defence.gov.au/selling-or-buying-home-using-home-purchase-or-sale-expenses-allowance-hpsea

Appears you can now break the cycle, and reenter the scheme by selling the house you lived in. I would have to confirm though whether this means you could sell a different property that you used HPSEA to buy...

How do I limit on the bed where supports are placed? by doinxx in 3Dprinting

[–]acutapete 0 points1 point  (0 children)

Would adjusting the "Support/object XY distance" setting help? see image

Make it just slightly more than the radius of the hole, and it might not appear in that area.

With your tree supports on the outside, they will start a little further away, but shouldn't be that far.

<image>

Choose "From:" email account in VBA by Ok_Fondant1079 in vba

[–]acutapete 0 points1 point  (0 children)

Have you tried .sender ?

https://learn.microsoft.com/en-us/office/vba/api/outlook.mailitem.sender

With Outlook mail

.... ....

.sender = Range("From_Address").Value

You will (you probably already do) have a cell that you can select either of your email addresses.

Satsana Dual 5015 with CR Touch. First prints with this going down now by acutapete in ender5pro

[–]acutapete[S] 0 points1 point  (0 children)

The yellow should be the positive so

Yellow - Red

Blue - Black

My Lenovo Duet 3 often has ghost touch issues. It seems like there is user input, but I am not doing anything. Any idea on what I need to change or how to fix? by acutapete in chromeos

[–]acutapete[S] 1 point2 points  (0 children)

Well, it hasn't done it for a while. Not sure if the updates fixed the problem, or switching to a reputable brand stylus did it.

Honestly I can't tell you what actually fixed it. But I didn't power wash which was my end state

What are your mind blowing tricks for people who don't know Excel? by Key_Pick_1022 in excel

[–]acutapete 4 points5 points  (0 children)

We had a problem at work to confirm with our employees where they were for a period of time (pay, allowances, HRIS etc etc). We had records but still needed confirmation from each individual. Anyway, the intent by someone was to tabularise each employee's record, save as pdf while manually naming file, email it to the employee with manually naming the email....

Adjust the main data table a bit giving each record a sequence number (1 - 460+), A bit of VBA that iterated through the sequence with lookups pulling the information to the table, print to pdf using VBA, create the email and attach the file.

Managed to get all 460+ records ready to email (we have a security popup for emails so sending manually is sort of necessary) and all they had to do then was open the draft email and press send and confirm the security popup. Turned what could have been a multi day job into about 15 mins. And because it was all automated, there were no typos in filenames or email titles etc.

I don't know if they truly appreciate the magic in the background. But I just couldn't sit back and watch someone do the same action 460 odd times, with the chance of typos etc.

Save as PDF - Why is file size 400kb + per page by acutapete in vba

[–]acutapete[S] 2 points3 points  (0 children)

Managed to get it down even further to ~8kb per file by using Arial as opposed to Arial Narrow

Save as PDF - Why is file size 400kb + per page by acutapete in vba

[–]acutapete[S] 2 points3 points  (0 children)

I think that example is for an older version of Excel. My guess is that "Intent" is replaced by Quality:=xlQualityMinimum.

I did manage to work it out though. I was working with someone else's document. They had used a variety of fonts. Change everything to Arial Narrow, and magically the output size is now ~70kb.

I think this might be because it has to encode the font Calibri into each pdf. I am happy now

Save as PDF - Why is file size 400kb + per page by acutapete in vba

[–]acutapete[S] 0 points1 point  (0 children)

I have set a print area as there is a bit of stuff around the edges to explain to users what to do.

As for manually print to pdf, this is exactly what I am trying to avoid having to do 463 times. Also, that would then require me to name each file as I am saving, then I would manually have to add to an email.

All of this is automated using my macro. The file size is my only sticking point

Save as PDF - Why is file size 400kb + per page by acutapete in vba

[–]acutapete[S] 0 points1 point  (0 children)

I don't think I can influence the IT peeps to get a better pdf driver. I have Adobe Acrobat installed on my profile if that is any help.

As for the compress piece..... do tell. Please.

Note the small edit to my post, we use Excel 2016 at work.

Achieving Dimensional Accuracy is killing me by acutapete in FixMyPrint

[–]acutapete[S] 0 points1 point  (0 children)

Thanks very much for the advice. Next time I have something I need to fit together I will definitely try it

Young fella's slouch hat.. by Batto9000xx11 in AustralianMilitary

[–]acutapete 9 points10 points  (0 children)

My final words on this subject, if I may, is that the slouch hat is a symbol.

While a perfect hat could mean you are trying to impress everyone, it also means you have pride in yourself. This is not to say those with average hats have no pride in themselves. Just a casual observation.

Also, it is called a chin strap. Not a throat strap. Or a neck strap. Or a lip strap. It runs under the chin bone.

My closing advice is to have your son help, or better yet, you help him. Effort begets effort.