I would like to read a string based on a db query (like select Names
from NameTable where Name Like '%James%') and take each resulting
string and devide then into different cells...

E.g. James Hansson - A1=James and B1=Hansson

How can this be done? I can get as far as using querytables and show
the results in the current sheet but thats not what I want.

//Ladyhawke

if James Hansson is in A1, then
=LEFT(A1,FIND(" ",A1)-1) will give you James and
=RIGHT(A1,LEN(A1)-FIND(" ",A1)) will give you Hansson

or you could use the Text to Columns feature.

--
Gary's Student


"ladyhawke" wrote:

I would like to read a string based on a db query (like select Names
from NameTable where Name Like '%James%') and take each resulting
string and devide then into different cells...

E.g. James Hansson - A1=James and B1=Hansson

How can this be done? I can get as far as using querytables and show
the results in the current sheet but thats not what I want.

//Ladyhawke

Ok, that will work if my string is in a cell...

I would like i VBA to fetch a string result from Database and split the
string before showing the data in cells...

Do you know how?

On 29 Jun 2006 02:36:09 -0700, "ladyhawke" wrote:

Ok, that will work if my string is in a cell...

I would like i VBA to fetch a string result from Database and split the
string before showing the data in cells...

Do you know how?

Use the SPLIT function in VBA


--ron

Had the same idea but I'm a newbie here and I don't even know how to
fetch the string directly from the VBA code instead of my current
roundtrip to a cell....


Ron Rosenfeld skrev:

On 29 Jun 2006 02:36:09 -0700, "ladyhawke" wrote:

Ok, that will work if my string is in a cell...

I would like i VBA to fetch a string result from Database and split the
string before showing the data in cells...

Do you know how?

Use the SPLIT function in VBA


--ron

On 30 Jun 2006 03:18:59 -0700, "ladyhawke" wrote:

Had the same idea but I'm a newbie here and I don't even know how to
fetch the string directly from the VBA code instead of my current
roundtrip to a cell....


Ron Rosenfeld skrev:

On 29 Jun 2006 02:36:09 -0700, "ladyhawke" wrote:

Ok, that will work if my string is in a cell...

I would like i VBA to fetch a string result from Database and split the
string before showing the data in cells...

Do you know how?

Use the SPLIT function in VBA


--ron

It's hard to advise as you give little information about what you are doing
now. How are you getting it into the cell now?


--ron