The Best Web Host!!

Review of my new MSI Gaming Laptop – GS63VR STEALTH-252

I’ve been using my MacBook Pro mid-2010 for 7 years. It’s time to move on.

I’ve just picked up my steaming hot MSI Gaming Laptop 3 weeks ago and I can not be happier. I was not going to spend the money needed for the power on an Apple. Plus I’m not going to be sucked in to the dongle game. This laptop has all the port you need plus some more.  I have not had the chance to start heavy gaming, but I have done a few tests and I’m very impressed. With 6GB of video memory and 16 GB of system memory on an i7 you have incredible power. I will say the better video card memory is more important then system memory, you can upgrade the system memory at any time, but not the video memory. I only go with Nvidia video card systems as a preference. When I was in Best Buy making my final decision between ASUS and MSI, I noticed the 2 of the ASUS gaming laptops were locked up.  Total hard-locked needed to be rebooted, but the MSI ones were flying smooth.  That was my final kicker and sign from above.

I was not focused on the 17in screen model, I’m enjoying the 15.6in just fine. I wanted it to still feel portable. The steelseries keyboard is a pleasure to type on, and the lighting memorizing. Only have slight issues with tapping the touch pad, but getting used to it and adjusting the sensitivity.

I have removed the Norton Security that came from MSI, I could not stand the constant popups and reminders to enable other features. Best Buy gave me 6 months free with Webroot antivirus and have switched to it. So far I’m impressed with the reviews of it and the little footprint it leaves on the system.

You can find what software I have added under my Windows Apps page, I only review apps I use. I will be gaming with World of Warcraft, Star Trek Online and a few other games. I have tested them with full graphics on so far with out a hiccup. I’m also using my Apple Magic Mouse without a hickup.

I will post some un-boxing pictures in the future.

GS63VR STEALTH-252 (link to Best Buy) – Features:

Windows 10 operating system
Windows 10 brings back the Start Menu from Windows 7 and introduces new features, like the Edge Web browser that lets you markup Web pages on your screen. Learn more ›

15.6″ Full HD display
The 1920 x 1080 resolution boasts impressive color and clarity. Energy-efficient LED backlight.

7th Gen Intel® Core™ i7-7700HQ mobile processor
Powerful quad-core processing performance. Intel Turbo Boost Technology delivers dynamic extra power when you need it, while increasing energy efficiency when you don’t.

16GB system memory for intense multitasking and gaming
Reams of high-bandwidth DDR4 RAM to smoothly run your graphics-heavy PC games and video-editing applications, as well as numerous programs and browser tabs all at once.

1TB hard drive and 256GB solid state drive (SSD) for a blend of storage space and speed
The hard drive provides ample storage, while the SSD delivers faster start-up times and data access.

NVIDIA GeForce GTX 1060 graphics
Backed by 6GB GDDR5 dedicated video memory for an ultrafast, advanced GPU to fuel your games.

Weighs 3.97 lbs. and measures 0.7″ thin
Ultrathin and ultralight for maximum portability, featuring a smaller screen size and omitting the DVD/CD drive to achieve the compact form factor. 3-cell lithium-ion battery.

Bluetooth 4.1 interface syncs with compatible devices
Wirelessly transfer photos, music and other media between the desktop and your Bluetooth-enabled cell phone or MP3 player, or connect Bluetooth wireless accessories.

1 USB Type-C port
To maximize performance on the latest high-speed devices.

3 USB 3.0 ports maximize the latest high-speed devices
Also includes 1 USB 2.0 port to connect more accessories and peripherals. USB 3.0 ports are backward-compatible with USB 2.0 devices (at 2.0 speeds).

HDMI 2.0A output expands your viewing options
Connect to an HDTV or high-def monitor to set up two screens side by side or just see more of the big picture.

Thunderbolt port for connecting advanced monitors and external drives
This single interface supports both high-speed data and high-def video — plus power over cable for bus-powered devices — ideal for digital content creators.

Built-in media reader for simple photo transfer
Supports SD, SDHC and SDXC memory card formats.

Next-Gen Intel® Wireless-AC connectivity
Connect to a Wireless-AC router for nearly 3x the speed, more capacity and wider coverage than Wireless-N. Backward-compatible with all other Wi-Fi networks and hotspots. Gigabit Ethernet LAN port.

Built-in HD webcam with microphone
Makes it easy to video chat with family and friends or teleconference with colleagues over Skype or other popular applications.

