Jerome's Blog
Tuesday, May 21, 2013
Sunday, May 19, 2013
Custom Function in Excel to get the url of the cell
i copy the links from the webpage straight into excel
well the url or hyperlink its there but the problem is...
i need to insert them into mysql database and...
there are 10,000 records.
i am still using office 2007 don't whether the function is available in the newer versions..
so here are the steps for ppl using excel 2007..........
open a macro enabled workbook or save it later as .xlsm
Alt + F11 open the visual basic editor
insert a new module
paste the following code (highlighted in yellow)
Function GETURL(HyperlinkCell As Range)
GETURL = HyperlinkCell.Hyperlinks(1).Address
End Function
save and close the editor
now go back to the sheet view
Saturday, May 18, 2013
Tuesday, May 7, 2013
Monday, May 6, 2013
Sunday, May 5, 2013
Double Meaning Domain Names
Itscrap.com
Whorepresents.com
Penisland.net
Expertsexchange.com
Speedofart.com
Nobjs.org
Gotahoenorth.com
Lesbocages.com
Americanscrapmetal.com
Masterbaitonline.com
Therapistinabox.com
Analemma.org
Therapistfinder.com
Wintersexpress.com
Swissbit.ch
Dicksonweb.com
Therapist.com
Budget.co.ck
Mp3shits.com
Kidsexchange.net
Choosespain.com
Bendover.com
Bitefartcafe.rs
Powergenitalia.com
Cumstore.co.uk
Teacherstalking.org
Ladrape.com
Childrenswear.co.uk
Molestationnursery.com
Oldmanshaven.com
Whorepresents.com
Penisland.net
Expertsexchange.com
Speedofart.com
Nobjs.org
Gotahoenorth.com
Lesbocages.com
Americanscrapmetal.com
Masterbaitonline.com
Therapistinabox.com
Analemma.org
Therapistfinder.com
Wintersexpress.com
Swissbit.ch
Dicksonweb.com
Therapist.com
Budget.co.ck
Mp3shits.com
Kidsexchange.net
Choosespain.com
Bendover.com
Bitefartcafe.rs
Powergenitalia.com
Cumstore.co.uk
Teacherstalking.org
Ladrape.com
Childrenswear.co.uk
Molestationnursery.com
Oldmanshaven.com
Friday, May 3, 2013
mySQL mulitple table update
UPDATE
config, tmp_config
SET
config.new1 = tmp_config.new1,
config.new2 = tmp_config.new2
WHERE tmp_config.tmp_id = config.id
UPDATE account, vtiger_accountshipads
SET account.acc_shipping_address=vtiger_accountshipads.ship_street, account.acc_shipping_po_box=vtiger_accountshipads.ship_pobox, account.acc_shipping_city=vtiger_accountshipads.ship_city , account.acc_shipping_state=vtiger_accountshipads.ship_state, account.acc_shipping_postal_code=vtiger_accountshipads.ship_code , account.acc_shipping_country=vtiger_accountshipads.ship_country
WHERE vtiger_accountshipads.id=account.acc_id
SET
config.new1 = tmp_config.new1,
config.new2 = tmp_config.new2
WHERE tmp_config.tmp_id = config.id
UPDATE account, vtiger_accountshipads
SET account.acc_shipping_address=vtiger_accountshipads.ship_street, account.acc_shipping_po_box=vtiger_accountshipads.ship_pobox, account.acc_shipping_city=vtiger_accountshipads.ship_city , account.acc_shipping_state=vtiger_accountshipads.ship_state, account.acc_shipping_postal_code=vtiger_accountshipads.ship_code , account.acc_shipping_country=vtiger_accountshipads.ship_country
WHERE vtiger_accountshipads.id=account.acc_id
Thursday, May 2, 2013
Richard Stallman Talks About Ubuntu
Richard Stallman Talks About Ubuntu & its privacy invasing (according to EFF and FSF) Features. In order to access the video (watch or download) usining free software. Please read the article on Muktware.click here
Thursday, April 25, 2013
Subscribe to:
Posts (Atom)







