A new activity stream in Drive shows you what’s changed

Posted by Ian Gunn, Google Drive Interaction Designer

Drive makes group projects easier because everyone can share files and work together. But in today’s busy world, it’s tough to track the changes to all your shared to-do lists, budgets and presentations, especially when content changes so often. So starting today, you’ll notice a new activity stream in Drive – a single, easy-to-view place to review every action taken on your files and folders.

When you open Drive, click the ⓘ button in the top right corner and the activity stream will appear, showing you who has taken action on files and folders in My Drive. You’ll see a rundown of what your team has been doing, such as editing and commenting on team notes, adding a new spreadsheet, renaming a presentation, sharing with your boss and more.

It’s also easy to only see what you’re interested in. Select any file or folder and the stream will change instantly to show information relevant to just that item.

And last month it became easier to take quick actions on your folders like rename, share, organize and more with a new drop-down menu at the top of each shared folder. Below this menu youll see the entire folder hierarchy so you can jump to a different folder with a single click. And you can see profile pictures to help you understand exactly who has access to the shared folder.

Activity stream is rolling out over the next week, so try it with your next group project to make working together a bit easier with Drive.

Read more

Best Android Game Of 2013 listed in Google Play Store

As the year going to end and the new year is coming soon,Google play store listed top 10 best android games of 2013.The best android game of 2013 is picked depending upon the popularity and the number of downloads.They have listed the best game in play store for the users to easily pick their choice.The best android game of 2013 is listed below with the download link.

1.DragonVale    -    Download

Company- Backflip Studios,Inc.  

Category- casual
Review  -4.4/5
Size - 44 MB

2.Cytus              -    Download

Company- Rayak Inc
Category- Arcade and Action
Review  -4.9/5
Size - 400 MB

3.The Simpsons:Tapped Out   - Download

Company- EA Swiss sarl
Category- casual
Review  -4.4/5
Size - 31 MB

4.Despicable Me      -  Download

Company- Gameloft
Category- casual
Review  -4.6/5
Size - 20 MB

5.Clash of Clans    - Download 

Company- Supercell
Category- Arcade and Action
Review  -4.7/5
Size - 48 MB

6.Plants vs. Zombies 2    -  Download

Company- EA Swiss sarl
Category- casual
Review  -4.4/5
Size - Varies with device

7.Angry Birds star Wars II Free -  Download

Company- Rovio Mobile Ltd.
Category-  Arcade and Action
Review  -4.7/5
Size - 47 MB

8.DEER HUNTER 2014   -  Download 

Company- Glu Mobile
Category-  Arcade and Action
Review  -4.6/5
Size - 39 MB

9.Real Racing 3      -   Download

Company- EA Swiss sarl
Category-  Racing
Review  -4.0/5
Size - 12 MB

10.Into the Dead      -   Download

Company-PIKPOK
Category-Arcade and Action
Review  -4.5/5
Size - 30 MB

The above mentioned games are top 10 android games of 2013 in Google play store.The top android games for 2014 will be mentioned soon.

Read more

What is Mobile Wi Fi Hotspot in a mobile How to use

Most smart phone and smart android phones already have this feature built in to the phone. wi-Fi hotspot simple meaning wireless access point, Wi-Fi hotspot is sharing internet between wi-fi devices.

You have wi-fi hotspot device you can share internet connection to your friends smart phones, and other wi-fi enabled devices. Ex.smart phones, laptop, etc..,.

I am going to explain how to Active Wi-fi hotspot and how to share internet connection on your samsung galaxy y android phones.

You can follow these simple steps

• Go to menu > settings > Wireless and networks.
•  Select Tethering and portable hotspot.
•  Select portable Wi-Fi hotspot settings.
• Select Configure portable Wi-Fi hotspot settings.
• Type Your Hotspot Network SSID Name.
• Select Security type open > save 
• Select (Tic) portable Wi-Fi hotspot.

Now you can share internet other WI-Fi enable devices. Enjoy.

