|
| 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 29th 06, 12:04 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
Outlk 2k3 Script: Closin an opened Excel
Hi All,
From an outlook script I launch Excel and fill I with data extracted from my Task then I display It Set objExcelApp = Item.Application.CreateObject("Excel.Application") here is my code ObjExcelApp.Workbooks.Add Set ObjExcelBook = objExcelApp.ActiveWorkBook Set ObjExcelSheets = objExcelBook.WorkSheets - - - objExcelSheet.Activate objExcelApp.Application.Visible = True Now I want To know how to close Excel Tks 
|
|
#2
November 29th 06, 03:54 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Outlk 2k3 Script: Closin an opened Excel
ObjExcelApp.Quit
-- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Absolute Beginner's Guide to Microsoft Office Outlook 2003 Reminder Manager, Extended Reminders, Attachment Options http://www.slovaktech.com/products.htm "news.microsoft.com" wrote in message ... Hi All, From an outlook script I launch Excel and fill I with data extracted from my Task then I display It Set objExcelApp = Item.Application.CreateObject("Excel.Application") here is my code ObjExcelApp.Workbooks.Add Set ObjExcelBook = objExcelApp.ActiveWorkBook Set ObjExcelSheets = objExcelBook.WorkSheets - - - objExcelSheet.Activate objExcelApp.Application.Visible = True Now I want To know how to close Excel Tks
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Outlk 2k3 Script: HtmlMail | news.microsoft.com | Outlook and VBA | 4 | November 29th 06 12:52 PM |
| Outlk 2k3 Script: Saving Excel File programticaly from OUTLOOK SCRIPT | news.microsoft.com | Outlook and VBA | 3 | November 22nd 06 04:33 PM |
| Outlk 2k3 Script: Find and findNext use | news.microsoft.com | Outlook and VBA | 1 | November 21st 06 03:44 PM |
| Outlk 2k3 script: How to get the name of the month | news.microsoft.com | Outlook and VBA | 2 | November 21st 06 03:35 PM |
| Outlk 2k3 Script: Pb Using Find function Help plz!!! | news.microsoft.com | Outlook and VBA | 1 | November 15th 06 04:40 PM |
Hybrid Mode
