Friday, October 7, 2016

Create User Define Function and Macro as an Add-in


We work lot in excel and manage our work with functions and macros. I am here creating the process that will save your time and effort to re-create again and again the same functions or macros.

Here we are going to create Add-in that will automatically load when you open your excel, and the function will be available all the time. So let's start.

Step 1: Quickly create an empty add-in for excel


  1. Open excel and Save a blank workbook as a Excel Add-In (*.xlam) in your Add-In folder (%UserProfile%\AppData\Roaming\Microsoft\AddIns)
  2. I named it PersonalAddIn.xlam (Save it with any name you like)
  3. Click Office button.
  4. Click "Excel options" button.
  5. Click "Add-Ins" tab.
  6. Select "Excel Add-ins" from manage dropdown list and click GO
  7. Click "Browse" button
  8. Select the (.xlam) file that you just saved in step 1
  9. Click OK (Make sure you enable)



Step 2: Add custom functions and macros to your personal add-in

  1. Go to the Developer Tab on the ribbon.
  2. Click "View Code"
  3. Click on the project panel you see VBAProject (*.xlam)
  4. Click Insert Menu --> Module
  5. Copy and paste custom functions and macros to code window.


That's it... we are done.

Step 3: Use your user define function

  1. Go to the cell
  2. Click "Insert Function" in formula bar
  3. Select category "User Defined"
  4. Select your custom function
  5. Click OK


Step 4: Use your user define Macro

  1. Go to "Developer" tab
  2. Click "Macros" button
  3. Select/Type the macro name
  4. Click "Run"


Hope this will help you in you daily work, In case of any query you can write to me. Thanks for reading.

Wednesday, October 5, 2016

Windows Registry Tips

A small tweak which disables processing of autorun.inf to protect your PC from usb autorun viruses.

Windows Registry Tips

Remove Language Bar from Taskbar
[-HKEY_CLASSES_ROOT\CLSID\{540D8A8B-1C3F-4E32-8132-530F6A502090}]
@="Language bar"
"MenuTextPUI"="@%SystemRoot%\\System32\\msutb.dll,-325"


Allow Internet Explorer 7+ to open direct links to swf files (XP/Vista/7)
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Internet Explorer\Main\FeatureControl\FEATURE_BLOCK_LMZ_SCRIPT]
"iexplore.exe"=dword:00000000


Disable the Turn off computer button on the Welcome screen (XP/Vista/7)
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Policies\System]
"shutdownwithoutlogon"=dword:00000000

Disable USB Autorun to Save PC from USB Viruses (XP/Vista/7)
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\IniFileMapping\Autorun.inf]
@="@SYS:DoesNotExist"

Disable Writing to USB Drives (XP/Vista/7)
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\StorageDevicePolicies]
"WriteProtect"=dword:00000001

Enable Writing to USB Drives (XP/Vista/7)
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\StorageDevicePolicies]
"WriteProtect"=dword:00000000

Note: Modifying the registry can cause serious problems that may require you to reinstall your operating system. Use the information provided at your own risk.

Monday, September 19, 2016

What is a 404 error page mean?

In 1992 Tim Berners-Lee defined all the HTTP (Hypertext Transfer Protocol) codes based on the FTP (File Transfer Protocol) status codes. If you break it down, 

  • The first '4' indicates the error is a client error
  • Second the '0' indicates a general syntax error
  • Final '4' refers to the specific error code in the '4xx' group of error codes.

List of HTTP status Code

So, in brief you can say that, the 404 or Not Found error message is a Hypertext Transfer Protocol (HTTP) standard response code, in computer network communications, to indicate that the client was able to communicate with a given server, but the server could not find what was requested. The web site hosting server will typically generate a "404 Not Found" web page when a user attempts to follow a broken or dead link; hence the 404 error is one of the most recognizable errors encountered on the World Wide Web.

Friday, September 2, 2016

Thoughts

  • THE ONLY TIME SUCCESS COMES BEFORE WORK IS IN THE DICTIONARY
  • YOU MISS 100% OF THE SHOTS YOU DON'T TAKE
  • A MAN WITHOUT PLANS FOR HIS FUTURE WILL ALWAYS RETURNS TO HIS PAST
  • GREAT THINGS ALWAYS FALL JUST OUTSIDE YOUR COMFORT ZONE
  • SEEK RESPECT NOT ATTENTION, IT LASTS LONGER
  • GREAT THINGS DON'T EVER COME FROM COMFORT ZONES
  • DECIDE WHERE YOU WANT TO BE AND DON'T STOP UNTIL YOU GET THERE
  • ONLY A KING CAN ATTRACT A QUEEN AND ONLY A QUEEN CAN KEEP A KING FOCUSED
  • YOU CAN EITHER BE THE MAN OR YOU CAN WORK FOR THE MAN
  • I LOVE TO SHOP BUT I'M NOT BUYING YOUR BULLSHIT
  • NO ALARM CLOCK NEEDED, MY PASSION WAKES ME UP
  • THERE'S NO ELEVATOR TO SUCCESS, YOU HAVE TO TAKE THE STAIRS
  • GRIND WHILE THEY SLEEP LEARN WHILE THEY PARTY LIVE LIKE THEY DREAM
  • DON'T LIVE THE SAME YEAR 75 TIMES AND CALL IT A LIFE


Monday, August 8, 2016

5 Great Visual Studio Keyboard Shortcuts

Following are five of my favorite keyboard shortcuts in Microsoft Visual Studio.

1)Move Code Alt+Up/Down

This keyboard shortcut is new in Visual Studio 2013. If you put the cursor on a line of code and use the Alt+Up Arrow keys, the line of code you've selected moves up. If you use the Alt+Down Arrow keys, the line of code selected moves down.