Read more

Motorola Moto G Is now available in India for RS 15000

Motorola Moto G has so many expectations from android lovers because its a low end budget android mobile at this price rate.Motorola moto G is already launched in US and Expected to available in India from January on wards.This mobile has made a huge space for Budget android users.Though everyone expect this mobile from January In India , Motorola Moto G is now available in India now.You can buy Motorola Moto G in India at shopyourworld.com.Book your most awaited Moto G In India here :Buy Motorola Moto G here 

Also read : Motorola Moto G specifications and features 

Motorola Moto G price details in India :

Motorola Moto G is a low end budget android mobile with high specification and it has two options of 8 and 16 GB variance.The price of the mobile for 8GB and 16GB is geven below

Motorola Moto G 8GB price in India   :15,137 Indian Rupees

Motorola Moto G 16GB price in India :17,089 Indian Rupees

Search results : Motorola Moto G price in india,Motorola Moto G launch date in india,Motorola Moto G release date in india,Motorola Moto G 8 GB price in india,Motorola Moto G 16 GB price in india

Read more

Changes to the SecretKeyFactory API in Android 4 4

Posted by Trevor Johns, Android Developer Relations team

In order to encrypt data, you need two things: some data to encrypt and an encryption key. The encryption key is typically a 128- or 256-bit integer. However, most people would rather use a short passphrase instead of a remembering a 78-digit number, so Android provides a way to generate an encryption key from ASCII text inside of javax.crypto.SecretKeyFactory.

Beginning with Android 4.4 KitKat, we’ve made a subtle change to the behavior of SecretKeyFactory. This change may break some applications that use symmetric encryption and meet all of the following conditions:

1. Use SecretKeyFactory to generate symmetric keys, and


2. Use PBKDF2WithHmacSHA1 as their key generation algorithm for SecretKeyFactory, and


3. Allow Unicode input for passphrases

Specifically, PBKDF2WithHmacSHA1 only looks at the lower 8 bits of Java characters in passphrases on devices running Android 4.3 or below. Beginning with Android 4.4, we have changed this implementation to use all available bits in Unicode characters, in compliance with recommendations in PCKS #5.

Users using only ASCII characters in passphrases will see no difference. However, passphrases using higher-order Unicode characters will result in a different key being generated on devices running Android 4.4 and later.

For backward compatibility, we have added a new key generation algorithm which preserves the old behavior: PBKDF2WithHmacSHA1And8bit. Applications that need to preserve compatibility with older platform versions (pre API 19) and meet the conditions above can make use of this code:

import android.os.Build;
 
SecretKeyFactory factory;
if (Build.VERSION.SDK_INT >= Build.VERSION_CODES.KITKAT) {
   // Use compatibility key factory -- only uses lower 8-bits of passphrase chars
   factory = SecretKeyFactory.getInstance("PBKDF2WithHmacSHA1And8bit");
} else {
   // Traditional key factory. Will use lower 8-bits of passphrase chars on
   // older Android versions (API level 18 and lower) and all available bits
   // on KitKat and newer (API level 19 and higher).
   factory = SecretKeyFactory.getInstance("PBKDF2WithHmacSHA1");
}

Join the discussion on



+Android Developers

Read more

What’s new in 2014 a year of technology

What’s new in 2014...

Have we reached the point of diminishing returns?

With 2013 now behind us, I want to look back upon the past year and analyse the technology we saw, as well as speculate upon what we are likely to see this year. I think 2013 was a relatively disappointing year for mobile phones, however 2014 looks more promising.

Displays of 2013

For many, 2013 will be known as ‘the year of 1080p screens’, as almost every flagship model incorporated these high resolution displays at the cost of battery life and overall fluidity. This meant that overall performance seemed stagnated in general operations, with the HTC One X rarely under performing to the HTC One, except in gaming performance. 

