Setting status on a task from excel

jcg31 · #1 09-09-2011, 07:52 PM

I am creating an app in excel and want to establish the status of a task based upon how the status is represented in the cell on the sheet. As an example Cell A17="Not Started" At the moment I am using a select statement

Code:

           Select Case Trim(Worksheets(shtName).Cells(17,1))
           Case Is = "Not Started"
           .Status = 0 'olTaskComplete
           Case Is = "In Progress"
           .Status = 1 ' olTaskInProgress
           Case Is = "Completed"
           .Status = 2
           Case Is = "Waiting on someone else"
           .Status = 3 'olTaskWaiting
           Case Is = "Deferred"
           .Status = 4 'olTaskDeferred
           End Select

but would prefer just to read the status from the cell as in

Code:

 With olTask
.Status = Trim(Worksheets(shtName).Cells(17,1))

but that doesn't work. Is there a property that I can use to assigning the string "Completed" to a task?

Thanks for any help.
Jim

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel 2007 to Outlook 2007 - task import possible?	mjwillyone	Outlook	2	07-05-2023 07:23 AM
VBA code to export individual task lists to Excel	OTPM	Excel Programming	0	05-24-2011 12:23 PM
how to make the task starts next day if no time enough today(task can not be split)	duraid	Project	1	10-25-2010 08:31 AM
Sending 1 message but status bar says 1 of 4...	baldmancan	Outlook	4	03-06-2009 12:04 PM
Document status changes to read only	rtankersley	Word	0	10-01-2008 05:15 AM