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…
Category: Tech Random’s
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…
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…
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…
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…
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…
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…
Disable Windows Anti-Malware Service Executable
Microsoft is driving me crazy with these “forced” features they have been including with windows. An example of this is Window’s Anti-Malware. It runs in the background scanning everything you do. This can be good for an average users, but for someone that wants to transfer 12 TB from a USB device to a Network share, it well, slows it…
Understanding the Differences between Wiping and Formatting Your Hard Drive.
One of the questions I get most often, is what to do with old hardware. With this question, the primary concern is how to format the drive before they discard it. Most people know they need to format their drive, but they don’t know that just formatting the drive leaves it vulnerable to data recovery solutions, and who knows what…
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…