Recent content by Ron Legg

  1. R

    Exporting Excel data to Outlook 2016 Calendar

    Eureka! I used the SMTP address which removed the space in the calendar name and it resolved and loaded my test data. This is a big step forward for me and I am very grateful for your sound advice with this.
  2. R

    Exporting Excel data to Outlook 2016 Calendar

    Hi, I followed that advice and downloaded the address book via the Send/Receive Groups option. The VBA doesn't return any errors now however the message box indicates that the shared calendar from the address book still isn't resolved. I may be wrong but this issue could be the way that the...
  3. R

    Exporting Excel data to Outlook 2016 Calendar

    Many thanks Diane There were no red entries and I will ask my ICT guys to sync my address book as the code should now work following this.
  4. R

    Exporting Excel data to Outlook 2016 Calendar

    Hi Diane Yes your prediction is correct, it did fail and didn't resolve and therefore I'm thinking that maybe it's the way our ICT support set up the shared calendar. It looks like the code would work but the calendar is in some way badly configured. Are there any rules we need to be aware of...
  5. R

    Exporting Excel data to Outlook 2016 Calendar

    Hi Changed as suggested - getting closer I think. Just getting this now: Latest code Public Sub CreateOutlookAppointments() Sheets("Sheet1").Select On Error GoTo Err_Execute Dim olApp As Outlook.Application Dim olAppt As Outlook.AppointmentItem Dim blnCreated As Boolean...
  6. R

    Exporting Excel data to Outlook 2016 Calendar

    Hi Yes, I did it right at the beginning of this project
  7. R

    Exporting Excel data to Outlook 2016 Calendar

    Hi Diane I tried the new code and received this error: This is the revised code in my latest attempt: Public Sub CreateOutlookAppointments() Sheets("Sheet1").Select ' On Error GoTo Err_Execute Dim olApp As Outlook.Application Dim olAppt As Outlook.AppointmentItem Dim...
  8. R

    Exporting Excel data to Outlook 2016 Calendar

    Hi Diane Thanks very much for getting back to me. I've tried all the suggested ways of connecting to my shared calendar and am currently using the second macro at Create Appointments Using Spreadsheet Data however I'm getting the 'An object could not be found' error when using: Set Items =...
  9. R

    Exporting Excel data to Outlook 2016 Calendar

    Hi I'm building up some VBA based on Diane's examples in http://www.slipstick.com/developer/create-appointments-spreadsheet-data/ and making good progress. I'm using Excel 2016 and Outlook 2016. Diane's export VBA from Excel to Outlook works fine with a newly created local calendar under 'My...
Top