|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
November 14th 06, 01:17 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
Outlook 2k3 Script: Creating Borders in Excel
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 
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Outlook 2k3 Script: Pb While exporting to Excel | news.microsoft.com | Outlook and VBA | 1 | November 14th 06 05:24 PM |
| Outlook 2k3 Script: ProgressBar while exporting ??? | bbnimda | Outlook and VBA | 2 | November 13th 06 08:26 AM |
| Outlook 2k3 Script: Ordering a combo | news.microsoft.com | Outlook and VBA | 1 | November 10th 06 04:05 PM |
| Outlook 2k3 Script: Exporting Task item to Excel | news.microsoft.com | Outlook and VBA | 5 | November 8th 06 04:01 PM |
| Outlook 2k3 RPC over HTTP Script | vzerbonia | Outlook - Installation | 0 | July 27th 06 07:35 PM |
Threaded Mode