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