Fixes, Quickbooks, Tech Blog, Tech Random's, Tips and Tricks

Quickbooks – set excel to open with macros enabled when running reports.

Quickbooks typically allows you to open excel reports with macros already enabled.  But some of their “other” reports open Excel directly.  When it does, it opens the file as a temporary file, and subsequently not a “trusted location” in excel. While it’s easy to get around this, save the workbook to a trusted location (i.e., My Documents) then reopen it…

Continue Reading

Android, Fixes, Microsoft, Tech Random's, Tips and Tricks, Uncategorized, Weird Tech Issues

Google Play Family Library fails with Minecraft License Error – Android

Minecraft has been a staple in my household for years.  It just makes sense our offspring would love it too.  We set out to install Minecraft on one of their tablets and to my surprise, it said: “install”.  Normally indicating no costs. Great!  I assumed it was free from all of the other “marketplace” items for sale now, especially with…

Continue Reading

Microsoft Excel, O365, Tech Blog, Tech Random's, Tips and Tricks

Excel unable to enable Macros when running QuickBooks Report.

Our most recent edit shows you the folder to specifically trust: http://strongitguy.com/quickbooks-set-excel-to-open-with-macros-enabled-when-running-reports/ User goes to open up an Excel report from Quickbooks and receives a Security Warning that Macros have been enabled.   There are two ways to “Fix” this based on your security settings and environment. The first is the easiest for most users. For this, we are going…

Continue Reading

Backups, Tech Blog, Tech Random's, Tips and Tricks, Uncategorized

Removing Unfinished files with Backblaze B2 CLI

Step 1: Download Backblaze B2 Command Line Tool Remember DURING install to choose to set PIP environmental Path https://www.backblaze.com/b2/docs/quick_command_line.html or https://www.backblaze.com/b2/docs/quick_command_line.html#download If you run into issues with PIP: http://strongitguy.com/issues-setting-up-b2-command-line-and-windows-python-install/   Backblaze documentation has an [-h] in it, remove this.   b2 authorize-account ID Appkey (replace ID and APPKEY with the one you received from Dropbox) Commands to run once CLI…

Continue Reading

Dell, RAID, Tech Blog, Tips and Tricks

How to configure a Dell DPWC400 NVMe PCIe SSD adapter in RAID 0

How to configure a Dell DPWC400 NVMe PCIe SSD adapter in RAID 0 Open Command Prompt ->Diskpart ->List Disk Disk ###  Status         Size     Free     Dyn  Gpt ——–  ————-  ——-  ——-  —  — Disk 0    Online          238 GB      0 B        * Disk 1    Online          238 GB      0 B        * Disk 2    Online          238 GB      0 B        * Disk 3    Online          238…

Continue Reading

Fixes, Robocopy, Tech Blog, Tips and Tricks

Robocopy Hides Destination Folder

The root cause is you are transferring from the root directory. There are many suggestions on how to fix/correct/prevent this but /A-:SH Did not work /A:-SH errors out Excluding “System Volume Information” Did not work Fix:   run cmd from the parent folder of the hidden folder notice it starts at that path! 😀 run the following command: attrib -R…

Continue Reading

Hyper-V, Tech Blog, Tech Random's, Tips and Tricks

No internet access on virtual machine using Hyper-V

No internet access on virtual machine using Hyper-V You setup Hyper-V but none of your VM’s seem to have internet.  You have your ethernet cable in port one, and you have your Hyper-V Virtual Switch Manager properties reflecting NIC1. Sound familiar?   Windows will not always keep the correct structure for the NIC naming.  The errors you might receive: Unidentified…

Continue Reading

Fixes, Tech Blog, Tips and Tricks

Those mysterious cloudberry errors

Started using cloudberry again.  When it works, it works great.  But, its awful when it comes to error messages.  Going to start listing those errors here, and hopefully what worked to get past it. 3-24 “Failed The system cannot find the path specified. Open” Open what exactly?  Lets dig deeper… Log file shows: System.IO.IOException The system cannot find the path…

Continue Reading