How the Excel Macro Recorder Works

The Excel macro recorder is a built-in engine that tracks and stores your actions in Excel; its capabilities and features must be understood so you record efficient macros.

Additionally, you will need the Macro recorder even after you learn how to write macros from scratch; I still use it to record simple macros and as an Excel VBA content provider.

So let's start …

1) The Excel recorder registers every action you perform on Excel

On your audio recording device; while the Record button is pressed, everything is recorded: your voice and the background noise. On Excel; the same thing happens; while it is in recording mode every action is recorded.

These actions may be: selecting a cell, writing a formula, scrolling, formatting a cell, zooming, etc.

And every action is written on a line per line basis.

Take into account that the same way a voice recording captures your predictions and background noise, the macro recorder captures everything you do, including your mistakes and incidental actions.

2) The Excel recorder generates a VBA instruction after the given action has been performed on Excel

When you record your voice, you need to talk first so the recording device captures your speech; the same thing happens with Excel Macros.

You need to perform an action on Excel (see left window below) so the Excel recorder registers it.

This is one of the main shortcomings to develop smart applications. A Macro does not have flow control, it starts and ends. It has no anticipation, no decision.

The unique way to build smart applications is by improving a macro or by writing it from scratch.

3) The Excel recorder changes the "properties" of Excel objects programmatically

At first sight the produced VBA language is Greek; nothing more far from truth.

Decode the VBA language grammar quickly by reading a short introduction to objects …

On the real world, your hair has properties: length, color, type; you can cut it, change its shape, etc. Your hair behaves in specific ways: it grows, it falls, etc.

Some properties can be changed, like the color. Yes you can apply a cosmetic treatment and turn your black hair into red, blond, etc.

Some properties are read-only, you can know them but you can not change them. For example: your hair type: curly, straight.

Let's summarize the features of your hair …

  • A hair Property is what you hair is: length, color, etc.
  • A hair Method is what you can do with your hair: cut it, change its shape
  • A hair Event is how it behaves: it grows, it falls, etc.

Now back to Excel …

Excel has properties and methods too, and you can manipulate them by using VBA language.

You are fully aware of the way you change properties of Excel objects, you know how to change the color of a cell, the font, the name of a sheet, etc. But you are not quite aware of how to change them programmatically; a Macro preforms that very easily.

And finally …

4) The Excel recorder uses the "methods" of Excel Objects programmatically

The same way you change the properties, you use the methods of Excel objects when you cut a cell, delete a sheet, open a workbook, etc.


Sony Drbt50 Stereo Bluetooth Headset – Comfort, Quality and Performance – All in One!

The Sony drbt50 stereo Bluetooth headset boasts 40mm device driver units that drive home crisp treble and spectacular bass for first-rate sound accuracy. And an agronomic inside ear cup design makes for a superior fit and provides increased sound tones. The built-in rechargeable battery pack supplies about seventeen hours of music playback time on a single charging, so you are able to savor your favorite music even longer. Remote operation of the play, stop, fast forward and rewind buttons on the earphone is included for your comfort.

If you’re planning to clamp something to your head, comfortableness is going to be all important. The first thing you will notice about the Sony drbt50 stereo Bluetooth headset will be the deluxe cushioned ear pads and head band. They’re an unbelievably comfortable pair of cans. The ear cups cradle your ears lovingly, even for long periods. Those of you with bigger auditory receptors will experience being cared for since the fragile headphone cushioning positively caresses your stress-prone ears.

I’ve noticed a little, but really handy feature: a button on the side of the headset permits you to answer mobile phone calls, and an assorted volume and navigational controls enable remote operation of an MP3 player or a matched handset. If your telephone rings while you are listening to your favorite song, the music is automatically paused and your telephone call is put through to the headphones. Hang up your telephone call and the music continues from the same place you left it. Neither your telephone nor your MP3 player have to come out of your pocket. What a perfect handy little feature.

Comfort apart, sound quality is the next all important ingredient. The Sony drbt50 stereo Bluetooth headset with unsurpassed bass replication, bringing forth a powerful almost live performance.


Sony Ericsson S500i – The Yin and Yang

