A bit about

Hello, everyone! All you can see below is just my bank of information. Some material I've found in the fathomless net, some I've learned myself. Don't think all of the information here is right or actual, but may be it could be of use for you :) All feedback is welcome, especially constructive ones :)

Monday, March 31, 2008

My move to a new e-mail

It seems so simple - to register a new address and to tell it to your friends. But don't forget that in some point of view, your mailbox is something like your home when using the Web. Especially, on such services as Google or Yandex, where you have a lot of features, assigned to your mail account.
First of all, I’ve tried to find function like “Rename my mailbox”. I thought that if I can change, for example, my username in Windows or Linux, why can’t I just rename my mailbox? I was so naive! )) May be I missed something, but I haven’t found any information in Google’s help or among my friends how to do this simple step.
So, the only way for me was creating a new account and copying all information from the old one. And it took for me equally two hours. Special Thank for my ISP for stable connect during this hard time )) Below are the common steps, which I have done.

The first evident step – register a new account
There was no problem, my target mailbox’s name wasn’t occupied by anyone. By the way, it’s very convenient to work in two different browsers – the new account in Firefox and the old one in IE.

2. Forget about previous account – use forwarding
For my Google accounts, I saw the 2 ways – make the old mailbox forward all incoming mail to the new one; or allow POP and IMAP access for the old mailbox and make the new mailbox check out updates from there. I preferred the second way. Why? GMail automatically puts a label for all mail, coming from the old mailbox. A have already configured debugger129 account (I downloaded incoming mail to my phone and iPod), so I had to do just simple activity – go to settings of my new mailbox switch to “Accounts” tab, find “Get mail from other accounts” and type login and password for debugger129. Done! The next morning I had all my old mail with label “debugger129” in maxim.kukushkin mailbox.

3. Tell your friends
I felt as spammer when sending absolutely equal mails to all my contacts )) Why didn’t I just copy all email addresses to the “To” field and send only one message? Because everyone could see the list of other recipients. I don’t want to share my contact list with everyone, therefore I had to send copies. But before I could send mails, I imported the contact list from the old mailbox. GMail->Contacts->Export->Google’s CSV format, and then download the file. New GMail->Contacts->Import->Browse, and upload the previously downloaded file. All OK! All contacts are here now.

4. Change your contact information on most websites
While searching through my contacts, trying to find human mailboxes, I came across a lot of addresses which belong to diary.ru, vkontakte.ru, etc. It was helpful for me. I remembered that I have an accounts on these websites and vkontakte, for instance, uses my mailbox as login. I went to all of them immediately and updated my contact information.

5. Update your contact information in messengers and at work
I remembered that I had entered e-mail information in a one of registration forms at work.

6. Google Blogger
First of all, I had to create a Blogger account for my new mailbox. It’s simple, I just entered (or copied) the same information as it was in previous account. Next step – login to Blogger with debugger129 account and invite maxim.kukushkin to authors. Accept invitation. Return to Blogger and set admin privileges for the new author (maxim.kukushkin). Delete debugger129 from admins and authors. That’s all! My blog now belongs to the new account.

7. Google Reader
It took very little time. Just the same trick with Import/Export as it was for GMail contacts :)

8. iGoogle
I remembered that I have a lot of gadgets in iGoogle, and I want most of them to appear within my new account. I realized that I don’t use games which were in my previous iGoogle, and I didn’t waste time for searching for the games. Also, it wasn’t hard to find the required gadgets by searching for the by their title. The final touch – add theme. I haven’t found any gothic theme, so I decided on times of day, which I’ve seen on my friend’s iGoogle. Done!

9. Account information
Then I noticed “My Account” title in the right upper corner of the iGoogle and remembered to copy some information from previous account.

10. Google Notebook
I haven’t found any ways to Import/Export all notes. I think, this feature is under development process inside Google, because almost all other Google’s services have this one. Ok… Copy/Paste/Copy/Paste… awful!...

I think that’s all, because I haven’t touched other services yet :) Oh! Nearly forgot, at this moment I’m trying to find good transport for my new Jabber account and thinking about setting up my own transport on my own server. Just an idea…

