Visual Basic and excel

[Moving Shadow]

Anyone here a VBA/excel whiz?

I am trying to pull a date from a cell in an excel worksheet and make it as a task item in Outlook.    Every time I run this  VBA macro in excel, the date pulled into the tasks list will default to Fri 12/29/1899.  Can any one shed some light one this? 

Below is the code:

Sub Create_Task()

Dim olApp As Outlook.Application
Dim olTask As Outlook.TaskItem

Set olApp = New Outlook.Application
Set olTask = olApp.CreateItem(3)

Application.ScreenUpdating = False

With olTask
.Subject = "Do this Now"
.Body = "You need to do this"
.StartDate = Range("A2").Select
.DueDate = Range("B2").Select
.Status = olTaskWaiting
.Importance = olImportanceHigh
.ReminderPlaySound = True
.Companies = "Your Moml"
.Save
End With

Set olTask = Nothing

Set olApp = Nothing

Application.ScreenUpdating = True

MsgBox "The task-list updated successfully.", vbInformation

End Sub

[[BTF]RottenRose]

I'm not a wiz and I feel pitty on anyone that is when it comes to vb. Could you may be add some notes so others and I can try to understand what you're trying to do with your code. I can read your code, but I don't totally know what you're trying to do with it. You might want to check and see if you skipped a step or mispelled something, vb will chew you up I know if you do something like that.

[Moving Shadow]

I got figured out.

.StartDate = Range("A2").Select should have been .StartDate = Range("A2").Value

weehaw.  Thanks anyways Rose!

[peewee_RotA]

VBA in excel is like sugar in a gas tank. Especially since porting ANYTHING in excel written in VBA requires lowering the standard "security" settings, the installation of a valid certificate, and the constant reminder that you're running scripts. And not the least of which is the fact that VBA scripts cannot run in Excel Viewer, which would be their only real function.


For example if I have a spread sheet listing part numbers and their OEM part numbers and create a script to help sort them. I cannot distribute this script without purchasing a new and most recent copy of Excel for every computer I want to view this on.

I could ramble for hours. Basically VBA is great for Outlook but a waste for everything else.

[Moving Shadow]

ok this may be a simplier question. I'd like to take the code that I have above, and use it for different tasks.  Is there anyway to do that?  Right now, it will only import 1 startdate and one due date... I'd like to do more.

Any suggestions?

[jägermonsta]

www.google.com