However, the benefits of a 1080p screen as compared to a lower resolution are noticeable to most and definitely offer an improved experience, resulting in less eyestrain and the ability to browse the web more elegantly. Of course, not every 1080p screen is equal. We saw improvements in colour reproduction, brightness and touch sensitivity in 2013, as well as advancements in technologies like AMOLED. With Apple retaining it’s sub-720p display on the iPhone 5S, many agreed that this was subpar and that this will need to be improved upon in 2014, else market share will suffer. The Xperia Z was widely criticised for its poor viewing angles, resulting in poor sales despite otherwise quality hardware. This shows the great importance of a quality screen in the current market. Display size in 2013 saw a huge increase from previous years. In 2010 for instance, the display of the iPhone 4 at 3.5 inches was considered large. By 2011, the Galaxy S2 had upped this to a 4.2” screen, and in 2012 the Galaxy S3 was released with an even larger 4.8” screen. 2013 can be known as the ‘phablet year’, with a large number of phones released with a screen size larger than 5 inches. This is a trend on the rise and I believe that in 2014, any screen with a size less than 5” will be regarded as ‘small’.

Displays of 2014

In 2014, many smartphones are rumoured to be incorporating WQHD screens, with a resolution of 2560 x 1440. This is a resolution higher than most laptops on the market and seems to be overkill for a screen so small. The benefits of 1080p were visible, but with another resolution jump, the impacts on performance and battery life dont seem justified. A 1080p screen seems pin sharp and any higher may truly be more pixels than the eye can distinguish. This year in the television industry, there will be a major focus on OLED displays, due to their superior black levels, brighter whites and fast refresh rates. However, in the mobile industry I believe that LCD will still dominate, due to a cheaper cost and advancing technologies allowing for higher resolutions on a thinner screen. Only Samsung and Nokia are currently utilising OLED screens and while they are praised for their colour saturation and black levels, many argue that the colour is not reproduced accurately and that the Pentile matrix of Samsung’s latest screens means that they are not at true 1080p. OLED displays also commonly have a tint, resulting in darker, less pure whites. The S4 for instance has a clear blue/green tint when compared to the HTC One which uses an LCD. To conclude, I believe that in 2014, 1080p will be the standard resolution for most phones, with a few rising to 2560 x 1440. The benefits of this are yet to be determined. Screen sizes in 2014 will be 5” or above for flagship devices, with the Galaxy Note series increasing to around 5.9”.

Batteries of 2013

In any portable device, battery life is a major concern and in mobile phones, this has an even greater importance. Over the past few years, battery life hasnt really improved. This isnt due to the non advancement of battery technology, but more due to the increased power usage of components in phones, with the latest screens and SoCs using more power than they did a couple of years ago. This creates the illusion that the batteries used are exactly the same as those used in 2011, while really they are advancing at a steady pace. For example, the HTC Desire (was one of the highest rated phones of 2010) utilised a 1400 MaH battery, while the HTC One uses a 2300 MaH battery. With 900 MaH extra capacity, the HTC One should have greatly improved battery life, while in reality it is not much different. This is because of the more power hungry components. One anomaly in 2013 was the iPhone 5S, which uses a 1570 MaH battery. This is far lower than other flagship phones on the market yet still manages to provide a days usage. This is due to the less demanding processor, as well as software optimisation in the closed Apple ecosystem. The drawback of current batteries is that they are still too large. To include a large 3,200 MaH battery such as the one found in the Galaxy Note 3 requires… you guessed it, a phone the size of a Galaxy Note 3. This means that phones cannot continue to get much thinner with the current generation of batteries, else battery life will suffer. 

Batteries of 2014