The Sony Ericsson S500i supports the following networks: GSM 900 / GSM 1800 / GSM 1900. It comes in the dimensions of 91 x 47 x 23 mm. Moreover, it has a weight of 98 g. The display of the Sony Ericsson S500i comes in the TFT, 256K colors with 240 x 320 pixels.

Moreover, it has a second external display of OLED, 65K colors. The ringtones comes in the type of Polyphonic (64 channels), AAC. It also supports vibration alert. The memory of the phone can show 1000 entries. The call records appears in the following manners: 20 dialed, 20 received, 20 missed calls.

The Card slot in the phone is microSD (TransFlash) with 80 MB shared memory. The phone does not support HSCSD and 3G platforms. It is worth to mention that the Sony Ericsson S500i supports EDGE. Its connectivity in the Bluetooth is v1.2 with A2DP.

Extending to the other connectivity part of the phone, the phone has Infrared port and USB. Of its other features, it comes with the following features in the messaging section: SMS and MMS.

The browser is i-mode. The color of the phone is black. For the users of the phone the camera has a 1.3 MP, 1280×1024 pixels, video, flash features. And for the music enthusiasts it has an MP3 / AAC player.

Coming to the organizing part of the phone it has T9 feature. It also comes merged with Organizer and Voice memo. The battery of the phone is Standard battery, Li-Ion 800 mAh. It gives Stand-by up to 190 h; and talk time up to 3 h.

The S500i model of the phone comes in a clamshell shape and is much better than the S400i. For beginners, the efficiency of the phone are much better – there's a 1.3 megapixel camera with video recorder.

Moreover, it also comes embedded with an MP3 player with stereo external speakers, support for stereo. It also has Bluetooth and USB connectivity. From the memory point of view, it is fantastic, with 80 Mbytes of internal memory plus an expandable TransFlash memory card.


Samsung G600 – The Ideal 3G Multimedia Handset

Another slider phone from the lineage of Samsung comes with outstanding features. With the launch of the Samsung G600, it has given a tough competition to phones that holds high-profile features. The sophisticated designing of the handset boasts of an ergonomic keypad as it allows the users to feel an essence of ease.

The sleek and stylish phone measures 102×47.8×14.9 mm and weighs only 105 grams including battery. The desirable slider phone is incorporated with a smooth finish and easy sliding mechanism. The large 2.2 Inch TFT screen of the handset provides upto sixteen million colors on a high resolution with 320×240 pixels. The handset flaunts a 5 megapixel camera that comes with a complete camera features and image settings. The handset allows users to click or record the jolly moments of life on the move. The built-in flash and auto focus ensures users to enjoy and capture beautiful clear and accurate shot at any time of the day and night. With the video recorder, users can record those vividly as well as action packed moments. The video recorder capabilities allow various features like recording and playing video footage in popular video formats on their Samsung G600.

With the Samsung G600, users can enjoy the beat of polyphonic and melodious MP3 ring tones. Moreover, the handset is embedded with a music player that can be played on various music formats. The stereo FM radio features allow users to tune on to various FM channels to get updated with news or songs.

The memory of 55 Mbytes plus compatibility for Micro SD memory card allows users to store pictures, video clips and music. Apart from this, the handset offers a fast an easy data transfer, as it comes with high-connectivity options such as Bluetooth, USB, GPRS and advanced EDGE technology. The high-end WAP 2.0 XHTML and NetFront HTML browsers allow users to access the internet and browse the favorite web pages. With the G600, users enjoy impeccable features and great connectivity around the world.


Intrinsic Motivation and Competence

Okay how do we motivate ourselves from within? When we were children, maybe we tried to learn something new like riding a bike. When after having learned it, sometimes unconsciously, we reaffirmed ourselves-we say to ourselves we have learned something new and challenging. We have become competent.

Competence and even just the feeling of competency can give birth to motivation. So that is where you can start. So maybe you want to try something new-exercise, school, a new sport or a new job. But maybe, you feel you can not motivate yourself. Well, you can start with your skills and talents.

Skills and talents are the vital components of competence. Even it is just so basic like being able to read-you can turn that into a foothold for motivating yourself from within. Of course, extrinsic motivations can be helpful. Grades, self-rewards and praise from others can be very refreshing and revitalizing. However, there are times, when these are not enough. We need to find the reasons from inside us, from within.

