http://simplyprogram.com Simply programming - It's a life style Mon, 04 May 2009 14:13:13 +0000 http://backend.userland.com/rss092 en Read... and study it! http://us2.php.net/manual/en/function.flock.php http://simplyprogram.com/locking-and-unlocking-a-file-with-php/ This macro will allow you to extract a url/mailto from excel and place it into the next cell. To see more options: Click here [CODE] Sub ExtractHL() Dim HL As Hyperlink For Each HL In ActiveSheet.Hyperlinks HL.Range.Offset(0, 1).Value = HL.Address Next End Sub [/CODE] http://simplyprogram.com/extracting-a-url-from-an-excel-cell/ [CODE] 01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 [/CODE] http://simplyprogram.com/date-dropdown/ Same issue with states I have with dates lol [CODE] January February March April May June July August September October November December [/CODE] http://simplyprogram.com/month-dropdown/ This always drives me crazy, finding a quick dropdown for the 50 us states. So here you go! [CODE] Alabama Alaska Arizona Arkansas California Colorado Connecticut Delaware District of Columbia Florida Georgia Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota Ohio Oklahoma Oregon Pennsylvania Rhode Island South Carolina South Dakota Tennessee Texas Utah Vermont Virginia Washington West Virginia Wisconsin Wyoming [/CODE] http://simplyprogram.com/50-us-states-dropdown-html/ I'm not sure why, but I always forget how to remove a border on an iframe... funny. [CODE] frameborder="0" [/CODE] http://simplyprogram.com/remove-an-iframe-border/ Fantastic solution was found here: http://www.jsnippet.com/?p=103 http://simplyprogram.com/limit-the-number-of-rows-in-a-textaera/ I always run into this little problem - how to check all and uncheck all checkboxes no a single page. Heres a nice easy solution. [CODE] function checkAll() { if(document.getElementById('checkallbox').checked == true) // the element that you will check to check all boxes. { var checks = document.getElementsByName('CHECKBOXNAME'); for(var i=0;i http://simplyprogram.com/check-all-checkboxes-in-a-form/ Its quite simple actually - you create your favicon.ico file (which is normally 16x16) in an graphic editor you choose. Next upload it to your website. Once uploaded add the below code to the header of your website: [HTML] [/HTML] And your done! http://simplyprogram.com/how-to-add-a-favicon-to-your-website/ How to preview a site in plesk, well its very simply once you know how. https://YOUR_IP_ADDRESS_HERE:8443/sitepreview/http/SITE_YOU_WANT_TO_VIEW/ Newer versions of plesk have this feature enabled on your sites control panel, you will see an icon called "Site Preview". However; this is not on older versions. So for example you want to view a ... http://simplyprogram.com/preview-a-site-in-plesk/