Creating calendar entries in outlook from VB userform/excel

[philfloyduk]

I have a repair booking form in visual basic that feeds in to an excel sheet that I would like to automatically create calendar entries in outlook. Ideally, the next free hourly slot would be taken (our repairs are put on to the day then organised in the morning). The form has a textbox that the user enters the appointment date in via calendar control 12.0. The form currently populates all the information needed from the text boxes in to a cell, copies the information then prompts the user to paste it to the Calendar.

Many thanks in advance for any help


Phil.

 

[Ruddles]

Goodness, this was nearly three years ago! Praedico's suggestion sounds sensible though. I seem to recall the original code was written for someone who was dealing only in half-hour slots.

 

[wazimu13]

hi there! yes i realize this post is old but you guys did a fine job.The moment i saw the code
my eyes lit up as i think it looks like it would solve the exact problem i have

Praedico, that sounds like what i need. Please post the code so i can try run it. mucho gracias!

 

[wazimu13]

Wazimu13,
I don't remember too much about this - after I get something working I tend to purge it from my brain and move on to the next thing. However I do have the text from a message I sent to Ruddles after I got it working.

Here it is:


I hope that helps you,
Praedico

Hi Praedico, that sounds like what i need. Please post the code so i can try run it. mucho gracias!

 

[wazimu13]

hi, ive tried changing argduration to oapptitem.duration as suggested, but i still have the same problem
It doesn't recognize/pickup the end time of an existing appointment that was not created by this code.
thanks