Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi guys,
I am trying to create a task from a commandbutton in a userform. This is what I got so far: Sub CreateTask() Dim oApp As Object Set oApp = CreateObject("Outlook.Application") Dim objTask As Object Set objTask = oApp.CreateItem(olFolderTasks) With objTask .Subject = "Test" .Body = "Test" .DueDate = DateValue("06/26/03") .Startdate = DateValue("06/26/03") .Send .Close olSave End With Set objTask = Nothing End Sub Obviously it is not working as I get a runtime error "Object does not support the object or method" at the "duedate. Can anyone help me with the correct code? Thanks Albert |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
create outlook task from excel | Excel Programming | |||
How do I create a task from conditional formatting? | Excel Worksheet Functions | |||
create a drop down list that performs a task | Excel Discussion (Misc queries) | |||
how do i create a completion of task checklist | Charts and Charting in Excel | |||
Is it possible to create a custom Task Pane view? | Excel Programming |