Saturday, 2 October 2021

 Hypervision Off through Cmd

Open Cmd as Administrator

Run this command : bcdedit /set hypervisorlaunchtype off


Monday, 12 July 2021

Useful Macros

 Jump

Sub JumpTo()

'Description: Select the specified row or column

  'If row is specified, active column is used

  'If column is specified, active row is used

Dim sResult As String

  On Error Resume Next 'Blanket error handling  

  'Display inputbox to prompt user for row/column

  sResult = InputBox("Type a row number or column letter and press Enter.", "Jump To...")  

  If IsNumeric(sResult) Then 'Select row

    Cells(sResult, ActiveCell.Column).Select

  Else 'Select column

    Cells(ActiveCell.Row, sResult).Select

  End If

End Sub


Delimited by Pipe Operator

Sub Separator()

Columns("A:A").Select

    Selection.TextToColumns Destination:=Range("A1"), DataType:=xlDelimited, _

        TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=False, _

        Semicolon:=False, Comma:=False, Space:=False, Other:=True, OtherChar _

        :="|", FieldInfo:=Array(Array(1, 1), Array(2, 1), Array(3, 1), Array(4, 1)), _

        TrailingMinusNumbers:=True

End Sub



Tuesday, 6 July 2021

MS Office 2016 100% Working

 Activate MS Office 2016 Without a Product Key


Step-I: Open a blank text file and paste the following code in it.


@echo off
title Activate Microsoft Office 2016 ALL versions for FREE!&cls&echo ============================================================================&echo #Project: Activating Microsoft software products for FREE without software&echo ============================================================================&echo.&echo #Supported products:&echo - Microsoft Office Standard 2016&echo - Microsoft Office Professional Plus 2016&echo.&echo.&(if exist "%ProgramFiles%\Microsoft Office\Office16\ospp.vbs" cd /d "%ProgramFiles%\Microsoft Office\Office16")&(if exist "%ProgramFiles(x86)%\Microsoft Office\Office16\ospp.vbs" cd /d "%ProgramFiles(x86)%\Microsoft Office\Office16")&(for /f %%x in ('dir /b ..\root\Licenses16\proplusvl_kms*.xrm-ms') do cscript ospp.vbs /inslic:"..\root\Licenses16\%%x" >nul)&(for /f %%x in ('dir /b ..\root\Licenses16\proplusvl_mak*.xrm-ms') do cscript ospp.vbs /inslic:"..\root\Licenses16\%%x" >nul)&echo.&echo ============================================================================&echo Activating your Office...&cscript //nologo ospp.vbs /setprt:1688 >nul&cscript //nologo ospp.vbs /unpkey:WFG99 >nul&cscript //nologo ospp.vbs /unpkey:DRTFM >nul&cscript //nologo ospp.vbs /unpkey:BTDRB >nul&cscript //nologo ospp.vbs /unpkey:CPQVG >nul&cscript //nologo ospp.vbs /inpkey:XQNVK-8JYDB-WJ9W3-YJ8YR-WFG99 >nul&set i=1
:server
if %i%==1 set KMS=kms7.MSGuides.com
if %i%==2 set KMS=kms8.MSGuides.com
if %i%==3 set KMS=kms9.MSGuides.com
if %i%==4 goto notsupported
cscript //nologo ospp.vbs /sethst:%KMS% >nul&echo ============================================================================&echo.&echo.
cscript //nologo ospp.vbs /act | find /i "successful" && (echo.&echo ============================================================================&echo.&echo #My official blog: MSGuides.com&echo.&echo #How it works: bit.ly/kms-server&echo.&echo #Please feel free to contact me at msguides.com@gmail.com if you have any questions or concerns.&echo.&echo #Please consider supporting this project: donate.msguides.com&echo #Your support is helping me keep my servers running everyday!&echo.&echo ============================================================================&choice /n /c YN /m "Would you like to visit my blog [Y,N]?" & if errorlevel 2 exit) || (echo The connection to my KMS server failed! Trying to connect to another one... & echo Please wait... & echo. & echo. & set /a i+=1 & goto server)
explorer "http://MSGuides.com"&goto halt
:notsupported
echo.&echo ============================================================================&echo Sorry! Your version is not supported.&echo Please try installing the latest version here: bit.ly/downloadmsp
:halt
pause >nul


Step-II: Save the text file as a batch file and name it "activate.cmd".


Step-III: Run the batch file as "Administrator" and Microsoft Office 2016 will be successfully activated.

Friday, 25 June 2021

Download ISO from Official Website

Open the following link: https://www.microsoft.com/en-in/software-download/windows10 




 Open Inspect Element > Then click on Customize and Dev Tools > More Tools > Network Conditions
Under User Agent select a different browser e.g. Safari. After it refresh the websites page and you'll be redirected to a new webpage.


Select the edition of windows then confirm and language, after it you will get option of downloading the file in 32 and 64 bit format.

ENJOY..!!


Friday, 18 June 2021

