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

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - How to set the format of a cell in excel through vb6 (https://www.excelbanter.com/excel-programming/357016-how-set-format-cell-excel-through-vb6.html)

Camper Joe

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

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.

[email protected]

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

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

Stefi

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

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

Regards,
Stefi

€žCamper Joe€ ezt Ã*rta:

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.

Camper Joe

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

Thanks.

That makes perfects sense.

Also, thanks on the previous post.

"Stefi" wrote:

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

Regards,
Stefi

€žCamper Joe€ ezt Ã*rta:

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.

All times are GMT +1. The time now is 07:49 PM.