Macro to convert table to convert table into iCalendar file?


  1. Posts : 112
    Windows 7 Ultimate x64
       #1

    Macro to convert table to convert table into iCalendar file?


    First off, yes I want an iCalendar vs an Outlook calendar file because, heresy of heresies, I prefer Thunderbird to Outlook. Moving on...

    My work doesn't offer an option to download the weekly schedule as a file, and my schedule changes so often that each week I have a whole schedule to plug in. I'd like to automate the process. Pulled directly from the clipboard, the table looks like this: EDIT: this forum doesn't seem to keep tables and wants it vertical like this. Just imagine the text is in a horizontal table.

    12:30 pm - 07:15 pm
    Front Service Clerk
    M: 04:00 pm - 04:30 pm


    06:30 am - 11:15 am
    Front Service Clerk

    01:15 pm - 11:00 pm
    Front Service Clerk
    M: 06:00 pm - 07:00 pm

    12:00 pm - 03:00 pm
    Front Service Clerk

    08:00 am - 02:45 pm
    Front Service Clerk
    M: 10:15 am - 10:45 am



    Is there a way to make a macro to pull the time and put it into the time section of an iCalendar file, pull the "M" and put it into the "location" section, while ignoring the "Front service clerk" section? Important: Saturday is the first day of the week. Also, days I don't work are blank and get copied into the table. Any way to fix that? Preferably it'd then save it as an .ics file, but it can just put it out in ics format and I can change the file extension.
    Thanks.
      My Computer


  2. Posts : 9,746
    Windows 7 Home Premium 64 bit sp1
       #2

    Is this what you are looking for converting a table, I assume you are referring to an Excel spreadsheet to an Apple icalendar file.

    https://n8henrie.com/2012/07/import-...ule-of-events/
      My Computer


 

  Related Discussions
Our Sites
Site Links
About Us
Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd
All times are GMT -5. The time now is 08:43.
Find Us