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, no charge, just said: “install”.  Great!  I assumed it was free from all of the other “marketplace” items for sale now, especially with realms.  Come…

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: 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 or If you run into issues with PIP:   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

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 Random's, Windows

DJI Assistant 2 error: An app has been blocked for your protection.

The Issue: When running DJI Assistant 2.exe you encounter the following error: User Account Control This app has been blocked for your protection. An administrator has blocked you from running this app.  For more information, contact the administrator. DJI Assistant 2.exe Publisher: Unknown File origin: Hard drive on this computer Program location: “C:\Program Files (x86)\DJI Product\DJI Assistant 2 For Phantom\DJI…

Continue Reading

Scripts, Tech Random's, Tips and Tricks

Send an Email Using Command Prompt or Batch File Script with PowerShell

This will allow you to to call a powershell script from a batch file that creates and sends an email. You will need: SMTP Outgoing Server SMTP Outgoing Credentials Apply this line to any Batch file line. Our example: robocopy C:\Data D:\Data /L /MIR /Z /Copy:DAT /DCOPY:T /J /mt /tee /r:1 /W:1 /ETA /xd “$RECYCLE.BIN” /log+:”C:\RCLogs.txt” PowerShell.exe -NoProfile -ExecutionPolicy Bypass…

Continue Reading

O365, Tech Random's, Tips and Tricks

Disable Clutter through O365 Admin Dashboard with Powershell

Disable clutter on O365 Admin Dashboard Step 1: Run Powershell ISE as Administrator Step 2 – Run: Set-ExecutionPolicy RemoteSigned A popup will occur, choose “Yes to All”.  Just make sure you know what you are doing before proceeding. Step 3 – Enter username and Password $UserCredential = Get-Credential -It will not let you know if your credentials are wrong. Step…

Continue Reading