RAM

Mixing RAMs isn't supported, it may not work right and you can have blue screen errors on your machine. 

RAM is divided into Modules, Ranks (banks, rows and columns).

The difference between an 1Rx8 and 1Rx16 module is the layout of the memory. 1Rx8 means 1 rank with 8 bit wide chips, so to get a 64 but wide rank you need 8 chips on that rank. 1Rx16 means 1 rank with 16 bit wide chips, so a 64 bit wide rank uses 4 chips. Now, we get into memory controllers. The memory controllers on modem CPUs can control 8 bit and 16 bit chips up to a specific density, the total number of bits each chip can store.

All Core chips before the 5th Gen can control memory up to 4 Gbit density (exception, the very first gen Core i7 CPUs and Arrandale mobile CPUs, these go up to 2 Gbit.) This means a 4 GB module needs to be at least 1Rx8. An 8 GB module needs to be 2Rx8 on those CPUs. From the 5th Gen to the 7th Gen can control chips up to 8 Gbit density. So an 8 GB module can be 1Rx8 and a 16 GB module needs to be 2Rx8. From the 8th Gen onwards 16 Gbit chips are supported. On those CPUs a 16 GB module can be 1Rx8 and a 32 GB module needs to be 2Rx8.

CPUs before the 5th Gen can control a 4GB 2Rx16 (never seen one) module or a 2 GB 1Rx16. 5th-7th Gen control an 8 GB 2Rx16 (never seen one) or 4 GB 1Rx16. 8th Gen and later can control 16 GB 2Rx16 (never seen one) or 8 GB 1Rx16.

Tuesday, 15 June 2021

Block Sites

Open DNS

Log in to Cloud Delivered Enterprise Security by OpenDNS . Select Home > Learn More > OpenDNS Home Sign Up.
The Name Servers will be entered in the Primary and Secondary DNS.

Open your Router and go under Networks, look for DHCP Server. Enter the IP Addresses in the Primary and Secondary slots and SAVE it.

To make sure your computer gets the newly DNS server we just created.

Open CMD ipconfig /release
ipconfig /renew

After it click on the Test your setting:


Go Ahead and click on Login on the same page with the login you created.
Click on Add a Network. Then name your Network and click on the link to manage your network.
Select the filtering level type. To enter any specific website add in Manage Individual Domain.




Monday, 14 June 2021

Asus X550LC-XX039D

LAPTOP SPECIFICATIONS

SUMMARY

Price In India₹ 40,897
PerformanceCore i5 4th Gen
Storage750 GB HDD
Display15.6 Inches, 1366 X 768
Ram4 GB
MEMORY
Ram TypeDDR3
Memory Layout1 x 4 Gigabyte
Memory Slots1
Expandable Memory8 GB
Graphics Memory2 GB
Capacity4 GB
DISPLAY DETAILS
OSDOS
Type64
PERIPHERALS
Drive TypeDVD Writer
Optical Drive Read Speed8x
KeyboardChiclet Keyboard
Optical Drive Write Speed8x
Pointing DeviceTouchpad with Multi-touch Gesture Support
Optical DriveSuper-Multi DVD RW Drive with Dual Layer Support
STYLE ATTRIBUTES
Display TypeLED
Display Resolution1366 x 768
Display TouchscreenNo
Dimensions wxHxD380 x 251 x 31.7 mm
Display FeaturesHD TFT LCD Glare Display with LED Backlit
Display Size15.6 Inches
Weight2.3 Kg
ColorsDark Grey
GENERAL INFORMATION
BrandAsus
ModelX550LC-XX039D
PRIMARY STORAGE
HDD Speed rpm5400 RPM
HDD Capacity750 GB
HDD TypeSATA
NETWORKING
Secondary Cam rear facingNo
Ethernet Type10/100/1000 Mbps
Sound TechnologiesSonicMaster Audio
Headphone JackYes
Bluetooth Version4.0
HDMI1
Microphone JackYes
Digital Media ReaderYes
Wireless Lan802.11 b/g/n
VGA PortYes
BluetoothYes
USB 30 Slots1
WebcamYes
USB 20 Slots1
SpeakersStereo Speakers
Ethernet Ports numbers1
BATTERY
Power Supply65 W AC Adapter W
Battery TypeLi-Ion
Battery Cell4 Cell
PROCESSOR
Graphic Processor VariantGT 720M
Processor ModelCore i5 4th Gen
Clock speed1.6 Ghz
Processor MakeIntel
Graphic ProcessorNVIDIA GeForce GT 720M
ChipsetIntel QM87 Express
ProcessorIntel Core i5-4200U
Graphic Processor MakeNVIDIA
Graphic Processor ModelGeForce
Processor Variant4200U
OTHERS
Sales PackageLaptop, Battery, AC Adapter, User Guide
Warranty1 Year

 Hypervision Off through Cmd Open Cmd as Administrator Run this command :  bcdedit /set hypervisorlaunchtype off