Topic
Tips and Tricks
27 posts
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…
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…
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…
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…
DJI Phantom USB Modem for RTK Controller
DJI Phantom 4 Pro RTK – a WORKING dongle, and how we set it up. Company recently purchased a DJI Phantom 4 Pro w/RTK. The Controller requires a USB Dongle to communicate with a cell network to work…
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…
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…
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…
Finding a Lost E-mail folder in Outlook
An email folder has disappeared from your folders list, and you have searched everywhere for it. Sound familiar? Don’t fret, you are in luck. Step One – Search Search for an email you KNOW is FOR…
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…
Delete a stale Domain User From Windows 10
So you want to delete an old user that was part of a Domain from a Windows 10 machine: Two ways to do this: Search -> This PC -> Right click -> Properties -> Advanced system settings -> Advanced Tab…
Command to end Unifi service
Error:unifi is still running and cannot be installed Run this command using command promp copy and paste each line in a command prompt window and press enter.cd “%UserProfile%\Ubiquiti UniFi\”java…
Error when expanding partition on CentOS Linux on a Hyper-V virtual machine.
Error when expanding partition on CentOS Linux on a Hyper-V virtual machine. Error creating partition on /dev/sda: Command-line `parted –align optimal –script “/dev/sda” “mkpart \”\” ext2 ******MiB…
O365 – Email Migration link
When trying to migrate emails from IMAP, POP, etc you get the an error in O365 Admin Center. I was able to complete the transfer via this link: https://portal.office.com/onboarding/mailsetupadvisor#/
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…
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.…
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…
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…
Setting up custom App Passwords in Gmail for smtp email notifications in pfSense
Setting up custom App Passwords in Gmail for smtp notifications in pfSense I needed to setup Custom notifications for pfSense, which requires an smtp account. This process will work for most systems…
Upgrading Team Foundation Server, TFS 2010 to TFS 2017
Upgrading TFS 2010 to TFS 2017 and SQL Server 2008 to SQL Server 2016 The Problem We need to upgrade a physical server, we will call it “Tcode”. Tcode has Server 2008 32bit installed with TFS 2010…
Mount EXT3 or other Linux drive in Windows
Want to be able to connect a drive that’s been formatted under a linux distro? Checkout this program called Ex2Fsd https://sourceforge.net/projects/ext2fsd/ Read and write was between 50-60MB/s vs a…
Additional Commands to Run When Having issues Uninstalling Microsoft O365.
Office 365 issues I’ll tell ya, dealing with Microsoft support can be one of the most frustrating experiences. Not because it sucks, but because it’s so difficult relaying what your issue is. The…
How to Uninstall and Reinstall .Net Framework 1.1 – 4.7
Reinstall .Net Framework 4.7 a. First, we must uninstall .NET Framework Download and Run the following tool, it will help you uninstall one or all versions except 4.7.…
Deleting a File when the Filename is too Long
How to delete a file when the filename is too long. By creating a temporary substitute drive, we can shorten the file name, allowing you to rename, delete, etc. As you can see in the commands, I…
CrashPlan Cache Folder Filling up Space on Drive.
Issue: Storage space is low Used spacesniffer to analyze folder size. Found Crashplan cache folder was taking up 140GB. C:\ProgramData\CrashPlan\cache Deleted all of the files in the cache folder…
Create a Bootable Windows 10 USB Disk (Without the Download Tool)
This is a trick to make any Microsoft ISO you need, by “exploiting” the microsoft ISO installer. aka: This is a roundabout way to make the boot disk, when tools like Rufus fail. The Windows USB/DVD…
Annoyingly Silly USB Detection in Virtual Box
I’ve setup a Virtual Machine via VirtualBox that allows me to connect to a separate WiFi network. This allows me to test the VPN, open ports, and other fun things. What should be a simple process,…