Phones released in 2014 will have a healthy bump in MaH as compared to 2013, however we shouldnt expect to see a noticeable difference in usage times, due to the impending release of WQHD displays and even beefier processors. I believe MaH will hover around the 3000 MaH range for flagships this year, with phablets potentially pushing towards the 4000 MaH mark. A day of solid usage can be expected. One thing that split opinions in 2013 was the issue of the removable battery. It was argued that it was required in order to switch batteries when the original had lost charge through age and that non-inclusion was a type of planned obsolescence. Others argued that many don’t keep a phone for longer than 2 years and that in this time, a battery would still maintain at least 75% of the original charge. Personally, I find a removable battery useless for my needs and think that the design changes required to incorporate one are detrimental to the looks of the phone. I would take a well built solid unibody phone over one with a removable flimsy back cover any-day. In fact, a removable battery just seems so old school, Nokia 3310 anyone? In 2014, unibody phones will be standard.

Cameras of 2013

In 2013, DSLR sales suffered. This was mainly due to the increasingly good picture quality on mobile phones. While professional photographers can’t sell their professional equipment yet, for many users a mobile phone camera is more than sufficient. Cameras in 2013 saw resolutions as high as 13 megapixels, while some manufacturers decided to go in the other direction: reducing the number pixels in return for better low light photos and less noise. There is split opinion on the effectiveness of this strategy. Personally I prefer the photos taken from the standard 8 megapixel HTC One X camera than those taken from a 4 megapixel HTC One, with 2um pixels (‘Ultrapixels’). The 13 megapixel camera of the Galaxy S4 can take some great shots, however colours are too processed and noise is an issue with such a small sensor. Overall, I think that the greatest camera of 2013 was that on the iPhone 5S, which features an 8 megapixel shooter with larger pixels like seen on the HTC One. This allows for good sharpness while also reducing noise. Mobile phone cameras now have a number of quality features that even DSLRs can’t match, such as high quality slow motion video, 4K video recording and options to remove unwanted objects from an image with a simple tap. Shooting speeds also dramatically increased from 2012, with speeds of up to 10 photos per second. 

Cameras of 2014

I think that this larger pixel technology will be seen more often in 2014, with HTC and Apple likely to continue the trend. However, I wouldn’t expect to see Samsung attempt this. In fact, a 16 megapixel camera on the Galaxy S5 wouldnt surprise me. HTC will likely release an 8 megapixel ultrapixel camera, while Apple could either remain at 8 megapixel or jump to 13. Expect to see an improvement in editing options this year, as well as the rise of 4K video. Optical image stabilisation will also be included in most of the flagship devices, as this removes camera shake from photos, meaning that photos taken with a non steady hand or on the move won’t be blurred.

An 8MP camera with 2um pixels will require a phone to be 18mm thick at the camera site; not sure if any manufacturer will go there. Check out this article for more details - Cameras in Phones - what do we really need?

Processors of 2013

Qualcomm dominated 2013 with their Snapdragon range. In fact, every Android flagship of 2013 used a variant of a Snapdragon processor, with the exception of the 8-Core Exynos processor used in certain non-European models of the Galaxy S4. The first 64 bit mobile processor came in 2013 with the launch of the Apple A7. This offers certain improvements, such as a 25% performance increase just for apps that are compiled in 64bit, as well as being able to handle more RAM for the future. Processors have reached the stage where most activities on a device are fluid and apps launch very quickly. The GPU on a SoC matters more, as this determines gaming quality and can affect the FPS of general device navigation and scrolling. The Snapdragon 800 and Apple A7 are very fast CPUs. An interesting point is that while all Android flagships used a quad core CPU in 2013, Apple only used a dual core. The dual core A7 even outperforms the quad core Snapdragon 800. This is due to the ARMv8 internals of the chip. Every processor currently used in Android devices is ARMv7 or less. ARMv8 offers a number of improvements including 64 bit support, faster handling of encryption and an increased number of registers.

Processors of 2014

Currently, the Snapdragon 805 is expected to be released in the first quarter of 2014. This is known to have a maximum clock speed of 2.5GHz and an Adreno 420 GPU. However, it is still based on ARMv7, meaning it is 32 bit. This means that Qualcomm is actively slowing down the development of ARMv8, even with ARMv7 currently at the end of its cycle. I expect to see an ARMv8 processor from Qualcomm towards the end of 2014. Processors will remain at quad-core for the most part and I expect Apple to keep its dual core set up which has proven itself as a great performer.

