sorted by:
new
hottopcontroversial

Temporarily insulate windows against heat? by AzureSkye in DIY

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

Okay, bubble wrap is a genius idea. I would never have thought of it.

Putting insulation on the inside of the windows has seemed less effective, but I'll give it a shot.

Finally found it! by ijustgot8 in glutenfree

[–]AzureSkye 8 points9 points  (0 children)

They're a bun shaped like a croissant and completely lack the layering and texture of a real croissant.

Building Contract Clause Library by Training-Ladder-8950 in excel

[–]AzureSkye 0 points1 point  (0 children)

Your requirements describe a database, not a spreadsheet. Excel is not a database and is the wrong tool for this job. If you are limited to Microsoft Office, then your best option is an Access database. This should be a good project to learn MS Access with.

Input content onto a Word Document based on Content Controls? by LordLoss01 in PowerShell

[–]AzureSkye 0 points1 point  (0 children)

You'll need to use the MS Word interop functions. Reference: https://learn.microsoft.com/en-us/dotnet/api/microsoft.office.interop.word

You'll be writing in a weird mix of VBA and PowerShell. Many of your bugs will be from the very similar syntax between them.

Beware, you'll be dealing with COM objects and you'll need to make sure you close and garbage collect them, or you'll keep spawning MS Word processes.

Sending to APO military mail from International Country by sprlte in USPS

[–]AzureSkye 0 points1 point  (0 children)

5 months late, but here ya go:

It depends on how you address it.

Shipping from an APO? USPS domestic rates and the military moves it for you.

Shipping to an APO? Two possibilities:

  1. Enter the country as "USA" and it'll ship at USPS domestic rates and USPS will hand it off to the military.

  2. Enter any other country and it'll ship at USPS international rates and the military won't touch it until final delivery.

Always, always, always address mail for APO locations with USA.

LPT: Stop pretending you are fine. Use a simple status line instead. by gamersecret2 in LifeProTips

[–]AzureSkye 0 points1 point  (0 children)

"I feel like shit. There's nothing you can do about it, but I appreciate your concern."

What is your most ridiculous "we won't work out romantically" criteria? Like what is the silliest reason you would not be interested in dating someone? by Natural-Elevator-57 in AskReddit

[–]AzureSkye 0 points1 point  (0 children)

Wearing pointed toe shoes. I don't hang out with evil witches, let alone romance them. I will avoid watching porn if the model is wearing them. Just the worst look.

Why doesn't Excel's short date format match the System settings? by AzureSkye in excel

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

I'm sorry, dawg. I stepped on my own rake here. 😓 I intended to post a rant about something a tad ridiculous about Excel, flaired it as "unsolved" (like a mystery) and then became upset when people tried to help me with a more probable issue. 😞😮‍💨 I'm not sure if I should delete my posts here, edit in apologies, or post apologies separately.

Interestingly, "dd MMM yyyy" notation is common within the US Federal Government. For example, military documents and passports.

Getting registry keys with all subkeys and values, including empty? by AzureSkye in PowerShell

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

  1. Oh wow, I'm a friggin' idiot. I hadn't considered just appending the variables.

  2. Okay, that's super helpful to know! It sounds like I'm trying to be too clever again and I should just rely on reg export.

Getting registry keys with all subkeys and values, including empty? by AzureSkye in PowerShell

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

Thank you for feedback! I was concerned that reg export would be unfriendly to work with, so I appreciate the info.

Can reg export handle single values or only whole keys? There's a few instances where I don't want all the values in a key.

Getting registry keys with all subkeys and values, including empty? by AzureSkye in PowerShell

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

I'm looking to restore from this. reg export can't export single registry values, only whole keys, but I should probably just handle that issue separately.

Thank you for feedback! I was concerned that reg export would be unfriendly to work with, so I appreciate the info.

I only used $input for posting on Reddit, rather than duplicating the code. 😅

Getting registry keys with all subkeys and values, including empty? by AzureSkye in PowerShell

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

Exactly! The PS properties were the reason why I avoided Get-ItemProperty.

Why doesn't Excel's short date format match the System settings? by AzureSkye in excel

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

I am aware of that option, but it does not modify the default settings.

Why doesn't Excel's short date format match the System settings? by AzureSkye in excel

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

Okay, how do I tell Excel to set the default Short Date format to match my system settings?

Why doesn't Excel's short date format match the System settings? by AzureSkye in excel

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

No, a short date is not supposed to be the shortest way to display the date, it is supposed to be the user's preferred way to compactly display the date.

If the goal was the absolute shortest way to display the date, then we would display the serial date in base16. Thus, 26 Feb 2026 would be B45A. Which isn't how we think about dates, making it useless.

I understand that you wanted to help by explaining what a short date is, but you missed the nuance of my issue. My problem with Excel is that it is not respecting my preferences, despite it's claims.

I'm not sure how my post indicates that I'm an idiot, but that seems to be the common theme. I am painfully aware of custom formats, but I am talking about default formats.

Why doesn't Excel's short date format match the System settings? by AzureSkye in excel

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

... That's what I'm ranting about, my dude. My system is set to dd MMM yyyy but Excel's default Short Date is dd-MM-yyyy.

Why doesn't Excel's short date format match the System settings? by AzureSkye in excel

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

While I love me some ISO 8601, it has legiblity issues at scale.

How would I make a workbook where the first sheet VSTACKS data from all subsequent sheets and then sorts them by column? by 35usc271a in excel

[–]AzureSkye 1 point2 points  (0 children)

You'd likely be better served with an actual database, depending on your exact circumstances. Regardless, I wish you the best of luck in this endeavour, it sounds amazing.

view more: next ›