LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,836
Default Excel to Schedule Task in Outlook

I get this message:
Automation error. The specified module could not be found.

When I run this code:
Sub CreateTask()
Dim objApp As Outlook.Application
Dim objTask As Outlook.TaskItem

Set objApp = CreateObject("Outlook.Application")
Set objTask = objApp.CreateItem(olTaskItem)
With objTask
.Subject = "Subject"
.StartDate = CDate(ProximaFechaAcumulada) - CDate(15)
.DueDate = CDate(ProximaFechaAcumulada)
.Importance = olImportanceHigh

.Body = "Body" 'Here I need Right to Left

.Save
.ReminderSet = True
End With
End Sub

It fails on this line:
Set objApp = CreateObject("Outlook.Application")

I dont understand this behavior. I have checked the Reference to MS
Outlook Object Library on my system and Im having a problem with the code.
I tried to create a small tool to simplify things in our office, but it just
doesnt seem to work right. When I go to a few other machines in the office
it runs fine. I cant tell whats going on. Perhaps there is some kind of
esoteric setting that is different on my workstation... Id appreciate it if
someone could share some insight.


Regards,
Ryan--

--
RyGuy
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating Outlook Task from Excel Bugman Excel Programming 0 January 17th 08 02:26 PM
Searching for an Outlook Task from Excel scott56hannah Excel Programming 6 October 10th 07 01:05 PM
Sending task to Outlook from Excel [email protected] Excel Programming 0 April 23rd 07 11:09 AM
Sending a task from Excel to Outlook Pasty Excel Programming 0 March 28th 07 01:49 AM
import outlook task to excel stabekk Excel Programming 1 November 18th 03 06:01 PM


All times are GMT +1. The time now is 03:36 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"