So how do you do that? Okay, first think of a skill or a talent. Remember the time you first learned that skill or used that talent. So, you can imagine the feeling and situation once again how hard it seemed at first. Then also recall the time afterwards when you achieved your goal. Establish that feeling within you. Try to make it available for later recall. The technique is when you are already going for your new challenge; then you will be able to recreate all these feelings from within you. So that is a start for stimulating yourself.

So begin this exercise, and use it for as long as you need to. Being self-assuring is not a kind of self-deception. You should not fool yourself with positive affirmations in the surface. Positive affirmations are helpful when these come from deep informed beliefs based on experience. The experience you have a child is still helpful indeed.

So in any case, intrinsic motivation is based on this sense of competence. We all need this sense of competency in order to have the will to start at something. You can of course complete these with extrinsic motivating factors, but you have to make sure that most of your motivation comes from within you. This is important, because you can lose quite a lot from without, from the external environment, so you then have to look for what is inside you.


Earbuds: Foam Versus Rubber Tips

When it comes to technology, every part of a contraption serves as a way to complete a bigger picture. You will rarely see anything extraneous inside of a piece of technology as a result. You don’t find exra buttons on a remote. You don’t find extra steering wheels in a car. The same concept applies to your music. So, you decide you want to listen to some jams, and you realize that the earbuds you’re using make your ears bleed. What gives? The general rule of thumb is that the more expensive the ear buds are, the better the sound quality and overall craftsmanship will be; however, it is still important to take earbud tips into consideration when shopping.

If you’re trying to save money, and you are stuck with having to choose between two earbuds, always look for the shape and contour first. You never want to settle for anything that is flat shaped because such shapes do not complement the shape of your ear canal. Those who buy flat shaped earbuds tend to have many complaints of the tips falling out of their ears while they are engaging in normal, every day, activities. The shape of the devices, itself, causes sound to be impolitely reverberated off of the entrance of your ear and back into the headphone; furthermore, some of the sound- if not a lot of it, simply jettisons into the atmosphere.

When buying earbuds, make sure you take into account that the tips are round; therefore, they are able to actually stick inside of your ears. Now, you have about three major options when choosing between earbud tips once you cancel out anything that is flat shaped.

The first option is that you look for rubber tips. Rubber is pretty inexpensive, and it creates an excellent suction in your ear in order to keep your music where it should be- in your ear! You can find many earbuds with rubber tips. Many sports earbuds have some variation or polymer of rubber in their earbud tips in order to give their ears that extra bounce.

Silicone tips tend to block out sound even better than rubber, but you should take great care in selecting what you do with the tips. If you’re not the type of person who takes legitimate care of his or her things, then these are probably not the way to go. Even though silicone does a better job performance-wise for earbuds than rubber earbud tips, rubber has a major advantage: Rubber it simply stronger. It can withstand extremes better.

The main debate is really between Rubber and Foam tips. Foam is excellent because it really match the shape of your ears. Shure actually markets its earbuds with such quality. Shure’s tips are made out of a special type of memory foam that really matches the shape of your ear. Since everyone is different, the earbud tips will really adjust and make a great home. Foam makes it so that external sounds fall into significantly lower disturbance levels than music heard through other materials. Generally, though, foam tips come with expensively expensive buds, so expect to be dishing out some good cash.

If you’re trying to be more conservative, then your best option is to go for the rubber tips. They will last you a very long time when compared to silicone tips. Now, these are not laws of any sort. We understand that in various situations and mixes, any of these three can topple the other two; however, as a general rule of thumb, go with the foams. They create better suction, they last longer, and they really isolate the sound. If you can’t do that, go rubber. Avoid flat shaped earbuds at all costs, though.


iPhone Users Rejoice With Google Voice

Google and Apple are a little like BP and water; they do not mix, at least not well or very willingly. 18 months ago Google submitted Google Voice to Apple's store for use on iPhones; two months after that Apple decided not to accept it, or any third-party apps that used Google Voice functionality.

According to a Techcrunch article, Apple removed Google Voice because it was too similar to the built-in calling system on the iPhone. In a somewhat defensive response it added that it had not rejected the app outright, but was still considering it for approval. And do not we all know how long consideration takes.

Things got a little nasty and the government got involved, but now all is roses and iPhone users can happily download the Google Voice app and use it to their hearts' content, provided they live in the US and have iPhone models with at least iOS 3.1 .

iPhone users will not be denied any of the functionality that other smartphone users enjoy; they'll benefit from cheap international calls, free text messaging to US numbers, voicemail transcription and Google Voice numbers will be displayed on caller ID systems. According to Google's blog, Google Voice features also include push notifications, so that you are aware the instant you receive a new voicemail or text message and calls being placed via Direct Access Numbers, so they connect just as quickly as regular phone calls.

MG Siegler (Techcrunch) warnings those familiar with using Google Voice on other devices that using it on the iPhone is a little different. As a result of the aforementioned tiff, Google Voice will not take over the iPhone's calling capabilities. To use the application you actually have to open it. Once you do so, however, you can make calls directly from Google Voice, send and receive texts and listen to voicemails.

According to many reviewers, the best thing about the Google Voice app is that it is free, but there's more to the app than that. Evan Selleck (Slashgear) is a big fan of the fact that the app runs natively on the iPhone, he also likes that the messages between users and their contacts are threaded, which makes it easy to keep up with conversations. There's also the fact that users can read their history, just in case they need to check up on something. The only real hiccup Selleck found was some redundancy in notifications.

A review of Google Voice on the LA Times blog was less kind. The positive points, according to the LA Times, include simple setup, push notifications for new texts and voicemail and the ability to set up "quick dial" contacts or favorites (with photos). The less positive points include too many glitches (system freezes which require a restart), the tortoise-like pace when it comes to updating the quick dial function, and the erratic nature of the contacts functionality in general (apparently it ended up pairing the wrong face with the wrong name, and despite numerous attempts to create a preferred list order, it kept reverting to the original). There are some issues with keypad functionality, customization options are limited and you can not archive or mark messages as read.

Overall the response has been good and many people are just thrilled to bits that they can finally access the app on their iPhones. International iPhone users will have to wait until 2011 before they can rejoice, but there is more good news on the Apple horizon (if you're a Google lover that is). Google is working on ways to bring Google Voice to the iPad and iPod.

Apple had better watch out; it seems that a total Googlification is imminent.


Getting to Know the Motorola DEFY +

Motorola wowed the world before with the life-proof DEFY, a water-resistant, dust-proof, and scratch-resistant smartphone. Motorola Mobility Inc. is looking to wow the world again by releasing the Motorola DEFY +, an improved version of the DEFY with a better life-proof design so you do not have to worry about what life would be hurling your way. The DEFY + is also water-resistant, dust-proof, and scratch-proof, along running on an Android 2.3 operating system powered by a 25% faster 1GHz processor. This smartphone was announced in August 2011, to be made available in the Latin Americas, Europe, and Asia.

Some of the key features and specifications of the Motorola DEFY + include: an updated operating system with more than 250,000 applications accessible through the Android Market; a powerful 1GHz processor for faster web browsing and amazing multitasking; a water-resistant, dust-proof, and scratch-resistant design (you can submerge this smartphone underwater for up to 10 minutes); a high-resolution 3.7-inch touch screen display; a music play that syncs media from your PC to connect to all your fave artists; MOTOBLUR that features live widgets on the home screen for easy access to social media applications; functions for creating group emails; 2GB internal memory that is expandable up to 32GB using a microSD card (2GB microSD card included in the purchase); access to applications from Google like Google Maps 5.0 plus Navigation as well as Google Talk; and a 1700maH battery that has sufficient juice for 16 days on standby mode or about 7.1 hours of talk time.

Here are also some of the things you can generally expect out of the Motorola DEFY +:

  • Faster than ever – the Motorola DEFY + features a 1GHz processor that is 25% faster than the one the original DEFY had and a browser that is Adobe Flash 10-enabled. This means that you get to enjoy faster services no matter what you are doing, whether you are downloading content or updating your social networking accounts or checking your email, you can do all these things on the web on your nifty 3.7-inch touch screen.
  • Smarter than ever – the newest version of the Android operating system on the Motorola DEFY + has made the smartphone smarter than ever by incorporating improvements that allow for better battery life, more intuitive interfaces, and easy personalization through application trays you can customize and organize.
  • More entertaining than ever – the Motorola DEFY + has your social networking activities and music needs covered so you'll never ever be bored again as you always have easy entertainment on your fingertips. You can even stream music from your desktop with the help of the Motorola Media Link. And for capturing all the special moments of your day, the Motorola DEFY + features a 5MP camera that has a flash, auto-focus functions, and a digital zoom.

To ensure that you have the richest smartphone experience possible, the Motorola DEFY + is compatible with a range of accessories. These compatible accessories include a vehicle dock, a car charger, Bluetooth headset, portable power, and a Bluetooth car kit.


Motorola Charm – Android 2.1 Smartphone

The MB502 Charm with MotoBlur and Android 2.1 is a great gadget for even the busiest corporate type or the teens who is a messaging addict. The full-QWERTY keyboard and 2.8 inch touch screen make this phone the best mobile choice for those who would like faster web navigation and ease in message typing. With great software features, the Motorola Charm is one of the most flexible mobile devices, able to meet not just work demands but also personal needs.

The Motorola Charm MB502 has a 3 megapixel camera that runs in Kodak Perfect Touch technology. It also serves as a video cam, recording 24-frames per second as well as delivers a square compact shape, measuring 67.2 mm in height, 98.4 mm in width and 11.4 mm in depth. At first glance, people may mistake it for a heavy mobile phone especially with its wide face however, with a weight of 110 grams the MB502 is charming, lightweight gadgetry to carry around.

The Charm MB502 is one of the most responsive and well-equipped phones that meet both the user messaging and corporate needs. Featuring an improved MotoBlur, users are given the enhanced option of sending and receiving messages and updates. The MotorBlur allows additional widgets to be displayed on the screen for easy access.

Running in Android 2.1, the MB502 Charm includes messaging options such as Gmail, POP3 and IMAP. It also features Microsoft Exchange, for viewing Microsoft documents, and an Android Webkit browser.

Being Android phone the Motorola Charm MB502 delivers excellent performance especially when getting connected either through Wi-Fi or 3G. The phone is able to load up web-pages faster. The MB502 already has a decent quality of call. The Motorola Charm MB502 uses a 600 MHz processor that makes the phone respond faster. The Charm also runs on a 1.170 mAh lithium ion battery that lasts for more than 13 days.

When it comes to the Android Smartphone, it is a perfect choice for a mobile phone that cannot be beat! It meets both the user’s messaging needs and work needs. With the addition of an improved MotoBlur, it features widgets that are used for easy access on social networking sites and other applications for MotoBlur.

All in all, the Motorola Charm MB502 is user friendly with sleek features that will definitely rock both teens and corporate world. The Charm is priced at $0.00 on 2 years contract and to add more glitz into it there is Free Bluetooth offer available with this handheld device. If your are existing T-Mobile customer and eligible or due for upgrade, then log on to as upgrade phone is very easy and available at a lower price.


What is a GPS Watch, What Does it Do, and How Can it Help Me With My Fitness Program?

GPS watches utilize a network of global positioning satellites to precisely track how far and how fast you are running, biking, or swimming. Anytime. Anywhere in the world. It will measure your real-time speed, average speed and maximum speed. It calculates your pace, average pace and best pace, tracks your workout distance, and also functions as a continuous odometer. Whether you’re buying one for yourself or purchasing a gift for someone else, we’re here to help you understand what you’re buying. We’ll guide you to match the right technology for your intended use or to maximize your training or exercise experience.

What does a GPS watch do and how can it help me with my fitness program?

The first thing that comes to people’s mind is that a GPS watch will tell them the direction they’re heading (i.e. North by Northeast) or street address similar to what a car’s navigation system does. This is not true. Although GPS (Global Positional System) watches use the same principles, it is not nearly as sophisticated. Like your car’s navigation system, it communications with the satellites in orbit around the earth to determine your exact coordinates each second while you move. It then sends this information to the watch to calculate your velocity and distance traveled between each set of coordinates.

So why does this matter to me if I’m a runner, cyclist, rower, skier or walker?

Because now you can get the most critical information about your workout that you could never get previously unless you exercised at a track or some other pre-measured course. Namely, how far did I go and how fast did I get there? A GPS watch will provide you with all this information. Here’s some typical data collected from a runner’s workout:

  • The Average Speed during the run was 7.5 miles per hour.
  • The Maximum Speed achieved was 9.0 miles per hour.
  • The Average Pace during the run was 8 minute miles.
  • The Best Pace achieved was 6.5 minute miles.
  • The Total Distance was 3.5 miles.
  • The Total Time was 28 minutes.

This is great information to know so you can target improvements in your exercise program and monitor how you’re performing toward meeting those goals. And you can go anywhere. You’re not constrained by a specific circuit or measured course. Just run, walk or cycle anywhere you want and the GPS watch will perform the calculations no matter where you go. This technology works anywhere in the world because the GPS system is designed to receive information from up to 12 satellites at any one time that are located on the same side of the earth as you. If you’re serious about getting fit or improving upon your current fitness regime, a GPS Watch is a great training tool to own.

So now that you understand how a GPS Watch works and what it can do, choose the model is right for you. Here are the main options to look for:

Heart Rate Monitoring – Some GPS watches come with Heart Rate Monitors so you can gauge your heart rate in addition to your time, speed and distance. The Timex Global Trainer and the Garmin Forerunner 405 both offer this option. In order to reach your fitness goals, you need to train at the right intensity level. Heart rate is the only accurate measurement of your intensity or exertion level. That’s why using a Heart rate monitor is such a valuable part of your training.

Computer Interface – So now you have all this great information in your watch – what do you do with it? Download it, analyze it, and trend it by uploading it into your computer! The Timex Data Recorder works in conjunction with all Timex GPS Watches and comes with cable and software. This item is purchased separately. The Garmin 405 provides computer download capabilities and software as well and are included with the watch. Having this information available on the computer to use with the manufacturer’s tailored software makes it all the more valuable.

GPS Transmitter – Garmin’s GPS device is integrated right into the watch which makes the watch a little bulkier and less suited for daily use. It does have more features however such as Longitude and Latitude coordinates. Timex’s GPS device is a separate component that is worn on your arm or clipped to your waist. Therefore the watch is much lighter which allows it to be used as an everyday watch. Timex has now released its 3rd generation GPS device which weighs only 2.7 ounces. The previous versions were slightly heavier and required more batteries. Although everyone wants the smaller, lighter GPS unit, there is a trade-off. The smaller the unit, the fewer batteries it takes to operate and you’ll need to replace them more frequently.

Target Speed and Pace Alarms – This feature allows you to individualize your performance. An alarm will notify you when you reach preset upper and lower limits for either speed or pace. Timex offers this with their 100 Lap models.

Target Distance Alerts – You can set the watch to alert you when you have traveled a specific distance or multiples of that distance. For example, when this setting is set to “1 mile” the watch will sound an alert when you have traveled one mile and then again at two, three and four miles, etc.

Speed Smoothing – This feature makes pace and speed values easier to read while using the watch by “smoothing” out any small variations in speed. You might want to enable this feature if you are viewing pace information and the displayed numbers appear too “jumpy.” Smoothing has no effect on the accuracy of the data displayed, nor any effect on the distance accumulated.

Lap Memory Recall – This allows you to record separate data for each lap or distance interval. Suppose you run a 5 mile race and you want individual statistics for each mile as well as for the overall race. You would depress the LAP button at each mile mark to reset the Lap data functions so at the end you can compare the data of each lap. Was your 1st and 2nd laps (miles) good, but you faded on the last three? Perhaps you need to work on your endurance. Are your laps better at the end than in the beginning? Then you might need a better warm-up routine.

Timex offers both 50 lap and 100 lap models while Garmin offers 5000 laps for all its models. If you want to keep a couple of weeks of workout data on the watch, make sure it will support enough laps for your purposes.

Auto Splits – This feature will enable the Chronograph to automatically take splits based on time or distance traveled.

Odometer – The watch keeps track of total distance received by the watch.