hobbes2103
Active member
- Joined
- Jul 10, 2003
- Messages
- 43
I have the following code to write into an existing Excel file :
Dim xlApp As Excel.Application
Dim xlbook As Excel.Workbook
Dim xlsheet As Excel.Worksheet
xlapp = New Excel.Application
xlbook = xlApp.Workbooks.Open("C:\MyFile.xls")
xlsheet = xlApp.Sheets(1)
xlsheet.Name = "Ma Feuille Excel"
xlsheet.Range("A1").Value = "Bienvenue"
Now I would like to do things such as drawing a frame on the cell, or changing the font or size of the text...
How do i do that?

Dim xlApp As Excel.Application
Dim xlbook As Excel.Workbook
Dim xlsheet As Excel.Worksheet
xlapp = New Excel.Application
xlbook = xlApp.Workbooks.Open("C:\MyFile.xls")
xlsheet = xlApp.Sheets(1)
xlsheet.Name = "Ma Feuille Excel"
xlsheet.Range("A1").Value = "Bienvenue"
Now I would like to do things such as drawing a frame on the cell, or changing the font or size of the text...
How do i do that?
