Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Word VBA

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 12-08-2016, 04:19 PM
Weboh Weboh is offline Windows 7 64bit Office 2010 32bit
Novice
 
Join Date: Dec 2016
Posts: 3
Weboh is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 12-08-2016, 05:15 PM
macropod's Avatar
macropod macropod is online now Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 16,342
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

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
[MS MVP - Word]
Reply With Quote
  #3  
Old 12-08-2016, 09:08 PM
Weboh Weboh is offline Windows 7 64bit Office 2010 32bit
Novice
 
Join Date: Dec 2016
Posts: 3
Weboh is on a distinguished road
Default

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.
Attached Files
File Type: doc Macro.doc (25.0 KB, 1 views)
Reply With Quote
  #4  
Old 12-08-2016, 09:11 PM
macropod's Avatar
macropod macropod is online now Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 16,342
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

As I said before
Quote:
Originally Posted by macropod View Post
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.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #5  
Old 12-10-2016, 09:38 AM
Weboh Weboh is offline Windows 7 64bit Office 2010 32bit
Novice
 
Join Date: Dec 2016
Posts: 3
Weboh is on a distinguished road
Default

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.
Reply With Quote
  #6  
Old 12-10-2016, 03:07 PM
macropod's Avatar
macropod macropod is online now Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 16,342
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Quote:
Originally Posted by Weboh View Post
I'm less knowledgeable about iCalendar formats than most other people here would be.
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
[MS MVP - Word]
Reply With Quote
Reply

Tags
calendars, convert, thunderbird
Please reply to this thread with any new information or opinions.

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


All times are GMT -7. The time now is 02:21 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft