| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to set the format of a cell in excel through vb6
Range("A1").Value = "test"
|
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cell format - remove cell format pattern without effecting colors | Excel Discussion (Misc queries) | |||
| Does Excel have a cell format for lat/long in Ā° min sec format? | Excel Discussion (Misc queries) | |||
| Can Excel 2003 cell link carry with it the source cell format? | Excel Discussion (Misc queries) | |||
| Excel Auto-Format cell to email format | Excel Discussion (Misc queries) | |||
| cell format for date/time in same cell excel 2003 | Excel Worksheet Functions | |||
Linear Mode