P.S. While investigating Blogger’s settings, found that it provides OpenID. I have an OpenID now, welcome, Web2.0 )))

Wednesday, March 26, 2008

Google Flight Simulator

Update your Google Earth application and press Ctrl-Alt-A when it's loaded. You'll enter Google Flight Simluator, which is based on Google Earth. It provides you simple airplane control. Of course, picture isn't very good, but nevertheless it's very interesting to fly over Moscow for example :) By the way, if you try to land outside a runway, you'll crash ))) Three types of input devices are supported - keyboard, mouse and joystick. Keyboard seems to be very hard for controlling, mouse is simpler, but I enjoyed flying by means of joystick (similar to Sega). Here are some screenshots:

One of Moscow airports, I don't know which one

Landing... ))

Unremovable spaces by means of CSS

As I started posting here I faced the challenge - when I write program code it's necessary to paste spaces actually before each line. Also, I decided to use <code> tag to separate program code. By default, all sequences of spaces are replaced by one and to copy-paste a lot of &nsbs; is very inconveniently. So I found resolution in CSS:

.post code{
white-space: pre;
}


".post" is local class which is used for all posts; "pre" means that spaces shouldn't be deleted (like <pre>). Other possible values are "normal" and "nowrap".

Song of the day

Within Temptation - Deceiver of Fools. This song repeated in my mind the whole day :) And now, I'm listening it through my iPod and really enjoy Sharon's voice and music of the band. Here are the lyrics:

{He feeds on fear
He feeds on pain
He rules again
With growing hate
He will gain
Their faith again

No light in the darkness
Is too small to see
There's always a sparkle of hope
If you just believe...}

He told the tale so many times
About the dream not meant to be
In a world of the free

{Plays with your mind}

As faith for the future faded fast
He grows strong with their displeasure
It sets him free

(chorus)
Deceiver of hearts
Deceiver of fools
He rules with fear
Deceiver of hopes
Deceiver of fools
He rules again

He feeds on fear
Poisons the truth
To gain their faith
To lead the way
To a world of decay

{Rules your heart}

He'll sell your soul to the grave
Without a hesitation to make
He belongs to the dark

(chorus)

Please awake
And see the truth
He can only be
If you believe what he tells you
Remember who you are
What you stand for
And there will always be a way

(chorus)

In my heart there is a place
In my heart there is a trace
Of a small fire burning
A sheltering ray shines through this night
Although it's small, it's bright
But darkness is lurking

He will sell your soul to bitterness and cold
Oh fear him

Deceiver of hearts
Deceiver of fools
He rules with fear
Deceiver of hopes
Deceiver of fools
Shall he rule again?

Tuesday, March 25, 2008

Continue of loop in VBA

As I understood from this post, there's no special instruction to skip loop iteration in VBA. So, may be the only way to do it is to place a special label just before the end of the current loop and then use GoTo statement:

For i = 1 To 10
If i = 5 Then
GoTo nextiteration
End If
' do some more stuff
nextiteration:
Next

File existance checking in VBA

I found this method in the Internet, in two different forums. Just write a simple function-wrapper:

Function Fileexists(fname) As Boolean
If Dir(fname) <> "" Then
Fileexists = True
Else
Fileexists = False
End If
End Function


Then you can use this function just the same way as in many other languages.

Monday, March 24, 2008

Clearing the Clipboard in VBA

There is no special function to clear Clipboard, so we should use Win API functions. The following code clears the Clipboard:

' System functions
Public Declare Function OpenClipboard Lib "user32" (ByVal hWnd As Long) As Long
Public Declare Function EmptyClipboard Lib "user32" () As Long
Public Declare Function CloseClipboard Lib "user32" () As Long

' Implementation of function which clears the Clipboard
Public Function ClipboardEmpty() As Boolean
Dim l As Long, i As Long
l = OpenClipboard(0&)
If l <> 0 Then
l = EmptyClipboard()
i = CloseClipboard()
End If
ClipboardEmpty = (l <> 0)
End Function

' Using the function
If Not ClipboardEmpty() Then MsgBox("Clipboard isn't empty")



This way you can prevent Excel messages like "There is a large amount of information on the Clipboard..." when closing a window (be means of VBA)