How to set the format of a cell in excel through vb6

[Guest]

Hi.

I want to set the format of a cell in excel throug vb6.

Already created the excel.application object (xl)m and created workbook.

How would I do it. I would like to set it to text.

Thanks.

 

[MSRoach]

Range("A1").Value = "test"

 

[Guest]

Record the formatting operation as a macro, edit it, and you will see it!

Regards,
Stefi

„Camper Joe†ezt írta:

 

[Guest]

Thanks.

That makes perfects sense.

Also, thanks on the previous post.