Edit Excel Query Connection to New Location

What is to be done when the location of our raw data has moved and there is a relating Excel file to maintain? Manually, we can go to

1) click connection, 2) click properties, 3) click definition, 4) click browse, 5) locate the file, 6) set up delimited Text Import Wizard Step 1, click next, 7) set up delimiters Step 2, 8) set up step 3, 9) click OK again

[It probably will work. However there might also be an error from MS Office Excel after all these hard work. And if it works, we need to do it 7 times when there are 7 worksheets to be updated.]

Quicker way:

Place the cursor on a cell within the cell range of the query
Open VBEditor (Alt-F11)

Open the Intermediate window (Ctrl-G)

Type the command: ?ActiveCell.QueryTable.Connection [press enter]

(The relevant connection info will be echoed back, e.g. TEXT;G:\raw_data\file1.txt

Type the command: ActiveCell.QueryTable.Connection = "TEXT;D:\raw_data\file1.txt" [press enter]
(Notice that the drive G: is changed to D: in this case)

Optional (as required):
Once the above is done, the delimiters will all be automatically set to none. So to set the delimiter as a comma:

Type the command: ActiveCell.QueryTable.TextFileCommaDelimiter = true [press enter]
(To set the delimiter as a comma... )

Type the command: ActiveCell.QueryTable.TextFileOtherDelimiter = ";" [press enter]
(Or any delimiter as needed e.g. ;)

Google Date Keeper Update (Greasemonkey)

Rrinnggg....
   "zzz... he..ll..ooo... zzz... zzz"
"There ARE changes on the google search site! "
   "zzz... okay...zzz...zzz"
"That was weeks ago!! Do something to your #~!@$%^ scripts or I'm not going to use them anymore!!!"

Keeping Date Attributes of Files Unchanged

By Copying Files to Another Folder

When we want to keep a duplication of a file as reference, saving a copy of it within the same folder will update the "Date Created" attribute of that file to the current time.

To keep the "Date Created" attribute unchanged, copy the file into another folder. This can be done by pressing the Control key while mouse dragging it.

By Moving Files from One drive To Another

When we copy any files by mouse dragging it from one drive to another, the "Date Created" attribute of that file is updated to the current time.

To keep the "Date Created" attribute unchanged, move the file by pressing the Shift key while mouse dragging it.

This, however, will only work on files. Folders not included.

Adding Music to Your Blog Using Flash-SWF

By adding music to your blog using flash/swf, visitors need not download any plug-ins since most browsers support flash as a standard.

As an example, the JW Player is used here as it is free for most users.

Quick Editing Icon Missing On My Blog

This Quick Editing Icon didn't show up even after being set to be displayed using the layout tab.

The HTML codes are already on the page, just that they aren't visible. Something to do with login or cookie? Maybe setting the Firefox browser to accept 3rd-party cookies will do wonders?

It does!

Hidding System Icons and IE on Desktop Toolbar

 "Why... these %~!@#$^ persistent little pests! I've deleted them a thousand times!" [disgusted]

   "just use Quick Launch lor..."

"What? And render the customized shortcuts useless?!" [more disgusted]

   "well..."

"... and don't tell me to modify the registry!"

    "then..."

Windows Advanced Options Menu F8

[Fast keyboard clicking: F8. F8. F8. F8. F8. F8. F8. F8. F8...]
"%~!@#$^! Where's that stupid options menu?"

Or have the Windows Advanced Options Menu always booting for that peace of mind.

1) Edit C:\boot.ini
2) Under [operating systems], add more options

5 Quick Steps to Googling

Preparation:

Set bookmark with Location: www.google.com/search?q=%s and Keyword: gg
Install Firefox Add-on "My Surfing Board"
Install Greasemonkey Script "Search on Google - Navigation"

* * * * *