Code in VB for Text to coloumn ?
613256
I didn't get you well,\nExcel already can open csv files (Comma separated values) if ther were seperated with commas.\nWhy you need to convert it to columns?\nany way...\n\nsend me more info.\n\n\nXLMan
75210
I'm assuming the data is in ONE table, with columns X, Y respectively, with Y having data that is comma delimited.  If so, then:\n\n1) Create a function that splits delimited data into multiple rows:\n\nCREATE FUNCTION fnUtil_Split(@SplitString varchar(8000), @Delimiter varchar(10))\n-- This function simulates the VB split function and returns a table containing all\n-- of the split values.\n-- Code obtained from http://www.odetocode.com/Code/58.aspx\n\nRETURNS @SplitTable TABLE(\n TableVar  varchar(500)\n   )\nAS\nBEGIN\n-- Helper variables\nDECLARE @FC int\nSET @FC = -1\n\n-- Loop until there is no more\nWHILE (Len(@SplitString) > 0) BEGIN\nSET @FC = CHARINDEX(@Delimiter , @SplitString)\n\nIF (@FC = 0) AND (LEN(@SplitString) > 0) BEGIN\nINSERT INTO @SplitTable VALUES (RTRIM(LTRIM(@SplitString)))\nBREAK\nEND\n\nIF (@FC > 1) BEGIN\nINSERT INTO @SplitTable VALUES (RTRIM(LTRIM(LEFT(@SplitString, @FC - 1))))\nSET @SplitString = RTRIM(LTRIM(RIGHT(@SplitString, (LEN(@SplitString) - @FC))))\nEND ELSE SET @SplitString = RTRIM(LTRIM(RIGHT(@SplitString, (LEN(@SplitString) - @FC))))\nEND\n\nRETURN\nEND\n\n2)  Cross join to combine the delimited data of column Y with the data in column X:\n\nSELECT mytable.X, split_table.delimitedData\nFROM mytable \n       cross join (SELECT TableVar AS delimitedData\n                   FROM dbo.fnUtil_Split(mytable.Y, ',')\n                  )AS split_table\n\nThis should combine column X with the "split" data from column Y.
525506
In Visual Basic, you use Right(), Left() and Trim(). I don't know where you're getting those dollar signs from, but they don't belong in Visual Basic.\n\nDim strFirst As String = Left( "Howard Smith", 6 ) ' strFirst = "Howard"\n\nDim strLast As String = Right( "Howard Smith", 5 ) ' strLast = "Smith"\n\nDim strTrim As String = Trim( " Howard Smith " ) ' strTrim = "Howard Smith"\n\nIn VB.NET, it would be:\n\nDim strName As String = " Howard Smith "\n\nDim strFirst As String = strName.SubString( 2, 6 ) ' strFirst = "Howard"\n\nDim strLast As String = strName.SubString( 9, 5 ) ' strLast = "Smith" \n\nDim strTrim As String = strName.Trim() ' strTrim = "Howard Smith"
3591
You can do it by using html in it use vbscript and ASP that will help u better it is not difficut at all u can do it very easily if u wanna learn the HTML VBSCRIPT ,JAVA SCRIPT, and ASP u can use the follwing site ok all the best
834309
depending on how many squares (cells) and rows/columns you would be using to create it.\n\nfor example,if you wanted 4 squares across & 2 rows down \n\n1 2  3  4 \n5 6  7  8 \n\nusing red & black alternating  you would write it like:\n\n<table border="0" cellspacing="0">\n<tr>\n<td bgcolor="#FF0000">Cell 1</td>\n<td bgcolor="#000000">Cell 2</td>\n<td bgcolor="#FF0000">Cell 3</td>\n<td bgcolor="#000000">Cell 4</td>\n</tr>\n<tr>\n<td bgcolor="#FF0000">cell 5</td>\n<td bgcolor="#000000">cell 6</td>\n<td bgcolor="#FF0000">cell 7</td>\n<td bgcolor="#000000">cell 8</td>\n</tr>\n</table>\n</tr>\n</table>\n\nfor using the pattern techinque only and no text (text was used so i can demonstrate to ya) remove the cell 1,cell 2,etc
23130
You need a new table inside the TD's.\n\n<table>\n<TR>\n<TD>\n<table>\n<TR>\n<TD>\nstuff\n</TD>\n<TD>\nstuff2\n</TD>\n</TR>\n</TABLE>\n</TD>\n</TR>\n</TABLE>\n\nAlso, if you have some rows with more TD's than others, try "colspan=#" inside the larger TDs.
353874
First you have to have a variable assigned to the edit box, one called, say, m_String. Then in your code you write:\n\nUpdateData(TRUE);\n\nNow m_String has the contents of the edit box.
459724
In Laymans.\nHold your cursor (mouse) infront of the text you wish to highlight.....\nonce you LEFT-clicked hold the click and drag across and the text will be highlighed...\ninstead of right-clicking to copy and paste..\nLearn these keyboard shortcuts..\n\nCTRL + C  (held together at the same time) is Copy!\nCTRL + V (held togert at same time) is to  paste\n\nNOTE CTRL + C dont holf the "+" along with it is just CTRL C\n....\nJust wanted to let you kno that they are held together
614180
In VBA (as used in PowerPoint) declaring a variable and assigning a value must be separated.\n\nDim astring as String\nastring = "Test"\n\nIn VB 2005, VB.NET, etc. - your expression would be fine.\n\n*** Additional Stuff ***\nSounds like you're really struggling ... In the code module for the presentation you'll need to put the code in a procedure ... here's an example\n\nSub TestThis()\n    Dim astring As String\n    astring = "Test"\n    MsgBox (astring)\nEnd Sub\n\nAfter this, you'll be able to run this code as a macro ... Tools >> Macro >>> Macros ... then select the "TestThis" macro and run it ... you'll get your message box.\n\nGood luck!
460847
to do something like that in word you would have to convert the text into a table (found under the table menu) then sort the table (sort is also found in the table menu)
844565
I give you a code for having two colums(2 box) \nA yellow and a blue(just change the color in the code after setting the width and the height of the 2 blocs):\n\n<DIV style="BORDER-RIGHT: #000000 2px solid; BORDER-TOP: #000000 2px solid; FLOAT: left; BORDER-LEFT: #000000 2px solid; WIDTH: 350px; COLOR: black; BORDER-BOTTOM: #000000 2px solid; HEIGHT: 222px; BACKGROUND-COLOR: #ffff00">your text, images,links here(yellow bloc)</DIV>\n<DIV style="BORDER-RIGHT: #000000 2px solid; BORDER-TOP: #000000 2px solid; FLOAT: right; BORDER-LEFT: #000000 2px solid; WIDTH: 350px; COLOR: black; BORDER-BOTTOM: #000000 2px solid; HEIGHT: 222px; BACKGROUND-COLOR: #66ffff">your text,image,link here(blue box)</DIV>\n\nYou have what you need here. But you need to do some modification. Like select the good width (your two colums will be closer if you choose a bigger number you can also choose to center the two colums...\n\n\nIf you go there: http://raymondfrancoeur.spaces.live.com/\nJust under the wmp you will see an exemple and the code ( i've only used html because live space doesn't take scipt)
587532
Try searching for it at http://www.planet-source-code.com/vb
1151425
it's been a while since i've used VB but give this a try\n\nIF (listbox.listitem[0].selected) AND (listbox.listitem[1].selected) THEN\nEND IF
762532
im not sure if there is a code \nfor double but there is one for single \nline\n<u>text you want underlined goes here</u>
325795
I don't think its an option from the menu. Ofcourse, VBA script can be written for that to happen.
743647
Dim i, total As Integer\ntotal = 0\nFor i = 0 To Integer.Parse(TextBox1.Text) Step 2\n     total += i\nNext\nMsgBox(total.ToString())
819071
yes use MS word types two in subscript then copy it over to you message