Have any questions or comments? Feel free to share! Also, if you like this article, please use media sharing buttons (Twitter, G+, Facebook) below this post!

Read more

Flipkart announces In a day Guarantee delivery

Flipkart is the leading online shopping and eCommerce in India.It launches the In a day Guarantee delivery same like Amozon have.At first In a day Guarantee will be available in 7 cities Bangalore,Chennai,Delhi,Hyderabad,Mumbai,Noida and Pune.So now you can receive your item within one day without any long waiting.

How it works ?

• place your order before 6 PM and receive your shippend the very next day

• In a day Guarantee delivery charges Rs.90 per item

• In a day Guarantee option can be selected in payment stage

Read more

Nokia Asha 502 in India for rs 5799 specifications

Nokia Asha 502 will be available in India from now on wards.After the huge response of  Nokia Asha 501 Nokia releases Nokia 502 worldwide and now it comes to India.The price of Nokia asha 502 is Rs.5799 as mentioned in the e commerce shop.You can prebook your Nokia Asha 502 today and get it in the fourth weak of December. Buy ie pre order your Nokia asha 502 for Rupees 5799 at flipkart today.Prebook here  

Also read :Nokia asha 502 specs

Nokia Asha 502 specifications and features :

3 Inch LCD touch display
Java OS
5 MP rear camera With LED flash
WIFI enabled
FM radio
64 MB internal memory
1010 mAh battery

Search results :
Nokia Asha 502 price in india
Nokia Asha 502 release date in india
Nokia Asha 502 specs
Nokia Asha 502 features
Nokia Asha 502 buy online

Read more

Hiring From IT Managed Services In Austin

By Angela Briggs

Anyone focused on the idea of trying to manage their businesses in a consolidated manner is often overwhelmed with all that is required. Dealing with specific departments and potential issues that could be well beyond the skills of the owner and all employees typically requires the use of trained service provider of some kind. Owners that are searching for this kind of assistance should know the basics of hiring from IT managed services in Austin to ensure their needs are successfully managed.

IT managed services offer the technologies and personnel required to oversee all computer related systems for their clients. Most owners concentrate on this provider when trying to avoid hiring full time professionals and lack the skills for individual oversight. The choices made from all available companies can be difficult for owners to complete.

Companies in Austin that are searching for this form of assistance have a vast array of opportunities to consider. Many owners are unclear about all that should be weighted when trying to be confident their needs will be fully managed. The right choice is much easier to complete when several factors are weighted.

Testimonials and review are some of the most helpful bits of information that owners could consider when making their choice. Companies that are currently or have previously used the provider are some of the best source of information as they are directly aware of the kinds of solutions they offer their clients. The best rated companies that have also received positive testimonials from similar clients are often the most productive to choose from.

Assistance formats that are offered from the company should receive attention as well. Companies are known to offer varied degrees of assistance to their clients that are usually based on being either directly involved with them or by providing oversight through an internet portal of some kind. Owners should match the solutions offered with what they are most comfortable with to avoid unnecessary complications.

24 hour access to support is also a major consideration when making this choice. Most businesses now operate to some degree around the clock which creates the need to find contractors and suppliers that are able to accommodate their operating schedule. Professionals usually market this features which can be helpful in narrowing the options.

Security solutions are also helpful for owners to focus on when making the right choice. Most computer technologies are utilized to store and manage data which must be kept as safe from viruses and theft as possible. Companies that implement effective programs are often the best to focus on when seeking out their services.

When choosing from IT managed services in Austin consumers are also focused on their pricing. Company budgets are often difficult to manage on a monthly basis which creates the need to find low total costs and effective solutions. The most comprehensive assistance options that are also the most affordable help owners find a great deal for their companies.

About the Author:

