N
news.microsoft.com
Hi All,
I use outlook task form to create an Excel Sheet
I fill cells with data from contact I found the why
to make text bold colored how to autofit colums to add filter
1) but I don't find the way to Add Borders....
2) I use an existing xls file to open excel how can I create a new xls
file
Sub Export_click()
Set objExcelApp = Item.Application.CreateObject("Excel.Application")
ObjExcelApp.Workbooks.Open("d:\test.xls")
Set ObjExcelBook = objExcelApp.ActiveWorkBook
Set ObjExcelSheets = objExcelBook.WorkSheets
Set ObjExcelSheet = objExcelBook.Sheets(1)
Tks
I use outlook task form to create an Excel Sheet
I fill cells with data from contact I found the why
to make text bold colored how to autofit colums to add filter
1) but I don't find the way to Add Borders....
2) I use an existing xls file to open excel how can I create a new xls
file
Sub Export_click()
Set objExcelApp = Item.Application.CreateObject("Excel.Application")
ObjExcelApp.Workbooks.Open("d:\test.xls")
Set ObjExcelBook = objExcelApp.ActiveWorkBook
Set ObjExcelSheets = objExcelBook.WorkSheets
Set ObjExcelSheet = objExcelBook.Sheets(1)
Tks