Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-08-2016, 04:19 PM
Weboh Weboh is offline Macro to convert table to convert table into iCalendar file? Windows 7 64bit Macro to convert table to convert table into iCalendar file? Office 2010 32bit
Novice
Macro to convert table to convert table into iCalendar file?
 
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 offline Macro to convert table to convert table into iCalendar file? Windows 7 64bit Macro to convert table to convert table into iCalendar file? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
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
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 12-08-2016, 09:08 PM
Weboh Weboh is offline Macro to convert table to convert table into iCalendar file? Windows 7 64bit Macro to convert table to convert table into iCalendar file? Office 2010 32bit
Novice
Macro to convert table to convert table into iCalendar file?
 
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, 8 views)
Reply With Quote
  #4  
Old 12-08-2016, 09:11 PM
macropod's Avatar
macropod macropod is offline Macro to convert table to convert table into iCalendar file? Windows 7 64bit Macro to convert table to convert table into iCalendar file? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
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
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 12-10-2016, 09:38 AM
Weboh Weboh is offline Macro to convert table to convert table into iCalendar file? Windows 7 64bit Macro to convert table to convert table into iCalendar file? Office 2010 32bit
Novice
Macro to convert table to convert table into iCalendar file?
 
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 offline Macro to convert table to convert table into iCalendar file? Windows 7 64bit Macro to convert table to convert table into iCalendar file? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
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
[Fmr MS MVP - Word]
Reply With Quote
Reply

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
Macro to convert table to convert table into iCalendar file? Macros to convert text to Table josia Word VBA 3 08-28-2015 09:11 PM
Macro to convert table to convert table into iCalendar file? Macro to convert word file into pdf cc9083 Word VBA 2 02-23-2015 01:22 AM
Macro to convert table to convert table into iCalendar file? Convert Spreadsheet to Database Table mebjen Excel Programming 1 11-15-2013 11:21 PM
Macro to convert table to convert table into iCalendar file? How to Convert a Table from PDF to Excel belly Excel 2 09-07-2011 06:26 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:47 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft