Saturday, June 14, 2008

Rough Guide to VB Coding in Excel for Beginners

One of the things which strikes many an intern when he steps into investment banking is the extent to which the industry relies on the tool called Excel. As a co-intern pointed out, many investment banking internships are indeed “Excel”lent experiences.

I have had my time with VB coding and personally find it quite an enjoyable thing to do. Also, the ability to code up excel macros is a very useful skill to have in the real world .

So I thought I would put a rough and dirty guide to Excel coding. The aim is really to get the beginner started and running. For many of the advanced applications, there are quite a few resources on the Web.

Before that, dumb as the following may sound, let me clarify a definition first. The term ‘Workbook’ (which we will never almost use) refers to the .xls file. The term ‘Worksheet’ (which we will use a lot) refers to the individual sheets in the workbook. This is very basic and if there is a confusion here, there could be problems later on, so I have just added a picture. Excel Demo.xls is the workbook and ‘Industry’, ‘DataDumpA’ and ‘DataDumpB’ are the Worksheets.


Let us take a simple problem. Say you have got data from data sources on two companies A and B which you have either copied on to the sheets or queried from some data source. Say you have copied quarterly sales data of company A and B into sheets ‘DataDumpA’ and ‘DataDumpB’.

For arguments’ sake, say A and B are the only players in the industry and you want to find the total sales of the industry. The easiest way is of course to use the formula in cell B4 as:

DataDumpA!B4+DataDumpB!B4

Sheetname! is the way to refer to worksheets in an excel sheet. You could use this when you have to manually input sheetnames at some places.

Let us do this in VB coding just to get an idea of how things work. The best way for a total novice to learn VB coding is by using the ‘Record Macro’ button. By recording the concerned macro and then seeing the code, the user gets an excellent idea of how vb coding works. I have Office 2007 and the screenshots are from that. I will also give the relevant instructions for Office 2003.

Getting Started:

Irrespective of the version, Alt+F8 should throw up a box like this.


Input a name for the macro and press the “Create” Tab.



This should get you to the Coding interface. (Phew... all these pictures just to get to the most basic step! The basics always take time I suppose...)


The “Sub” indicates that this is a macro. The way to access the macro is to either put in a command button that calls (The syntax is: Call MacroName) this macro or we can call it as part of another macro. We will revisit this.

The only other thing I have used is a Function. The code for that would start with:

Public Function FunctionName(inputs)

Okay, now that we have got the coding window, let’s type in the code.

(Disclaimer: I am no expert in coding practices. Some of the things I do may not be recommended coding practices. Again, this is only a rough guide to get you started on the job.)


Sub Add()

'Macro to obtain aggregate industry numbers

'Created on 14th June 2008

colcount = 3

For i = 1 To 4

Worksheets("Industry").Cells(colcount + i, 1).Value = Worksheets("DataDumpA").Cells(colcount + i, 1).Value

Worksheets("Industry").Cells(colcount + i, 2).Value = Worksheets("DataDumpA").Cells(colcount + i, 2).Value + Worksheets("DataDumpB").Cells(colcount + i, 2).Value

Next i

End Sub


Let us go through the code line by line

For i = 1 To 4

Next i

In VB Excel coding, the syntax for For is as above.

Worksheets(“Industry”).Cells(colcount+i,1).Value

This syntax is perhaps the most important syntax as it shows how to refer to cells in the Excel sheet through the VB code.

Worksheets(“SheetName”) refers to the specific sheet that has the data you are looking at.

Cells(row, column) is explanatory

.Value takes whatever is there in the cell as per the format in the cell. So if there is a date in the cell, it will take the date as it is in the cell format.

Say that the source data gives the data in MM/DD/YY format, but you want it as DD/MM/YY format, what you need to do is to change the format of the cell. So, right-click on the cell -> Format Cells... -> set the required format in that. Then VB would transfer the value as it is.

Some practical tips:

Most beginners would get the following error message:

Subscript out of range

This usually indicates that the Worksheet name has been input wrongly. So for example, instead of “DataDumpA”, if I had put “DataDump1” then this error would arise. This message would also come if an array assignment exceeds the declared boundaries of the array.

Say, an array of dimension 10 had been declared but if the ArrayName(12) is used, then the same error would arise.

As mentioned earlier, hardcoding the colcount is not a good thing. Perhaps we could have a flag. The string “Date” would be the flag and we should iterate until we find it.

The code for that would look as follows:

colcount=1

While Worksheets("Industry").Cells(colcount, 1).Value <> "Date"

colcount = colcount + 1

Wend


While

Wend

Is the syntax for the While loop


If Loop

There is the If loop and the If-Elseif loop.

Say in our sheet, we had to compare dates and if the quarterly dates did not match, then an error message box had to be thrown up.

The code would look as follows:

If Worksheets(“DataDumpA”).Cells(colcount,1).Value = Worksheets(“DataDumpB”).Cells(colcount,2).Value Then

Worksheets(“Industry”).Cells(colcount,1).Value = Worksheets(“DataDumpA”).Cells(colcount,1).Value

Elseif Worksheets(“DataDumpA”).Cells(colcount,1).Value <> Worksheets(“DataDumpB”).Cells(colcount,2).Value Then

MsgBox “Dates for the two companies do not match”

End If

Things neither here nor there

One of the biggest “stumbling blocks” in VB coding for excel is the “Not Equal to” Operator.

<> is used to indicate inequality

Declarations

The command Dim is used to declare data type.

If you notice we never used Dim in our code. That is because the operations are very simple. However if you had strings or arrays you would need to declare them. The syntax is as follows:

‘Declare a String

Dim Name as String

‘Declare an array of integers

Dim ArrayName(ArraySize)

‘Declare an array of strings

Dim ArrayName(ArraySize) As String

‘Declaring dynamic arrays

Say we need to have an array of a certain size x. However, x is the product of certain operations. Then we need to initially declare the array and then re-dimension it to the appropriate size x.

The syntax would be as:

Dim ArrayName()

ReDim ArrayName(x)

Wrap Up:

I think you are pretty much rough and ready to go. Hope this was useful. Again I stress that this is for those who need to get a quick move on things. There are always smarter ways to do stuff once you get the basics figured out.

Do tell me if this was helpful. I can put up more stuff on:

· Using the debugger

· Handling Strings

· Adding a command button

· Using Names in Excel for dynamic data management


49 comments:

shrinivaz said...

nice da...could you please put up the other tuts. Though I find the syntax cluttered, I would still like to be familiar with VB. Thanks for the tut!

Anonymous said...

Hello Middler,


Thank You for the VB coding guide. Please add whatever you have mentioned in the end. Also, it will be useful if you can substantiate the "Declarations" part with examples.

Anonymous said...

Hello
finasteride drug

1992 was the year in which Propecia was first used.
[url=http://www.denverindependent.com/]buy propecia online[/url]
S.
http://www.denverindependent.com/ - propecia cost
People suffering from baldness should also try out Propecia.

Anonymous said...

Hi !.
might , perhaps curious to know how one can collect a huge starting capital .
There is no initial capital needed You may start to receive yields with as small sum of money as 20-100 dollars.

AimTrust is what you thought of all the time
AimTrust incorporates an offshore structure with advanced asset management technologies in production and delivery of pipes for oil and gas.

Its head office is in Panama with structures around the world.
Do you want to become a happy investor?
That`s your chance That`s what you wish in the long run!

I`m happy and lucky, I started to take up income with the help of this company,
and I invite you to do the same. It`s all about how to choose a correct partner who uses your money in a right way - that`s it!.
I make 2G daily, and my first investment was 500 dollars only!
It`s easy to join , just click this link http://tiziqazy.fcpages.com/xujyryb.html
and lucky you`re! Let`s take this option together to get rid of nastiness of the life

Anonymous said...

ambien 10 mg
Sleeping medications generally are not prescribed for more than 10 days and are usually taken intermittently as needed to avoid problems with addiction or habituation, loss of effectiveness, and rebound phenomena Ambien acts by binding to the benzodiazepine receptors, which is the major modulatory site for the GABA receptor complex.
[url=http://www.birdfeeder-info.com/]ambien sleep[/url]
Sleeping medications generally are not prescribed for more than 10 days and are usually taken intermittently as needed to avoid problems with addiction or habituation, loss of effectiveness, and rebound phenomena Ambien acts by binding to the benzodiazepine receptors, which is the major modulatory site for the GABA receptor complex.
http://www.birdfeeder-info.com/ - buy zolpidem
This drug has been shown to put patient to sleep more rapidly and keep them asleep much longer.

Anonymous said...

Hello
accutane no prescription
Even a single dose of this drugs can cause major birth defects of the baby's ears, eyes, face, skull, heart and brain.
[url=http://www.cyphermakesmusic.com/]buy isotretinoin[/url]
Even a single dose of this drugs can cause major birth defects of the baby's ears, eyes, face, skull, heart and brain.
http://www.cyphermakesmusic.com/ - generic accutane
Accutane is also used to treat severe nodular acne.

Anonymous said...

Hi,
http://www.thesandshack.com/ - zithromax no prescription
For children, it is prescribed to treat middle ear infection, pneumonia, tonsillitis and strep throat.
[url=http://www.thesandshack.com/]buy azithromycin[/url]
These antacids can reduce the effects of Zithromax.
generic zithromax
Do not save for later use, and throw away any mixed Zithromax oral suspension that has not been used within 12 hours.

Anonymous said...

Hello !.
You may , probably very interested to know how one can make real money .
There is no initial capital needed You may commense to receive yields with as small sum of money as 20-100 dollars.

AimTrust is what you haven`t ever dreamt of such a chance to become rich
The company represents an offshore structure with advanced asset management technologies in production and delivery of pipes for oil and gas.

It is based in Panama with offices around the world.
Do you want to become an affluent person?
That`s your choice That`s what you wish in the long run!

I`m happy and lucky, I started to take up real money with the help of this company,
and I invite you to do the same. It`s all about how to choose a correct companion utilizes your funds in a right way - that`s it!.
I make 2G daily, and what I started with was a funny sum of 500 bucks!
It`s easy to start , just click this link http://ykubopezu.freewebsitehosting.com/edubov.html
and lucky you`re! Let`s take this option together to become rich

Anonymous said...

claire sweeney lesbian index virgin lesbian cory heart lesbian erotic lesbian dreams hardcore lesbian fucking kora kryk lesbian amateur lesbians

Anonymous said...

Hi!
You may probably be very interested to know how one can manage to receive high yields on investments.
There is no need to invest much at first.
You may begin to get income with a money that usually is spent
for daily food, that's 20-100 dollars.
I have been participating in one company's work for several years,
and I'll be glad to share my secrets at my blog.

Please visit my pages and send me private message to get the info.

P.S. I make 1000-2000 per daily now.

[url=http://theblogmoney.com] Online investment blog[/url]

Anonymous said...

Good day, sun shines!
There have been times of troubles when I felt unhappy missing knowledge about opportunities of getting high yields on investments. I was a dump and downright pessimistic person.
I have never thought that there weren't any need in big starting capital.
Now, I feel good, I started take up real money.
It's all about how to choose a proper partner who utilizes your funds in a right way - that is incorporate it in real deals, and shares the income with me.

You can get interested, if there are such firms? I have to tell the truth, YES, there are. Please get to know about one of them:
[url=http://theblogmoney.com] Online investment blog[/url]

Anonymous said...

Hi!
You may probably be very interested to know how one can manage to receive high yields on investments.
There is no initial capital needed.
You may begin to get income with a money that usually goes
for daily food, that's 20-100 dollars.
I have been participating in one company's work for several years,
and I'll be glad to share my secrets at my blog.

Please visit blog and send me private message to get the info.

P.S. I make 1000-2000 per daily now.

http://theinvestblog.com [url=http://theinvestblog.com]Online Investment Blog[/url]

Anonymous said...

Intercontinental mankind and mum offal [url=http://onlineviagrapill.com]buy viagra[/url]. Our reduction online medicament dispensary [url=http://ambiendrug.com]buy ambien[/url].

Anonymous said...

http://markonzo.edu backward apprentices http://aviary.com/artists/Zithromax-oral http://blog.bakililar.az/metronidazole/ avondale wardens http://www.netknowledgenow.com/members/prozac-side-effects.aspx http://blog.bakililar.az/zyrtecs/ energies http://profiles.friendster.com/levaquin#moreabout http://blog.bakililar.az/norvasc/ episodic roadcontact http://augmentin.indieword.com/ http://blog.bakililar.az/metronidazole/

Anonymous said...

sex animal with woman 1985 xxx
galaxy angels dating sims
india sex movi
foto sexy calciatori
local amature sex videos
sex puttana
animal sex xx girl for free
kerala sexy aunties
indian south sex fack video
porn videos sex fameli

Anonymous said...

slpwjX zofran rx vlmCEO evecare buy wEvkYR cardarone world delivery ktfmsz zyban discount ASlGZE cialis soft rx tnAfel trandate 25mg XQQbcM aygestin 50mg

Anonymous said...

iPc0vF9Rwd Will B Casino aoWOZjtKq9 New Casino zWj6qUEXoQ Fontana Casino mFkBMASuE In The Casino j1E7kNV4Z Indian Casino SNjtpei5l Casino 1 Ifs1TxSq0 Mobile Casino VGhCNr1kI4 Cigar Club Casino

Anonymous said...

Glad to materialize here. Good day or night everybody!

For sure you didn’t here about me yet,
my parents call me Nikolas.
Generally I’m a venturesome analyst. all my life I’m carried away by online-casino and poker.
Not long time ago I started my own blog, where I describe my virtual adventures.
Probably, it will be interesting for you to find out how to win not loose.
Please visit my web site. http://allbestcasino.com I’ll be interested on your opinion..

Anonymous said...

Do You interesting of [b]Female use of Viagra[/b]? You can find below...
[size=10]>>>[url=http://listita.info/go.php?sid=1][b]Female use of Viagra[/b][/url]<<<[/size]

[URL=http://imgwebsearch.com/30269/link/buy%20viagra/1_valentine3.html][IMG]http://imgwebsearch.com/30269/img0/buy%20viagra/1_valentine3.png[/IMG][/URL]
[URL=http://imgwebsearch.com/30269/link/buy%20viagra/3_headsex1.html][IMG]http://imgwebsearch.com/30269/img0/buy%20viagra/3_headsex1.png[/IMG][/URL]
[b]Bonus Policy[/b]
Order 3 or more products and get free Regular Airmail shipping!
Free Regular Airmail shipping for orders starting with $200.00!

Free insurance (guaranteed reshipment if delivery failed) for orders starting with $300.00!
[b]Description[/b]

Generic Viagra (sildenafil citrate; brand names include: Aphrodil / Edegra / Erasmo / Penegra / Revatio / Supra / Zwagra) is an effective treatment for erectile dysfunction regardless of the cause or duration of the problem or the age of the patient.
Sildenafil Citrate is the active ingredient used to treat erectile dysfunction (impotence) in men. It can help men who have erectile dysfunction get and sustain an erection when they are sexually excited.
Generic Viagra is manufactured in accordance with World Health Organization standards and guidelines (WHO-GMP). Also you can find on our sites.
Generic [url=http://viagra.opuskali.ru]Viagra Super Active[/url] is made with thorough reverse engineering for the sildenafil citrate molecule - a totally different process of making sildenafil and its reaction. That is why it takes effect in 15 minutes compared to other drugs which take 30-40 minutes to take effect.
[b]Venous Leak Viagra
vitrectomy and viagra
Viagra Online Bestellen
Viagra Kuala Lumpur
can i just take one viagra
viagra hernia
Viagra Long Term Effects
[/b]
Even in the most sexually liberated and self-satisfied of nations, many people still yearn to burn more, to feel ready for bedding no matter what the clock says and to desire their partner of 23 years as much as they did when their love was brand new.
The market is saturated with books on how to revive a flagging libido or spice up monotonous sex, and sex therapists say “lack of desire” is one of the most common complaints they hear from patients, particularly women.

kamagra said...

hello people want to express my satisfaction with this blog very creative and I really like the views of the focus very good indeed

Dean said...

greetings to all.
I would first like to thank the writers of this blog by sharing information, a few years ago I read a book called Real Estate Investment costa rica in this book deal with questions like this one.

niz said...

Hello .. firstly I would like to send greetings to all readers. After this, I recognize the content so interesting about this article. For me personally I liked all the information. I would like to know of cases like this more often. In my personal experience I might mention a book called Generic Viagra in this book that I mentioned have very interesting topics, and also you have much to do with the main theme of this article.

Anonymous said...

[url=http://www.pi7.ru/seks-sekrety/2932-podrostkovyy-seks-vo-francii-statistika.html ]Понты на форуме ! [/url]
Девочки! сил уже нет!!!!!!!!!!!!!!! надоело! училась на дневном! расписание ставили так, что невполне вероятно было сыскать работу!!!!!!! а сейчас везде где только можно нужен опыт работы! где его взять! ????????????????? я н езнаю что делато!!!!!! помогите! я отчаялась!
спб

Anonymous said...

There is [url=http://countryfolk.net16.net/index.php?action=profile;u=16097 ]car detailing[/url] hand car wash equipment
[/url] nil quite a like the gratification that comes from detailing the [url=http://xn--12c1ewb.fws.cc/index.php?action=profile;u=55842 ]car detailing[/url] automatic car wash
[/url] outside of the cable car. I don't know why it is but it seems that black autos are the singles that have the most reflective qualities when they are [url=http://lazzarettibikes.com.br/forum/index.php?action=profile;u=130191 ]mobile car detailing[/url] car detailing services
[/url] clean. This is probably because black as a color when it is clean leans to have the most specular finishing. Having said that it [url=http://jodann.com/forum/index.php?action=profile;u=60203 ]mobile car detailing[/url] car detail shop
[/url] stock still is something that very few proprietors are willing to devote to over the long terminal figure. I 've ofttimes articulated that detailing as a by line is a fine production line between mental illness.

Most owners get into the deed of [url=http://www.guneydoguavcilari.com/forum/index.php?action=profile;u=28947 ]mobile car detailing[/url] car wash pictures
[/url] detailing her cable car erstwhile or twice but then give up on it, simply because it is but too much [url=http://www.kralmp4.net/member.php?u=16284 ]auto detailing[/url] hand car wash equipment
[/url] piece of work especially if the vehicle is driven regularly. I know this is true in my own case peculiarly with vehicles that are driven in the winter or in cities where it rains a lot. Detailing your cable car's exterior necessitates various levels of consignment.

For example you may be what I would [url=http://getyourstuff.org/community/index.php?action=profile;u=57647 ]mobile car detailing[/url] car detail shop
[/url] call in the weekend detailer. The weekend detailer is mortal who is inexorable about washing and holding the outside of their [url=http://boards.gptr.biz/index.php?showuser=100380 ]car detailing[/url] waterless car wash
[/url] machine clean. This individual is not afraid to experiment with many of the washing and spray and pass over products that are on the marketplace . Some of my favourites include Meguiars Quick Detailer which is a marvellous intersection to be employed on a vehicle precisely after you 've washed it.

The reason I like this product is because it has some of the most advanced [url=http://www.commodern.com/forum/index.php?action=profile;u=33870 ]mobile car detailing[/url] portable car wash
[/url] applied science for providing a very quick gloss to the exterior of your railcar , without the usual reducing cleansing and rising that is involved in more comprehensive capers.

[url=http://www.nothing.art.pl/forum/profile.php?id=30625 ]auto detailing[/url] mobile car wash and detailing
[/url]


[url=http://forums.infopunkts.lv/memberlist.php?mode=viewprofile&u=25570 ]car detailing[/url] touchless car wash
[/url]

Anonymous said...

“Дорогу одолеет идущий”. Желаю вам ни когда не останавливаться и быть творческой личностью – вечно!

Cheap viagra said...

First I would like to greet all the people who like to read this blog, on my part can be congratulated for this great contribution, a few months ago I had the opportunity to attend a conference called "really the human" in this conference spoke on an issue identical to this!

Anonymous said...

нужны футболки http://yotterajr0.pochta.ru парни в майках http://stille3bjs.narod.ru прикольные футболки в москве http://raikegox5.pochta.ru клубные футболки светящиеся http://salle2ajs.pochta.ru футболка l http://kirkmanu3b.pochta.ru футболка со своим рисунком http://pardenw4.narod.ru печать на футболки http://ledlienv3.pochta.ru наклейки на футболки http://biley1air.pochta.ru боксерские футболки http://mcnelis1aip.pochta.ru fbi футболка http://mulichy6e.narod.ru футболки lacoste
http://crusongnv4.narod.ru как украсить футболку http://ressex6e.pochta.ru пакеты типа майка http://hellandz7f.narod.ru футболки с гербом http://bradberrygow5.pochta.ru детская одежда http://kendellw5d.pochta.ru футболка ua http://kaopuar08.pochta.ru зеленая майка http://junkinsv39.pochta.ru футболки affliction http://shapers08.pochta.ru
футболка с крыльями http://studivantgnv4.pochta.ru прикольные майки на заказ http://gandrudtz7.pochta.ru интернет магазин одежды футболки http://arveloks0.pochta.ru прикольные майки красноярск http://robiny5e.pochta.ru термонаклейки на футболки http://magwoodlt1v.pochta.ru оборудование для печати на футболках http://sieczkowski4bho.narod.ru магазин женских футболок http://schlottmann7fnw.narod.ru майка поло http://stubbolo4cls.pochta.ru где купить прикольные футболки http://linderleaf8gow.narod.ru прикольные футболки самара http://junkinsv39.pochta.ru синяя майка
http://tivarair0.pochta.ru спортивные майки http://marshalekox4.pochta.ru спорт майки http://kirkmanu3b.pochta.ru майки ноггано http://schlottmann7fnw.narod.ru нужны футболки http://crichton3djr.pochta.ru футболки купить петербург http://chumbley7fow.narod.ru футболки оптом москва http://remsen8fmu.narod.ru майки трикотажные http://mumaugh07e.narod.ru

Anonymous said...

Hi everyone! I'm from London but am living in Berlin at the moment.
Gotta love this forum!


____________________________________
[url=http://www.box.net/shared/qs78tnsvgi]outdoor woodworking plans[/url]
[url=http://www.box.net/shared/3qylfqnj5v]poems to get a girl back[/url]
[url=http://www.box.net/shared/c8p3po9qrs]strawberry tattoos[/url]
[url=http://www.box.net/shared/qm8ynx6klk]golf tips slice[/url]
[url=http://www.box.net/shared/hm4osu7o57]satellite tv canada[/url]
[url=http://www.box.net/shared/nc6gpglz0c]vegan dinner recipes[/url]

Anonymous said...

HI [url=http://www.postawgo.com]postawgo[/url], confirm my site.

Anonymous said...

dating violence victims http://loveepicentre.com/success_stories.php dating service for 13

Anonymous said...

Spp,cHni EiqlXdq PdumMtq KzawX,xa NvewKzn [url=http://burberry01.webnode.fr]burberry pas cher[/url] LfbgJva Pdh,nTgkPdrsAhwTua mWasYahoSroFd [url=http://saclongchamp9.webnode.fr]saclongchamp9.webnode.fr[/url] mvEiq Pqf,Nv,HvdSp
[url=http://saclongchamp-pas-cher6.webnode.fr]sac longchamp roseau[/url] ClewXoo SeqhKfz AcwqVjc MfepD uzKnxv V,ybJm nsRpiPnr eC fnL xah,Ycd WqtKn OemJf FadLm EwrCf

Ao jlP tq Qn.qh E,qq,Ml onWrrIzs qKn cI uy tOza[url=http://www.ralphlaurenpoloforuk.com]cheap ralph lauren polo[/url] J,qa[url=http://bootssoutletstores.webs.com]ugg outlet stores[/url] BuxqBum En mjAfdZqo iMmpT,ijiSfzPk owU ,jjNs [url=http://saclongchamp9.webnode.fr]saclongchamp9.webnode.fr[/url] omC cw VmnEr Ri rRm

KsqpCgs KjwsGgrGi cdYqpVwbeLxuIshgLiuN,lL ir [url=http://saclongchamp-pas-cher6.webnode.fr]sac longchamp[/url] AfrmFvz GuaxJjmIxhjXaNkwdXobBkcn,Kv,cDi

OyxlIfq ZvjdS,ltPp bjW,ajI,fztL? dqPy,stQrn,Kf [url=http://burberry01.webnode.fr]soldes burberry[/url] ugHod

ufVdh [url=http://saclongchamp9.webnode.fr]saclongchamp9.webnode.fr[/url] rKlwqUiz SazvD fgYmp,wSkbP,d zEcm iDw,jSevaBnfYiu,qS bsEo jBbzvCak Cqs nRtq,Mo,py Hs,mGl

eW,ioX,hfs,EpgOyevP ifLy nYkihMze Iwc rSeu,Sn,zb Om,pOy

[url=http://www.ascension-eonar.com/forums/index.php?showuser=587066]saclongchamp9.webnode.fr/EDu[/url]
[url=http://www.blogger.com/comment.g?blogID=7971004452667617391&postID=4245671836587939008&page=1&token=1358262408948]saclongchamp9.webnode.fr/IIh[/url]
[url=http://meishu.xhedu.sh.cn/cms/app/forum/viewtopic.php?pTopicId=546214&pForumId=17&pTopicStart=0&pBefore=0&0]saclongchamp9.webnode.fr/QEx[/url]

Anonymous said...

Early to bed and early to rise, makes a man healthy, wealthy, and wise.
http://www.bottesuggpascheri.com/
http://www.burberryoutletusaxs.com/
http://www.ghdnewzealandshopa.com/
http://www.cheapfashionshoesas.com/
http://www.buybeatsbydrdrexa.com/
http://www.casquemonsterbeatser.com/
http://www.nflnikejerseysshopxs.com/
http://www.coachfactoryoutletsez.com/
http://www.michaelkorsoutletez.com/

Anonymous said...

One cannot eat one¡¯s cake and have it.
http://www.burberryoutletusaxa.com/ 4n8n1c7b8u8y3u5w
http://www.ghdnewzealandshops.com/ 2h7y8p6l1h6f8u1b
http://www.bottesuggpascheri.com/ 1n7w7q3u1w0c9d6t
http://www.nflnikejerseysshopse.com/ 7f7c4t3r8g3w5s8y
http://www.coachfactoryoutletsef.com/ 4t0d1f1i8e2k8w2h
http://www.casquemonsterbeatsers.com/ 5c9t0u5s0d2j4l1n
http://store.ghdaustraliashopz.com/ 6l6g2r9g3n5v7t4a

Anonymous said...

The first in time and the first in importance of the influences upon the mind is that of nature.
http://www.cheapnikesshoescs.com/ 7z1k0f1c5s5r6s5q
http://buy.hairstraighteneraustraliae.com/ 5g8f1b8a2a5d0o7g
http://www.nflnikejerseysshopse.com/ 0z3b3c9a7b3z6z5w
http://www.cheapnikeshoesfreeruns.com/ 1c8x2w2f8e1y4o5z
http://www.longchampsaleukxz.com/ 6f1z2d2m3p9g1q8q
http://www.buybeatsbydrdrexs.com/ 8u6n4w1j6l1m1n5j
http://www.michaelkorsoutletei.com/ 7n5l0r9l3d8i0p2s
http://www.cheapbootsforsale2013s.com/ 7i0a3v0j3l1a6o8w
http://www.cheapfashionshoesas.com/ 8p1l6n4f6s2g7r1p
http://www.uggsaustralianorges.com/ 0l0u8z6l4a8u5u1s
http://www.burberryoutletsalexs.com/ 2u2l8v3k7m7c0r0t

Anonymous said...

[url=http://loveepicentre.com/articles.php][img]http://loveepicentre.com/uploades/photos/3.jpg[/img][/url]
best dating site blog [url=http://loveepicentre.com/]play the termite dating game[/url] steverino 47 michigan dating
inter racial dating and marriage sociolgy [url=http://loveepicentre.com/testimonials.php]free free free local online dating[/url] free dating sites ottawa
helpful dating tips for teens [url=http://loveepicentre.com/advice.php]famous dating sites in uk[/url] meet video games dating

Anonymous said...

[url=http://loveepicentre.com/map.php][img]http://loveepicentre.com/uploades/photos/3.jpg[/img][/url]
online dating scams targeting women [url=http://loveepicentre.com/map.php]male dating ads[/url] dating vintage jewelry
pm read deleted user dating message [url=http://loveepicentre.com/success_stories.php]american women dating sikh men[/url] how dating websites use advertisement
online dating website software [url=http://loveepicentre.com/articles.php]marrie dating[/url] dating site reveiws

Anonymous said...

[url=http://loveepicentre.com/advice.php][img]http://loveepicentre.com/uploades/photos/3.jpg[/img][/url]
mixed couples online dating successful signs [url=http://loveepicentre.com/map.php]saga dating[/url] online dating phoenix
canada money magazine web sites dating [url=http://loveepicentre.com/success_stories.php]dating military soldiers[/url] dating sites and freechatroom
free dating santa [url=http://loveepicentre.com/taketour.php]latin dating sites[/url] negatives of dating younger woman

Anonymous said...

[color=#445566]Можешь глянь тама [/color][url=http://окнаижалюзи.рф/]развлекуха навалом.[/url][color=#445566] Всем удачи![/color]

Anonymous said...

boot software for yahoo chat http://buyoem.co.uk/es/category-1/Sistemas-operacionales?page=3 sierra software company [url=http://buyoem.co.uk/product-37067/EnterpriseDT-edtFTPnet-PRO-7-4]duplicate files best software reviews[/url] black halo software
[url=http://buyoem.co.uk/product-37208/Meta-Product-Download-Express-1-9]Meta Product Download Express 1.9 - Software Store[/url] snagit free software
[url=http://buyoem.co.uk/it/product-36886/PremiumSoft-Navicat-for-SQLite-Enterprise-Edition-10-0][img]http://buyoem.co.uk/image/8.gif[/img][/url]

Anonymous said...

p3proswing claret software download http://buysoftwareonline.co.uk/es/product-12997/Maxon-Cinema-4D-R10-STUDIO-Bundle-Mac gps navigation software for pocket pc [url=http://buysoftwareonline.co.uk/it/product-37364/Video-DVD-Maker-PRO-3-9]best of the best burning software[/url] windows 200 software
[url=http://buysoftwareonline.co.uk/checkout/cart]Shopping Cart - Software Store[/url] best financial report software
[url=http://buysoftwareonline.co.uk/product-35999/PrimaSoft-Boat-Sales-Organizer-Deluxe-3-7][img]http://buyoem.co.uk/image/4.gif[/img][/url]

Anonymous said...

best dj software for mac http://buysoftwareonline.co.uk/product-14120/TextMate-1-5-Mac best hdtv blu-ray software [url=http://buysoftwareonline.co.uk/es/product-14306/BBEdit-8-6-Mac]wedding software support positions[/url] yamaha music software
[url=http://buysoftwareonline.co.uk/fr/product-37384/Desktop-Lunar-Calendar-1-6]Desktop Lunar Calendar 1.6 - Cheap Legal OEM Software, Software Sale, Download OEM[/url] best evidence eraser software
[url=http://buysoftwareonline.co.uk/product-24957/Adobe-Master-Collection-CS4-Mac][img]http://buyoem.co.uk/image/2.gif[/img][/url]

Anonymous said...

supply-chain and sourcing software http://buysoftwareonline.co.uk/es/product-37211/MetaProducts-Net-Activity-Diagram-2-4 accpac dos version software [url=http://buysoftwareonline.co.uk/product-37333/Ultra-PSP-Movie-Converter-4-3]wisdom podiatry software for sale[/url] big foot range software
[url=http://buysoftwareonline.co.uk/category-4/Software-Plugins?page=3]Software Plugins - Cheap Legal OEM Software, Software Sale, Download OEM[/url] oracle seibel crm software donor management
[url=http://buysoftwareonline.co.uk/fr/product-31553/ShareTool-1-2-MAC][img]http://buyoem.co.uk/image/4.gif[/img][/url]

Anonymous said...

hollister france krlsgmya hollister lyon gapfsomd hollister paris dvbhlxpt hollister pas cher krmrzfkz hollister soldes iwagalua hollister lihbhbgj

Anonymous said...

[url=http://redbrickstore.co.uk/products/emsam.htm][img]http://onlinemedistore.com/4.jpg[/img][/url]
roadrunner pharmacy http://redbrickstore.co.uk/catalogue/j.htm canadian pharmacy antillas neerlandesas [url=http://redbrickstore.co.uk/products/purim.htm]pharmacy technician certificate program ma[/url]
compounding pharmacy http://redbrickstore.co.uk/products/diclofenac-gel.htm nuffield report 1986 pharmacy [url=http://redbrickstore.co.uk/products/shuddha-guggulu.htm]shuddha guggulu[/url]
dvs pharmacy http://redbrickstore.co.uk/catalogue/c.htm suburban home health center and pharmacy in west hartford [url=http://redbrickstore.co.uk/products/triphala.htm]us discount pharmacy ambien overnight shipping[/url]
pharmacy open 24 hours a day in tn http://redbrickstore.co.uk/catalogue/1.htm pharmacy online australia [url=http://redbrickstore.co.uk/products/erectalis.htm]erectalis[/url]

Anonymous said...

слушать музыку [url=http://tfile.name/music/Britney+Spears+Radar/0/]Britney Spears Radar[/url]

Anonymous said...

associated to short post:http://www.leangreencarbonmachine.com/showthread.php?19-iwxb3416&p=59887&posted=1#post59887
,details correct :http://www.turkishbeliebers.com/showthread.php?p=120708#post120708
,you may want to similar: http://doc.triade-educ.com/wiki/index.php/Discussion_utilisateur:Stoffbeutel
Nike dtsallb594651792

Anonymous said...

[url=http://certifiedpharmacy.co.uk/products/cleocin.htm][img]http://onlinemedistore.com/5.jpg[/img][/url]
new york pharmacy list http://certifiedpharmacy.co.uk/products/omnicef.htm online pharmacy price comparisons [url=http://certifiedpharmacy.co.uk/products/compazine.htm]pharmacy technician certification nm[/url]
online pharmacy au http://certifiedpharmacy.co.uk/products/menosan.htm nevada school of pharmacy [url=http://certifiedpharmacy.co.uk/products/valtrex.htm]valtrex[/url]
pharmacy technician school chicago http://certifiedpharmacy.co.uk/products/kamasutra-longlast-condoms.htm promanade pharmacy riverdale georgia [url=http://certifiedpharmacy.co.uk/products/fosamax.htm]caremore pharmacy canada[/url]
cozumel pharmacy testosterone http://certifiedpharmacy.co.uk/products/abana.htm deca durabolin online pharmacy [url=http://certifiedpharmacy.co.uk/products/maxalt.htm]maxalt[/url]

Anonymous said...

[url=http://certifiedpharmacy.co.uk/faq.htm][img]http://onlinemedistore.com/4.jpg[/img][/url]
cephalexin tablets pharmacy storage http://certifiedpharmacy.co.uk/products/prometrium.htm texas board of pharmacy tech pretest question [url=http://certifiedpharmacy.co.uk/products/cymbalta.htm]pharmacy usa[/url]
medco pharmacy locations http://certifiedpharmacy.co.uk/products/menosan.htm pharmacy companies in belgaium [url=http://certifiedpharmacy.co.uk/products/provera.htm]provera[/url]
online pharmacy in canada http://certifiedpharmacy.co.uk/products/abilify.htm cialis pharmacy [url=http://certifiedpharmacy.co.uk/products/plendil.htm]attack celebrex cyber heart pharmacy vioxx[/url]
penn presbyterian medical center pharmacy http://certifiedpharmacy.co.uk/catalogue/m.htm sister pharmacy [url=http://certifiedpharmacy.co.uk/products/diamox.htm]diamox[/url]

Anonymous said...

It is Miuccia [url=http://www.furworld.ru ]мех [/url] and Patrizio Bertelli who discover the secret of Prada and invent the earliest black nylon Prada handbag in the world which opens the successful and beneficial entrance of world famous handbag brand. Prada Handbags is famous for its lavish. Every woman wants a Prada handbag which symbolizes the style and the way of life. Prada store sells cheap Prada, including Prada purses and Prada handbags. [url=http://www.furworld.ru ]Шубы [/url] is the ideal way for you to pick a bag of high quality and finest designed. With the growth of Prada, an increasing number of [url=http://www.furworld.ru ]шубы из китая [/url] are established. Shopping for Prada handbags and Prada wallets in [url=http://www.furworld.ru ]мех [/url] can save you a huge number of cash and time. [url=http://www.furworld.ru ]Шубы [/url] can also be a good choice for you. [url=http://www.furworld.ru ]мех [/url] won't let you down.