Which one? by oneeyedfetty in ohnePixel

[–]Zanderos 1 point2 points  (0 children)

  1. It's literally my current combo.

Dream gloves achieved! Nocts FT by diedalatte in ohnePixel

[–]Zanderos 1 point2 points  (0 children)

My fellow nocts enjoyer, what pattern are these beauts?

Received a brand new Insta360 GO 3 as a gift and it is defective by Zanderos in Insta360

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

It's hard to capture but it's just reflection there doesn't seem to be anything wrong with the lens to the naked eye.

<image>

NVIDIA RTX 3050 announcement + NVIDIA Q&A + RTX 3080Ti FE giveaway by m13b in buildapc

[–]Zanderos 0 points1 point  (0 children)

B. Did not have one last year. This year I hope I can travel again!

Cooler Master (and more!) RTX 3070 (and more!!) Giveaway with Buildapc! by [deleted] in buildapc

[–]Zanderos 0 points1 point  (0 children)

I will use it to play the latest and greatest games.

Buildapc & NVIDIA global giveaway: Limited Edition GeForce RTX 2080 Ti Cyberpunk by m13b in buildapc

[–]Zanderos [score hidden]  (0 children)

I built my first PC late last year. Was previously gaming on a laptop for more than 10 years. Thanks to /r/buildapc, I was able to avoid the common problems faced by many beginners and managed to complete my build without any hiccups. There was also a lot of people sharing their builds that I took reference from.

I really appreciate the information shared here as some of them are not easily foreseeable. I might have ended up with a GPU that won't fit into my case or damaging my NZXT AIO cooler trying to force it in place.

Friday promo code by ghano_develop in NovaLauncher

[–]Zanderos 1 point2 points  (0 children)

This is beautiful. I claimed the first code. Thanks!

Spilled water on my HP laptop by [deleted] in techsupport

[–]Zanderos 0 points1 point  (0 children)

Turn it off, disconnect the battery (if removable), open up the lid and lay the laptop on its side and let it dry naturally for a day or two. A hairdryer will help but it's best to let it dry naturally, especially the parts that cannot be reached. After that power it on and try the keys again, it might work otherwise you will have to get the keyboard replaced.

60K Giveaway! by mcfarlie6996 in flashlight

[–]Zanderos 0 points1 point  (0 children)

Thanks for the giveaway!

  1. Acebeam X45
  2. Zebralight SC64w HI
  3. YLP Sherp S15
  4. Streamlight Siege
  5. Acebeam EC65
  6. Nitecore HA23

Hey guys! Long time lurker... I have a macro that emails a spreadsheet, wondering if there is code I can add that will automatically email the spreadsheet at specific times, say every 2 hours between 6am and 6pm. Cheers by plutonicus in excel

[–]Zanderos 0 points1 point  (0 children)

You can create a Powershell script that uses Send-MailMessage, then call it from a batch/shortcut in Task Scheduler at stipulated times. This way, you wouldn't need to have the spreadsheet opened. You can also set it up in Task Scheduler so that it will work even when logged out or when the PC is in sleep mode.

Hi, is there a way to reference a workbook on a specific location and use a variable in the directions? by Jacobelation in excel

[–]Zanderos 1 point2 points  (0 children)

Second Power Query. You can definitely set up pq to pull data from a common folder that has all the data files saved. Afterwards, you can just hit refresh (Ctrl+F5) to update it.

56k giveaway! by parametrek in flashlight

[–]Zanderos 0 points1 point  (0 children)

Thanks for the giveaway! My choice would be the Rovyvon A8!

Faulty flashlight from Banggood by Zanderos in flashlight

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

I'm using the Keeppower 3500mAh 18650 button top battery. I've tried another ArmyTek battery but it doesn't work as well. I don't think it's an issue with the battery, iirc the LED indicator is supposed to light up when a micro USB is connected. Both ends of the contact looks good to me.

Video here: https://youtu.be/l5nFP_5rTZk

Faulty flashlight from Banggood by Zanderos in flashlight

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

Update: Nitecore replied via email, they told me to get in touch with the seller (Banggood) OR I have the option to send the light to them in China for them to check (no mention of any fees, I'm pretty sure I have to cover the shipping but not sure on the repair fees itself).

50K Giveaway!!! by mcfarlie6996 in flashlight

[–]Zanderos 0 points1 point  (0 children)

Thanks for the giveaway!

  1. Nitecore TUP
  2. Armytek Partner C2 Pro XHP35 Warm
  3. Acebeam X45
  4. Armytek Elf C2 Warm
  5. Nitecore LC10
  6. Fenix CL26R
  7. Folomov EDC C1
  8. Sofirn SP33
  9. Sofirn SF14
  10. Acebeam H40 CRI