<?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/' xmlns:georss='http://www.georss.org/georss' xmlns:gd='http://schemas.google.com/g/2005' xmlns:thr='http://purl.org/syndication/thread/1.0'><id>tag:blogger.com,1999:blog-5633306846914877241</id><updated>2012-02-16T20:05:47.476+07:00</updated><category term='split string'/><category term='vba'/><category term='vb function'/><category term='expand widget template'/><category term='sample code'/><category term='define variable'/><category term='error handler'/><category term='delimiter'/><category term='loop'/><category term='read more'/><category term='split space'/><category term='Do It Yourself'/><category term='how to'/><category term='commandbutton'/><category term='excerpt article'/><category term='edit template'/><category term='blog'/><category term='button'/><category term='vb'/><category term='split'/><category term='do loop'/><category term='if then elft'/><category term='blogger'/><category term='edit html'/><category term='variant'/><category term='Visual Basic'/><category term='add textbox'/><category term='vb string'/><title type='text'>Visual Basic Do It Yourself</title><subtitle type='html'>Welcome to my Visual Basic Do It Yourself's blog.Here you will learn about Visual Basic Do It Yourself's tips and how to find good information.</subtitle><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='http://vbdiy.blogspot.com/feeds/posts/default'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5633306846914877241/posts/default?max-results=100'/><link rel='alternate' type='text/html' href='http://vbdiy.blogspot.com/'/><link rel='hub' href='http://pubsubhubbub.appspot.com/'/><author><name>MrBOV</name><uri>http://www.blogger.com/profile/07306007804748479084</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>4</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>100</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-5633306846914877241.post-554022972450519729</id><published>2008-10-25T13:36:00.013+07:00</published><updated>2008-10-25T14:50:18.156+07:00</updated><title type='text'>Blogger Mod : Excerpt Articles and Read More Link..Part 2</title><content type='html'>5. Choose Edit &gt; Find in 2 nd NotePad windows input only red text into the Find What's feild&lt;br /&gt;&lt;br /&gt;"&lt;span style="color:#ff0000;"&gt;/b:skin&lt;/span&gt;"&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;div&gt;&lt;a href="http://4.bp.blogspot.com/_PbPNT5IzoA0/SQLAPehu1GI/AAAAAAAAAB0/2JAFfKclw-E/s1600-h/find-bskin.PNG"&gt;&lt;img id="BLOGGER_PHOTO_ID_5260978686847276130" style="WIDTH: 400px; CURSOR: hand; HEIGHT: 210px" alt="" src="http://4.bp.blogspot.com/_PbPNT5IzoA0/SQLAPehu1GI/AAAAAAAAAB0/2JAFfKclw-E/s400/find-bskin.PNG" border="0" /&gt;&lt;/a&gt;&lt;/div&gt;&lt;br /&gt;&lt;br /&gt;&lt;span id="fullpost"&gt;&lt;br /&gt;&lt;br /&gt;&lt;div&gt;6. Insert after find text for below text &lt;/div&gt;&lt;br /&gt;&lt;div&gt;&lt;a href="http://4.bp.blogspot.com/_PbPNT5IzoA0/SQLCb7koH5I/AAAAAAAAAB8/FhL9i1dRTeo/s1600-h/replace1.PNG"&gt;&lt;img id="BLOGGER_PHOTO_ID_5260981099825733522" style="WIDTH: 344px; CURSOR: hand; HEIGHT: 54px" alt="" src="http://4.bp.blogspot.com/_PbPNT5IzoA0/SQLCb7koH5I/AAAAAAAAAB8/FhL9i1dRTeo/s400/replace1.PNG" border="0" /&gt;&lt;/a&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;7. follow step 5 to 6 again with find text "&lt;span style="color:#ff0000;"&gt;data:post.body&lt;/span&gt;" and insert after "find text" which &lt;/div&gt;&lt;br /&gt;&lt;br /&gt;&lt;a href="http://1.bp.blogspot.com/_PbPNT5IzoA0/SQLDmDJ0ZII/AAAAAAAAACE/wWwK_ahhrk0/s1600-h/replace2.PNG"&gt;&lt;img id="BLOGGER_PHOTO_ID_5260982373171094658" style="WIDTH: 406px; CURSOR: hand; HEIGHT: 46px" alt="" src="http://1.bp.blogspot.com/_PbPNT5IzoA0/SQLDmDJ0ZII/AAAAAAAAACE/wWwK_ahhrk0/s400/replace2.PNG" border="0" /&gt;&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;8. Go to edit menu choose "Select All" and right click again choose "Copy"&lt;br /&gt;&lt;br /&gt;&lt;a href="http://2.bp.blogspot.com/_PbPNT5IzoA0/SQLGGs7f1YI/AAAAAAAAACM/x1tbEM8saZk/s1600-h/select-all-mod-code.PNG"&gt;&lt;img id="BLOGGER_PHOTO_ID_5260985133164385666" style="WIDTH: 400px; CURSOR: hand; HEIGHT: 210px" alt="" src="http://2.bp.blogspot.com/_PbPNT5IzoA0/SQLGGs7f1YI/AAAAAAAAACM/x1tbEM8saZk/s400/select-all-mod-code.PNG" border="0" /&gt;&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;9. Go to blogger html windows right click on text area choose "Select All" and right click again choose "Paste" mean paste modifiy code from NotePad windows to Blogger html windows, next click "Save Template"&lt;br /&gt;&lt;br /&gt;&lt;a href="http://3.bp.blogspot.com/_PbPNT5IzoA0/SQLJW4D_FgI/AAAAAAAAACU/r6sFLM-Y_2Q/s1600-h/paste-mod-code-to-blogger.PNG"&gt;&lt;img id="BLOGGER_PHOTO_ID_5260988709565568514" style="WIDTH: 400px; CURSOR: hand; HEIGHT: 258px" alt="" src="http://3.bp.blogspot.com/_PbPNT5IzoA0/SQLJW4D_FgI/AAAAAAAAACU/r6sFLM-Y_2Q/s400/paste-mod-code-to-blogger.PNG" border="0" /&gt;&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;p&gt;10. On post section you must post like this format &lt;/p&gt;&lt;a href="http://2.bp.blogspot.com/_PbPNT5IzoA0/SQLOXPVpYdI/AAAAAAAAACc/FdBoqfMLV6c/s1600-h/format-post.PNG"&gt;&lt;img id="BLOGGER_PHOTO_ID_5260994213371797970" style="WIDTH: 174px; CURSOR: hand; HEIGHT: 99px" alt="" src="http://2.bp.blogspot.com/_PbPNT5IzoA0/SQLOXPVpYdI/AAAAAAAAACc/FdBoqfMLV6c/s400/format-post.PNG" border="0" /&gt;&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;for older post you should be edit like that too.&lt;br /&gt;&lt;/span&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5633306846914877241-554022972450519729?l=vbdiy.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://vbdiy.blogspot.com/feeds/554022972450519729/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://vbdiy.blogspot.com/2008/10/blogger-mod-excerpt-articles-and-read_25.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5633306846914877241/posts/default/554022972450519729'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5633306846914877241/posts/default/554022972450519729'/><link rel='alternate' type='text/html' href='http://vbdiy.blogspot.com/2008/10/blogger-mod-excerpt-articles-and-read_25.html' title='Blogger Mod : Excerpt Articles and Read More Link..Part 2'/><author><name>MrBOV</name><uri>http://www.blogger.com/profile/07306007804748479084</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://4.bp.blogspot.com/_PbPNT5IzoA0/SQLAPehu1GI/AAAAAAAAAB0/2JAFfKclw-E/s72-c/find-bskin.PNG' height='72' width='72'/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5633306846914877241.post-7986107168476767592</id><published>2008-10-24T15:21:00.015+07:00</published><updated>2008-10-24T16:24:00.661+07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='edit template'/><category scheme='http://www.blogger.com/atom/ns#' term='blogger'/><category scheme='http://www.blogger.com/atom/ns#' term='read more'/><category scheme='http://www.blogger.com/atom/ns#' term='expand widget template'/><category scheme='http://www.blogger.com/atom/ns#' term='edit html'/><category scheme='http://www.blogger.com/atom/ns#' term='excerpt article'/><title type='text'>Blogger Mod : Excerpt Articles and Read More Link..Part 1</title><content type='html'>1. Choose Template &gt; Edit HTML &gt; check Expand Widget Template in red marked. &lt;div&gt;&lt;a href="http://3.bp.blogspot.com/_PbPNT5IzoA0/SQGGXWdy1tI/AAAAAAAAAAo/w0Mkziyac2E/s1600-h/extend_html.PNG"&gt;&lt;img id="BLOGGER_PHOTO_ID_5260633575471109842" style="WIDTH: 400px; CURSOR: hand; HEIGHT: 242px" alt="" src="http://3.bp.blogspot.com/_PbPNT5IzoA0/SQGGXWdy1tI/AAAAAAAAAAo/w0Mkziyac2E/s400/extend_html.PNG" border="0" /&gt;&lt;/a&gt;&lt;br /&gt;&lt;/div&gt;&lt;span id="fullpost"&gt;&lt;br /&gt;&lt;div&gt;2. right click in text area choose "Select All" right click again choose "Copy"&lt;br /&gt;&lt;/div&gt;&lt;br /&gt;&lt;div&gt;&lt;a href="http://1.bp.blogspot.com/_PbPNT5IzoA0/SQGHXwbeDEI/AAAAAAAAAA4/5iworUhKcmQ/s1600-h/select-all.PNG"&gt;&lt;img id="BLOGGER_PHOTO_ID_5260634681952308290" style="WIDTH: 400px; CURSOR: hand; HEIGHT: 253px" alt="" src="http://1.bp.blogspot.com/_PbPNT5IzoA0/SQGHXwbeDEI/AAAAAAAAAA4/5iworUhKcmQ/s400/select-all.PNG" border="0" /&gt;&lt;/a&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;3. Open "NotePad" Program or another text editor I choose NotePad&lt;/div&gt;&lt;div&gt;&lt;/div&gt;&lt;div&gt;&lt;/div&gt;&lt;div&gt;&lt;a href="http://3.bp.blogspot.com/_PbPNT5IzoA0/SQGIFnzBLSI/AAAAAAAAABA/joJ9Tb5SgEw/s1600-h/open-notepad.PNG"&gt;&lt;img id="BLOGGER_PHOTO_ID_5260635469909142818" style="WIDTH: 367px; CURSOR: hand; HEIGHT: 400px" alt="" src="http://3.bp.blogspot.com/_PbPNT5IzoA0/SQGIFnzBLSI/AAAAAAAAABA/joJ9Tb5SgEw/s400/open-notepad.PNG" border="0" /&gt;&lt;/a&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;4. right click in NotPad area choose "Paste" you will get the first copy of your full code template. This is copy just backup for your code only, you will open NotePad again and same step to paste code for your 2nd copy.&lt;/div&gt;&lt;div&gt;&lt;/div&gt;&lt;div&gt;&lt;/div&gt;&lt;div&gt;&lt;a href="http://2.bp.blogspot.com/_PbPNT5IzoA0/SQGIrdPFt3I/AAAAAAAAABI/q7YdiIz4owI/s1600-h/paste-full-code.PNG"&gt;&lt;img id="BLOGGER_PHOTO_ID_5260636119909119858" style="WIDTH: 400px; CURSOR: hand; HEIGHT: 246px" alt="" src="http://2.bp.blogspot.com/_PbPNT5IzoA0/SQGIrdPFt3I/AAAAAAAAABI/q7YdiIz4owI/s400/paste-full-code.PNG" border="0" /&gt;&lt;/a&gt;&lt;/div&gt;&lt;div&gt;&lt;/div&gt;&lt;br /&gt;&lt;div&gt;&lt;a href="http://3.bp.blogspot.com/_PbPNT5IzoA0/SQGJ7qQBTFI/AAAAAAAAABQ/jahDDLVcXBs/s1600-h/open-notepad2.PNG"&gt;&lt;img id="BLOGGER_PHOTO_ID_5260637497792220242" style="WIDTH: 400px; CURSOR: hand; HEIGHT: 213px" alt="" src="http://3.bp.blogspot.com/_PbPNT5IzoA0/SQGJ7qQBTFI/AAAAAAAAABQ/jahDDLVcXBs/s400/open-notepad2.PNG" border="0" /&gt;&lt;/a&gt;&lt;br /&gt;&lt;/span&gt;&lt;/div&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5633306846914877241-7986107168476767592?l=vbdiy.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://vbdiy.blogspot.com/feeds/7986107168476767592/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://vbdiy.blogspot.com/2008/10/blogger-mod-excerpt-articles-and-read.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5633306846914877241/posts/default/7986107168476767592'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5633306846914877241/posts/default/7986107168476767592'/><link rel='alternate' type='text/html' href='http://vbdiy.blogspot.com/2008/10/blogger-mod-excerpt-articles-and-read.html' title='Blogger Mod : Excerpt Articles and Read More Link..Part 1'/><author><name>MrBOV</name><uri>http://www.blogger.com/profile/07306007804748479084</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://3.bp.blogspot.com/_PbPNT5IzoA0/SQGGXWdy1tI/AAAAAAAAAAo/w0Mkziyac2E/s72-c/extend_html.PNG' height='72' width='72'/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5633306846914877241.post-7290646348955558642</id><published>2008-10-24T13:30:00.007+07:00</published><updated>2012-02-02T15:51:47.076+07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='split'/><category scheme='http://www.blogger.com/atom/ns#' term='add textbox'/><category scheme='http://www.blogger.com/atom/ns#' term='split space'/><category scheme='http://www.blogger.com/atom/ns#' term='split string'/><category scheme='http://www.blogger.com/atom/ns#' term='vb function'/><category scheme='http://www.blogger.com/atom/ns#' term='button'/><category scheme='http://www.blogger.com/atom/ns#' term='define variable'/><category scheme='http://www.blogger.com/atom/ns#' term='vb string'/><category scheme='http://www.blogger.com/atom/ns#' term='commandbutton'/><category scheme='http://www.blogger.com/atom/ns#' term='loop'/><category scheme='http://www.blogger.com/atom/ns#' term='error handler'/><category scheme='http://www.blogger.com/atom/ns#' term='sample code'/><category scheme='http://www.blogger.com/atom/ns#' term='variant'/><category scheme='http://www.blogger.com/atom/ns#' term='if then elft'/><category scheme='http://www.blogger.com/atom/ns#' term='do loop'/><category scheme='http://www.blogger.com/atom/ns#' term='delimiter'/><title type='text'>Split String so simple and easy by VB function [vb split string]</title><content type='html'>1. Format of Raw Data for split You should know about data format for your spliting, such as 1.1 what delimiter ? space(” “) or slash(”/”) or mix format&lt;br /&gt;1.2 what data type to convert&lt;br /&gt;2. Function to use&lt;br /&gt;Use Split Function for split data&lt;br /&gt;&lt;span id="fullpost"&gt;&lt;br /&gt;Sample Code&lt;br /&gt;creat one textbox and one button&lt;/span&gt;&lt;br /&gt;&lt;blockquote class="tr_bq"&gt; Option Explicit Private Sub CommandButton1_Click() ’error handler for Do Loop action over one step On Error GoTo Err Dim RawData As String Dim SplitData() As String Dim i, IndexData As Integer Dim Answer As Variant IndexData = 1 RawData = TextBox1.Text SplitData = Split(RawData)&lt;br /&gt;‘find number of data array Do Until IndexData = 0 If IsNull(SplitData(IndexData - 1)) = False Then IndexData = IndexData + 1 Else: IndexData = 0 End If Loop Err: For i = 0 To IndexData - 2 Step 1 ’subtract for IndexData startpoint at 1 and overstep Do Loop 1 MsgBox SplitData(i) Next i End Sub&lt;/blockquote&gt;&lt;br /&gt;The part of this article is credit to &lt;a href="http://www.blogbov.co.cc/"&gt;http://www.blogbov.co.cc/&lt;/a&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5633306846914877241-7290646348955558642?l=vbdiy.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://vbdiy.blogspot.com/feeds/7290646348955558642/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://vbdiy.blogspot.com/2008/10/split-string-so-simple-and-easy-by-vb.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5633306846914877241/posts/default/7290646348955558642'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5633306846914877241/posts/default/7290646348955558642'/><link rel='alternate' type='text/html' href='http://vbdiy.blogspot.com/2008/10/split-string-so-simple-and-easy-by-vb.html' title='Split String so simple and easy by VB function [vb split string]'/><author><name>MrBOV</name><uri>http://www.blogger.com/profile/07306007804748479084</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5633306846914877241.post-6188402516152151905</id><published>2008-10-24T11:27:00.001+07:00</published><updated>2008-10-24T13:28:46.494+07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='blog'/><category scheme='http://www.blogger.com/atom/ns#' term='vb'/><category scheme='http://www.blogger.com/atom/ns#' term='Do It Yourself'/><category scheme='http://www.blogger.com/atom/ns#' term='Visual Basic'/><category scheme='http://www.blogger.com/atom/ns#' term='how to'/><category scheme='http://www.blogger.com/atom/ns#' term='vba'/><title type='text'>Visual Basic Do It Yourself [vb diy]</title><content type='html'>&lt;a href="http://4.bp.blogspot.com/_PbPNT5IzoA0/SQFQTCkUjTI/AAAAAAAAAAM/Xgr-PA985eY/s1600-h/vb6.jpg"&gt;&lt;img id="BLOGGER_PHOTO_ID_5260574127782399282" style="FLOAT: left; MARGIN: 0px 10px 10px 0px; WIDTH: 116px; CURSOR: hand; HEIGHT: 141px" alt="" src="http://4.bp.blogspot.com/_PbPNT5IzoA0/SQFQTCkUjTI/AAAAAAAAAAM/Xgr-PA985eY/s320/vb6.jpg" border="0" /&gt;&lt;/a&gt; Welcome to my Visual Basic Do It Yourself's blog.Here you will learn about Visual Basic Do It Yourself's tips and how to find good information.&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5633306846914877241-6188402516152151905?l=vbdiy.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://vbdiy.blogspot.com/feeds/6188402516152151905/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://vbdiy.blogspot.com/2008/10/visual-basic-do-it-yourself-vb-diy.html#comment-form' title='1 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5633306846914877241/posts/default/6188402516152151905'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5633306846914877241/posts/default/6188402516152151905'/><link rel='alternate' type='text/html' href='http://vbdiy.blogspot.com/2008/10/visual-basic-do-it-yourself-vb-diy.html' title='Visual Basic Do It Yourself [vb diy]'/><author><name>MrBOV</name><uri>http://www.blogger.com/profile/07306007804748479084</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://4.bp.blogspot.com/_PbPNT5IzoA0/SQFQTCkUjTI/AAAAAAAAAAM/Xgr-PA985eY/s72-c/vb6.jpg' height='72' width='72'/><thr:total>1</thr:total></entry></feed>
