cell text formating after CopyFromRecordset

[darren1979]

Dear all,

I have write a vba code that can copy data from another excel spreadsheet.

But i have a problem to display the information properly.

Say example:

original Excel:

00001 (text format)
00002
00003
00004

after the VBA copyfrom recordset, it become:-

1 (numeric format)
2
3
4

Below are the codes, any vba code i can convert it to TEXT format while in the process CopyFromRecordset?? Please advice.

Please Login or Register  to view this content.

[mojo249]

Hi Darren

The trick is to set the format of the target cell as Text prior to entering the data into it. Try the following:

Please Login or Register  to view this content.

[DonkeyOte]

If the values are truly text @ source (ie 0001 and not 1 formatted with leading zeroes to appear as 0001) then you could perhaps try amending

Please Login or Register  to view this content.

to:

Please Login or Register  to view this content.

[darren1979]

thank you so much. It help alot..