Additional ports
Microphone input, headphone/SPDIF combo jack and mini DisplayPort.

Plugin Errors with WordPress

I constantly neglect my personal WordPress, then once I get back to it and hit all the magic update buttons I normally break something. I have learned the best way to manually disable a plugin when you can no longer get to your site is by using your hosts phpMyAdmin to manually edit your database entry to disable all plugins. Then you can go to your admin and remove the bad plugin and re-enable the ones that are working.

If you have a plugin error all of your pages will load to just a text error saying there is an error in “/home/myaccount/public_html/wp-content/plugins/XXX/XXX.php on line #123″.

If you get this login to your host an access your phpMyAdmin or other mySQL database editor.
USE AT YOUR OWN RISK!

  1. Open the Database for wordpress
  2. Open the wp_options table
  3. Click on the Browse menu
  4. Search through the pages for the “active_plugins” option (was page 2 for me)
  5. Clear out the text the shows: “a:3:{i:0;s:39:”easy-adsense-lite/easy-adsense-lite.php”;i:1;s:49:”google-xml-sitemaps-v3-for-qtranslate/sitemap.php”;i:2;s:19:”jet”pack/jetpack.php”;}”
  6. All your plugins will now be disabled, try to login and update your plugins as needed.

How to change your Windows iCloud Drive Folder

I made the switch back to Windows 10 from my Mac Book Pro.  On my new MSI Laptop I have a 256 SSD & a 1TB hard-drive. I wanted to move my iCloud Drive from by SSD to my larger hard-drive. Apple does not let you customize your Drive location, you can only change the Photo location with their settings.  Below is the steps that I took to move my iCloud Drive. I found most of the steps online, but tweaked some of them.

As a note you have you trick iCloud because it will always look in your C:\Users\<username>\iCloudDrive” folder.  You have to create a link from this folder to where your real folder is. This is different then a shortcut. No rebooting is needed.

NOT RESPONSIBLE IF YOU LOST YOUR DATA (but you should have it in the cloud anyway so….)

  1. First make sure you disable iCloud Drive.
    • If you have a large amount of data in your current iCloud Drive folder and you do not want to have to re-download it, copy the C:\Users\<username>\iCloudDrive” folder to “D:\iCloudDrive” first
  2. When you disable your iCloud Drive it will tell you that the data & folder will be removed. It will not effect the folder on Drive D:, but will remove the folder and data in “C:\Users\<username>\iCloudDrive”
  3. Next you need to make sure that you have a D:\iCloudDrive Folder, if its not already there, create it.
  4. Next go to the command prompt and type in: mklink /J “C:\Users\<username>\iCloudDrive” “D:\iCloudDrive”
    • No spaces in iCloudDrive
    • To get to the Command Prompt: Press Windows Key+R, type in CMD in the prompt then click Open
  5. Go back to your iCloud settings and enable iCloud Drive, you may get a message about merging your data, click yes.

 

Disable/Stop Screen changes while a macro is running in excel

Do you want to make your macro pause the screen so that you do not see what is happening till it’s done? This will prevent seeing all the jumping between sheets & scrolling.

Application.ScreenUpdating = False

 

 

“Do You Want to Go to Chipotle?”

Have not see this in a while.. are you a Chipotle fanatic? Its a most see!!

Cleaning List of Names in Excel with a formula

Take A1 and remove “*” located at the end.

=IF(ISERROR(IF(FIND(“,”,A1)>0,A1)),A1,IF(FIND(“,”,A1)>0,IF(ISERROR(FIND(“*”,A1)),A1,LEFT(A1,FIND(“*”,A1)-1))))

If A1 = “Doe, Jane*” it will return “Doe, Jane”

Enable/Disable alerts in a macro

Enable/Disable alerts in a macro

Disable

Application.DisplayAlerts = False

Enable

Application.DisplayAlerts = True

Run a Macro when a workbook opens (must be placed in the “ThisWorkbook” Object)

Run a Macro when a workbook opens (must be placed in the “ThisWorkbook” Object):

Private Sub Workbook_Open()
MsgBox “Auto Calculation has been disabled.”
Application.Calculation = xlCalculationManual
End Sub

Paste Values only from current clipboard contents in a macro

Paste Values only from current clipboard contents:

Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False

Switch to a different open workbook in a macro

Switch to a different open workbook:

Windows(“file name.xlsm”).Activate