Copy From a "Object" to a single cell

Hi All,
I am new to macro and i have a code in which, declared an Object GradeDynaset. This stores the the result of SQL queries. I would like to know how can the content of this Object can be pasted inside a single cell. Currently, I am able to paste into only on multile cells (Each content occupies a sepearte cell)

Please Login or Register  to view this content.

It will be very helpful if some one comes for my help

i would loop the return and build off that.

Try something like this.

Please Login or Register  to view this content.

You may have to clean up the text in MyText to remove unwanted characters before putting it in B2.

Thanks for your response . I tried the above code but it din't work.

Error: Run time error 438
Message: Object dosenot support property or method

MyCode:

Please Login or Register  to view this content.

Using The Clipboard In VBA

Maybe this...

Please Login or Register  to view this content.

Thanks mate!! it workedd!! But I am not able to remove the junk characters which appaear. The character looks like a question mark inside a box...could you please help in this?

Originally Posted by fblaze

Thanks mate!! it workedd!! But I am not able to remove the junk characters which appaear. The character looks like a question mark inside a box...could you please help in this?

Determine which ASCII character it is (may be more than one type of character). It could be any one of the 30 or so non-printable characters at the start of the ASCII Table.

Then you could replace the character with nothing (this example replaces ASCII character 3)
MyText = Replace(MyText, Chr(3), "")

Thanks it worked!!