Outlook 2k3 Script: Creating Borders in Excel

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
 
K

Ken Slovak - [MVP - Outlook]

Excel questions are probably best asked in an Excel group, not Outlook.

That said, use WorkSheets.Add to add a new sheet. Use the Borders property
to add and set borders to a selected Range.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top