2)Create Collapsible Region Ctrl+M+H/Ctrl+M+U

Chances are you've noticed the "+" and "-" symbols in the margins that let you collapse and expand your classes and functions. Did you know you can create your own collapsible regions? If you select a section of code and then use the key sequence Ctrl+M+H, you turn that region into a collapsible/expandable region. The key sequence Ctrl+M+U will remove the collapsible region. It doesn't delete the code, it just removes the icon that lets you expand and collapse.

3)Comment Code Block Ctrl+K+C/Ctrl+K+U

Whether it's because you're trying to track down a "but," or experimenting with code change, from time to time you'll want to comment and uncomment blocks of code. If you select a block of code and use the key sequence Ctrl+K+C, you'll comment out the section of code. Ctrl+K+U will uncomment the code.

4)Peek Definition Alt+F12

When you're going through your code and you want to examine the code in the method you're calling, many programmers will use the F12 key or the pop-up menu option Go To Definition. Go To Definition will navigate to the called method; however, many times you don't need to navigate to the code. Sometimes, you just want a quick look at the method. If you've installed Visual Studio 2013, there's a new keyboard shortcut -- Alt+F12 -- that will give you a preview of the method being called inline. You can use the Esc key to close the preview.

5)Navigate Forward/Backward Ctrl+–/Ctrl+Shift+–

When you have multiple files open at the same time, you might want a way to quickly move back and forth between two or three different locations in your code. If you've moved from one location to another you can use the keyboard sequence <Ctrl>+– to move to the previous location and then you can return using Ctrl+Shift+–.

Wednesday, June 29, 2016

Create XML using EXCEL

Many a time I have got question about how to create XML with excel, So I decided to add this into my blog. Hope this will help the readers.

step 1:
Create one schema file (A template that we will use to generate the xml).
Eg. (Save following lines in dataSchema.xml file)

















Step 2:
Open your excel file containing the data.
CountryID CountryName
1 India
2 Pak
3 Srilanka
4 China
5 Koria


Step 3:
Go to the Developer TAB, if it is not on the top then you need to enable it from (File > Option )

Step 4:
Click "Source" under XML.
It will open XML source panel, having two buttons at the bottom. Click "XML Maps...".

Step 5:
Click "Add" to the XML Maps window.

Step 6:
Select "dataSchema.xml" file that we created in Step 1
Click OK twice

Step 7:
In XML Source you can now see the TREE VIEW of your columns.

Step 8:
Drag and Drop each column to the first row of your data.

Step 9.
Click "Export" button in Developers > XML tab.

Step 10:
You can now save this file as XML and that's it. Done.




Tuesday, June 7, 2016

Which programing languages are useful for hacking

Important Programming languages for Hackers

Many of our readers often send us queries about which programming language they should learn. Some want to know quick fix hacking solutions. Almost all tech gadgets are built with coding. Every App, game or site that you use is programmed in a particular computer language. You need to know that hacking is not a click-of-a-button job but a serialized and compartmentalized vocation which uses different programming languages for different uses.

Most of the websites out there will give you list of most popular programming languages in the world. We at Techworm try to make it more easy for budding security researchers and hackers by breaking up the programming languages used by hackers.

Hacking is usually meant to break a code. There are three sections of hacking ― Web Hacking, Exploit Writing & Reverse Engineering and each of it requires different programming language

1. Web Hacking

Since most of the tech is build around world wide web, it is important to learn web hacking to be a good hacker. Let’s say you are interested in hacking web apps and/or websites then you will need to learn web coding. Websites use mostly HTML, PHP and JavaScript so it is important to learn these three.

HTML:

One of the easiest and widely used static markup web language present in each and every website you see in your browser. It’s recommended to learn HTML because it helps understanding web actions, response, and logic.

JavaScript:

JS is a client-side web programming mostly used in web sites for better user interface and quick response. If you are interested in a hacking career you need to learn JavaScript because it helps to understand client-side mechanism which is essential for finding client-side flaws.

PHP:

A dynamic server-side language which is responsible for managing web-apps and database. PHP is considered one of the most essential language because it controls everything on site and server, like a captain of a ship. It is advised to learn PHP nicely.

SQL:

SQL is responsible for storing and managing sensitive and confidential data such as user credentials, bank and personal information about the website visitors. Black hat hackers mostly target SQL database and steal information which is later sold on underground dark web forum. If you want to be good security researcher, you should learn SQL so that you can find flaws in a website and report them.

2. Exploit Writing

After web hacking, another most important feature of hacking is exploits. You can crack a particular software by writing a exploit. But to write a exploit you need to learn either Python or Ruby.

Python:

It is said that a security researcher or hacker should know Python because it the core language for creating exploits and tools. Security experts and even pro hackers suggest that master Python is the best way to learn hacking. Python offers wider flexibility and you can create exploits only if you are good in Python.

Ruby:

Ruby is a simple yet complicated object-oriented language. Ruby is very useful when it comes to exploit writing. It is used for meterpreter scripting by hackers. The most famous hacker tool, Metasploit framework is programmed in Ruby. Though Ruby may not be as versatile as Python, knowledge of Ruby is must in understanding exploits.

3. Reverse Engineering

Reverse engineering, the process of taking a software program’s binary code and recreating it so as to trace it back to the original source code. If you know reverse engineering you can find flaws and bugs easily. If you want to learn reverse engineering you need to know C, C++ and Java. The process of converting the code written in high level language into a low level language without changing the original program is known as reverse engineering.

Do you think any other programming language is essential for wannabe hackers and security researchers? if yes then please comment below.


Reference