Printer Not Showing Up in Devices and Printers – Solved

Had a customer who’s printer was showing off-line or grayed-out. They removed it and did a search for it but it didn’t come back.

I had an IP address in our documentation and I could interface with the printer through the browser. The printers were connected via USB to the server.

I tried a straight restarting of the spooler, but that didn’t get the printer back online.  The following tip helped me solve this issue.

https://www.youtube.com/watch?v=EN81kBdIvSA

Here is what I did to solve the issue.

  1. Stop the print spooler on the server
  2. Go to “C:\Windows\System32\spool\Printers” and cleared this directory out by deleting all files in there.
  3. Started the spooler again.
  4. I had to go back to the users machine and add the printer again.

Let us know if this helped you…

 

Unlocking A Protected Excel File

We had a Excel file that we needed to copy some of the cells to recreate a new proposal. The Excel file was locked, so we could view it but couldn’t copy anything.

I found the following link that helped me unlock the document.

How to protect and unprotect Excel sheet with or without password

I had to use the script and the VBA code to get a temporary password. This temp password allowed me to edit the document and do a Save As.

Let us know if this helps you…

 

Gmail in Outlook – Can Log Into Gmail But Outlook Won’t Authenticate

Had a customer who needed to change their Gmail password. When they opened Outlook it asked for the  new password, so they entered it. Outlook keep prompting for the new password.

The customer could go to Gmail and log right in.

It turned out to be Google needs this account to be “Less secure apps” section of your Gmail account. It should be here https://myaccount.google.com/lesssecureapps. Turn on this feature.

Let us know if this solution helps you…

 

 

Using RegEx to Get IP in Google Analytics

For privacy reasons Google doesn’t just offer up the IP addresses of your traffic, but there are ways to get it. I have set up a filter in my Analytics account to accomplish this.

Here is an article that helped me figure this out.

Basic Google Analytics Filters for Every Site

Here is the page that helped me determine the regular expression needed to include the IP address information.

http://www.regular-expressions.info/ip.html

Let us know if this helps you….