Discover the best IT managed services in Austin by visiting our official website at www.tpcaustin.com today. To know more about our past projects and get detailed information on our products and solutions, click the links at http://www.tpcaustin.com right now.

Read more

Guns No Longer In Short Supply

I was talking to my friend Terry Hoover who works for Armageddon Armory a couple of nights ago, and I mentioned that it looks like the panic buying of ammunition and guns has cooled off a bit, and he agreed.  In fact, they are awash in guns right now, sitting on the shelf, waiting for someone to give them a good home!

The prices he quoted on some of them actually seemed almost reasonable.  (I still have some heart repair and kidney stone removal bills to pay off.)  This is what he said was in stock:

Many models of AR-15 (.223/5.56mm) rifles in stock manufactured by:

Colt

Armalite

Sig Sauer

Windham

Daniels Defense

Ruger

Adnerson

Stag

Bushmaster

DPMS

LAR

American Tactical

Several Models of AR-10 (308/7.62mm) manufactured by:

Armalite

Bushmaster

DPMS

 

Armalite AR50  50BMG rifle

LAR Big Boar 50BMG rifle

Barrett M99 50BMG rifle

Barrett M82A1 50BMG semi auto rifle

Barrett M107 50BMG semi auto rifle

Lots of 50BMG ammo in stock, new and remanufactured, Ball, Armor Piercing, Tracer, Armor Piercing Incendary Tracer, etc.

Bushmaster M17S

IO AK47 (hot pink) 7.62x39

Norinco SKS

CAI Yugo AK pistol

Arsenal .223 AK pistol

Keltec SU 16 .223 folding rifle

Professional Ordinance CARBON AR-15 Pistol (before Bushmaster bought them out)

PTR-91

PTR-91 Pistol

FN-FAL (by CAI)) several

C91

Sterling MK IV 9mm

Mini 14 ranch rifle target

Mini 14 ranch rifle wood

Mini 14 ranch rifle synthetic

Auto Ordinance M1 Carbine new

1944 Inland M1 Carbine

1943 Saginaw Steering Gear M1 Carbine

Springfield Armory M1A (308/7.62mm)  wood
Springfield Armory M1A (308/7.62mm)  synthetic

Mitchell Mauser Yugo M48

Model 91/30 Russian Mosin Nagant 7.62x54R (several)

Model 59 Russian Mosin Nagant 7.62x54R

Swiss M1911 straight pull rifles

Steyr 1895 straight pull rifles

Enfield Volley Rifle

 

Cobray clone  M11 380

Cobray clone M11 9mm

Cobray clone M10 45

 

.22 caliber Assualt Rifles look alikes

AR-15 Colt

AR15 S&W

AR15 Mossberg

HK MP5

UZI

M1 Carbine

PPSH

AK47

HK 4160

Beretta ARX160

 

22 pistols

Beretta Neos

Ruger

High Standard

SIG Mosquito

Ruger SR22

Walther P22

Phoenix

handguns  ( 380 & 9mm)

Springfield Armory

Astra

Cobra

Taurus

CZ

Beretta

Hi Point

Keltec

Pock Island

Browning

SIG

Tanfiglio

Diamondback

handguns 1911 .45

Colt

Rock Island Armory

SIG

Taurus

Para Ordinance

Metro

Springfield Armpry

Remington

Colt Tactical Elite 38 super

 

Also

Judges, derringers, Tokarev, Makarov, black powder revolvers, many many 2 inch barrel 38 revolvers, hunting revolvers,

 

cowboy guns , lever action rifles and single action revolvers  TOO MONY TO LIST !

 

Siaga Shotguns in stock, 410, 20 gauge and 12 gauge, tactical and regular versions, drums, stocks parts in stock !

 

dozens of riot shotguns, mini shotguns

hunting rifles new and used

youth hunting rifles

Rascal and Cricket  youth starter rifles

 

AMMO 

Tracer .223, 308 amd 7.62x54R 50 BMG

3006

308

8mm Lebel

