#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. |
#2
|
||||
|
||||
It would be helpful if you could attach an actual document to a post containing a table you want to convert. You can do that via the paperclip symbol on the 'Go Advanced' tab at the bottom of this screen.
It would also be appreciated if you could confirm which of the formats indicated at https://en.wikipedia.org/wiki/ICalendar you want as the output. It doesn't appear that the output is concerned with which day you regard as the first of the week.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Here's the table. You'll note that there are two tiny, empty cells in it that didn't carry over when I copied it here. Those are days I don't work, so they were empty on the schedule.
The output might not depend on which day is the first day of the week, (and I have my default first day of the week to be Sunday) but I want to be sure you know when you help me design the macro to make the first day in the table equal Saturday in the iCalendar file. I want the event title and calendar to be "work," the alarm to be "1 day," and location be the difference of the two "M" values, equaling either "1 hour" or "30 minutes." Thanks. |
#4
|
||||
|
||||
As I said before
Quote:
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
|||
|
|||
I'm not sure how to read that table. I thought I gave you what you needed in my last post.
Maybe "event description" would equal title (which I want to be "work") "Alarm action r-1" would equal alarm? (I want that to be "1 day") And calendar>location would be the difference between the M values in the table. Sorry, I'm not sure how helpful this will be since I'm less knowledgeable about iCalendar formats than most other people here would be. |
#6
|
||||
|
||||
I suspect not. I've never used (or even seen) the app, so I don't know which format is required. Converting the table to any of the required formats isn't difficult, but I don't want to try half a dozen different ones...
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Tags |
calendars, convert, thunderbird |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to convert table into multilevel list? | microsoftsloot | Word | 1 | 12-07-2015 10:55 PM |
Macros to convert text to Table | josia | Word VBA | 3 | 08-28-2015 09:11 PM |
Macro to convert word file into pdf | cc9083 | Word VBA | 2 | 02-23-2015 01:22 AM |
Convert Spreadsheet to Database Table | mebjen | Excel Programming | 1 | 11-15-2013 11:21 PM |
How to Convert a Table from PDF to Excel | belly | Excel | 2 | 09-07-2011 06:26 AM |