Get URL from a Hyperlink
Now use the =GETURL(cell) to get the URL Example: =GETURL(A1) will return the URL for the Hyperlink displayed in cell A1 Function GETURL(HyperlinkCell As Range) GETURL = HyperlinkCell.Hyperlinks(1).Address End Function
admin
Change Hyperlinks to a Particular Text
In a Word Document when we paste some data from some source (e.g. Websites). We find that there are some hyperlinks copied into it. Sometimes we want to change the text of all these hyperlinks to a particular word. When it is needed? It is useful where we actually want to remove all these hyperlinks … Read more
Install a Macro in MS Office
To install this all you need to do is: 1. Hit ALT + F11 (Opens Visual Basic Editor) 2. Click on Insert -> Module (adds a module to your excel file) 3. Paste the code 4. Hit ALT + Q (Closes the Visual Basic Editor)
SQL Basic Queries
Basically FOUR SQL commands used very often. These four commands are SELECT, INSERT, UPDATE, DELETE By using these four basic commands you can do a lot of queries. SELECT select * from tablename INSERT insert into tablename SET col1=”, col2=” UPDATE update tablename SET col1=”, col2=” WHERE col3=” DELETE delete from tablename WHERE col1=”
Welcome to Basic Codes!
Basic Codes is about small codes and Tips. You will find these codes easy to implement and very useful. Codes here are related to web designing codes, macros etc.
Invisible to Invisibles – GTalk and GMail Chat
GTalk and GMail chat has a feature Invisible Mode, where we can’t see a user who is invisible. I would like to suggest a feature for GTalk and GMail Chat. There should be a feature where if one of my friends is Invisible, then I should have an option to remain invisible to him/her also … Read more
Mozilla Firefox 3.6 Launched
Download Mozilla Firefox 3.6! A new version with Cool New Features..
Google Dashboard
I was just surfing within Google and found the Google Dashbaord at:https://www.google.com/dashboard/It has all the information About Me associated with the various Google Services I use. Well you can find a summary here of the various services you are using that are associated with Google and in a way can control your Google Account information, … Read more
Google URL Shortener
Google’s new service: Google URL Shortener available at: http://goo.gl Google URL Shortener is currently available for Google products and not for broader consumer use. Google URL Shortener at goo.gl is a service that takes long URLs and squeezes them into fewer characters to make a link that is easier to share, tweet, or email to … Read more
Google Model Your Town Competition
Have you ever noticed that a lot of the bigger cities in Google Earth have photo-realistic 3D buildings in them? (See Valencia, for example.) Have you ever wondered when someone’s going to get around to modeling the world’s smaller towns and villages? Today, we’re giving you the chance to add your own town to the … Read more