45, 9, 380, 9 makarov, 357 sig, 10mm, 38, 357, 44, 45, 45LC,

Hunting ammo

sorry NO .22LR, 17, 22Mag, 30-30, 30 carbine, 30 tokarev, or 22-250 at this time

Meals Ready to Eat  MREs by the entree, the single bag, by the case or dozens of cases, we have them 25 year shelf life.

Read more

Super Hero Skit in Eastwood from Advil

Last July 1, there were reports of people who 'encountered' montsters in the Eastwood Open park. I was informed that it all started when some people gave out flyers, warning people about pain monsters roaming around the area. Then this happened:



Read more »

Read more

Running gwt in eclipse from external server

Read more

Great to have Susan and Laura in Town!

My sisters visited me this week!  Huray!

Read more

Create a basic class in Excel

Create a basic class in Visual Basic Excel

You have heard of class in programming including in VBA or VB. But never had you tried to use them because you are afraid to mess your program. In fact Class is very simple to use and understand. Many sites explain class correctly and surely better than me.

If you started to program in MS-Excel, you never really use them and are perfectly normal. You program function directly to operate instructions over instructions. When you program in VBA work with a lot of data, you cycle over a range of cells or loop over an array of cells or data. That data might be a number, a date or a word.

Here, I will not try to change you habits. I will just simple point out how a simple class might help you a lot.

First lets try to visualize this excel sheet. Sorry if the image is in French.

In the VBA module, here is the code. There will be 2 procedures. The first one doesn’t use any class. The second do the same thing than the first one except it use classes to store the data. The procedures are very stupid and do nothing incredible. Yes you could surely to thing better that is not the point.

If you take a look carefully at the first test procedure, you will notice I will do 2 loops. The first loop, I will read all the value for each row and each column. While I am looping the cells, I store (save) the data in a string variable. At the end, I display the information. OK.

But what happen if you want to read a value again? You will have to go over all again the 2 loops. Of course, you will find your value, but manipulating cells are heavy. Your sample is very small. The moment you Excel sheet is bigger, your program is not be powerful. Yes, small code offends means cheap and simple.

Also, if you need to get an information, of course you have to find it but the information is in a 2D cell and again, is not always easy to look for the information when is not stored in a single group. The moment you have to different table, you are dead.

Public Sub test()     Dim index1 As Integer     Dim oRange As Range     Dim str As String              Set oRange = Range("A1", "C6")     str = ""         For index1 = 1 To oRange.Rows.Count         For index2 = 1 To oRange.Columns.Count             str = str & oRange.Cells(index1, index2) & vbCrLf         Next         str = str & "======================" & vbCrLf     Next     MsgBox str End Sub

So before we take a look at the second function, we have to take a look at the class.

See how simple is your class. We simple put the names of the information you wish to gather together

The class has only 3 lines. Of course you could all the lines you need if is part of your class.

When you need to use it, it might look to something like this:

Public Sub test2()     Dim index1 As Integer     Dim oRange As Range     Dim str As String     Dim oClass1 As Classe1     Dim oEmployee As Collection     Set oEmployee = New Collection         Set oRange = Range("A1", "C6")     str = ""         For index1 = 1 To oRange.Rows.Count         Set oClass1 = New Classe1         oClass1.Name = oRange.Cells(index1, 1)         oClass1.Salary = oRange.Cells(index1, 2)         oClass1.hireDate = oRange.Cells(index1, 3)         oEmployee.Add oClass1     Next     For index1 = 1 To oEmployee.Count         Set oClass1 = oEmployee.Item(index1)         str = str & oClass1.Name & vbCrLf         str = str & oClass1.Salary & vbCrLf         str = str & oClass1.hireDate & vbCrLf         str = str & "======================" & vbCrLf     Next     MsgBox str     End Sub

Please notice this, there is 2 loops. Honestly, I tried not to change to much from the first procedure. But think about this. You worked a little bit more and created a little bit more code but instead of manipulating the cells directly, you save the information in a collection of class. Each class represents an employee.

