I have an excel worksheet that is used to populate an outlook calendar, i have my code putting the startdate into the appointment but i want to hard code the time in the code as the following:
.Start = arrAppt(i, 7) + "09:00"
The date from the worksheet column 7 is sent the calendar but i cant same to set the time. Can anyone help?
Hello DB4284,
Assuming the arrAppt(i, 7) is a date, you need to convert the time string to a time value.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks