Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can any body help me out?
In My VBA coding i used to get long string with comma seperated. I
there any API to read that string and parse into the excel sheet. I am using excel 2000 Thanks Venkatesh -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can any body help me out?
Put it in a cell, then do Data=Text to Column
Turn on the macro recorder while you do it manually. -- Regards, Tom Ogilvy "kvenku " wrote in message ... In My VBA coding i used to get long string with comma seperated. Is there any API to read that string and parse into the excel sheet. I am using excel 2000 Thanks Venkatesh. --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can any body help me out?
You can try the Split Function. It creates an array then allows you to parse
out the string and input it into the sheet as need be. ----------------------------------------------------------------------------------- Split Function Description Returns a zero-based, one-dimensional array containing a specified number of substrings. Syntax Split(expression[, delimiter[, limit[, compare]]]) The Split function syntax has these named arguments: Part Description expression Required. String expression containing substrings and delimiters. If expression is a zero-length string(""), Split returns an empty array, that is, an array with no elements and no data. delimiter Optional. String character used to identify substring limits. If omitted, the space character (" ") is assumed to be the delimiter. If delimiter is a zero-length string, a single-element array containing the entire expression string is returned. limit Optional. Number of substrings to be returned; €“1 indicates that all substrings are returned. compare Optional. Numeric value indicating the kind of comparison to use when evaluating substrings. See Settings section for values. "kvenku " wrote: In My VBA coding i used to get long string with comma seperated. Is there any API to read that string and parse into the excel sheet. I am using excel 2000 Thanks Venkatesh. --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Emaling(as body) | Excel Discussion (Misc queries) | |||
Please any body help me.i need help as soon as possible | Excel Discussion (Misc queries) | |||
Any body help me out with this? | Excel Discussion (Misc queries) | |||
Can any body help? | Excel Programming | |||
Can any body help? | Excel Programming |