So if you need to locate an employee, as soon you find you class base on the Name, the HireDate or the Salary in the collection, you will automatically get the rest of the data. You don’t have to care of the table range or the column number or the line number. Is not important if some data if placed elsewhere in your sheet or worksheet?

Also, believe me. If you take this good habit, you will notice that the loop will run faster. Yes, manipulating small object is lighter. Playing with 3 words is lighter than 3 cells (because of the text style, graphic…)

Download the sample used in this post: Classeur1.xlsm (Microsoft Excel 2010)

Visit my web site on: http://checktechno.ca/en

Please comment or share if you like this post .

If you like this post, leave a comment or share it.

VBA Excel Post related: 

vba sleep in Microsoft Excel

Create a basic class in Visual Basic Excel

All you need to know with Visual Basic and Excel

Error Handling in VBA

Read more

Raking in Awards for NCH Software Applications

The good folks over at TopTen Reviews have been busy and have recently added a few new reviews of some NCH Software favorites to their site. Most notably, they have added VideoPad video editor to their video editing line up, highlighting the extreme ease of use of this small but powerful movie making program.

"Learning to use VideoPad requires very little effort. Indeed, it’s intuitive enough that we were performing some basic functions before even taking a look at the user manual. Drag and drop technology is at the heart of the simplicity. All of the most fundamental processes, including moving clips from the media list to the video and audio tracks or rearranging split clips, can be accomplished in this manner. Other processes are simple too, generally requiring nothing more than clicking a button or selecting an option from a menu. Even adding transitions and effects is just a mouse click away."

– TopTenReviews video editing software review

Test drive our easy video editing software for yourself. We think you will agree with TopTenReviews and be amazed at how easy it is to make your own movies with VideoPad. To help get you started you can also check out our VideoPad video tutorial for a quick tour of the program and some of the features you can use when you are editing your first masterpiece.

VideoPad wasnt the only product to get recognized. Express Burn is polishing a new bronze for cd burning which is only one of the many features of the powerful disc burning software. And WavePad can now boast at having a gold, two silvers and a bronze award from TopTenReviews in different categories, with a new silver in mp3 editing and a bronze for voice recording.

"NCH Software is well-known for its broad range of super multimedia software. WavePad, their entry into the MP3 editing software category, has all the same looks of a quality NCH program. With WavePad, you can do everything you would possibly want to do with an audio file with their assortment of editing tools and effects."

– TopTenReviews MP3 editing software review

We design all of our software with the user in mind, and winning awards is just an added perk, but it is nice to be recognized for some of the things we strive for like ease of use. We hope you will agree with the reviewers at TopTenReviews and fall for our simple and award-winning software solutions.

Read more

Part 13 C Looping Tutorial In Urdu Basic Syntax

Part 13 - C# Looping Tutorial In Urdu (Basic... by programinurdu

Read more

Part 3 Introduction to Microsoft Word 2010 In Urdu Page Layout Tab

Part 3 - Introduction to Microsoft Word 2010 In... by programinurdu

Read more

How to send Email in Malayalam

How to send Email in Malayalam

Read more

How to use filter in Photoshop

How to use filter in Photoshop

Read more

YouTube to Stream Live Makkah Prayers in Ramadan

Here is a good news for all the Muslims out there. Keeping up the spirit, Google has partnered with Saudi Ministry of Culture and Information to stream live Makkah prayers in this Ramadan.

An official page at YouTube has been made which will show live prayers from Makkah for the whole month of Ramadan.

Google in a statement said that:

This is the first LiveStream event coming from MENA, specifically Saudi Arabia, and we hope that it will give the opportunity not only to two billion Muslims but to the entire world to observe one milion Muslims praying each day from the holiest point in Makkah, the Kaaba, for the first time in history.

Following is the live stream of prayers from Masjid ul Haram, Makkah:

Live streaming link: http://www.youtube.com/MakkahLive

Read more