Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: Macro to convert table to convert table into iCalendar file?

08 Dec 2016   #1

Windows 7 Ultimate x64
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.

My System SpecsSystem Spec
08 Dec 2016   #2

Windows 7 Home Premium 64 bit sp1

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

 Macro to convert table to convert table into iCalendar file?

Thread Tools

Similar help and support threads
Thread Forum
How to Convert MBR Partition to GPT Partition Table on 4Tbt HD
I have cloned a logical partition with valuable data from an MBR partition from one HD to a new 4Tbt HD. Now I realise that I am stuck with a 2 Tbt partition limit if I leave it as a MBR partition. Is it possible just to convert from an MBR to a GPT partition without deleting the partitions and...
Hardware & Devices
Master File Table Size?
I remember seeing a tweak about changing the MFT from the default DWORD 1 (12.5%) up to 4 (50%), but this was a long time ago. I'd assume changing it's size has some effect on system speed if you were closing in on max space, but lets say on an SSD would it even be wise to consider changing it's...
Performance & Maintenance
Master file table corrupt
Hello, I purchased a 1 TB Seagate Hard Disc about four months ago.It has two Partitions One 50 GB with Windows 7 New and other a 950 GB with movies,music important documents etc.I also have two more Internal Hard discs with Windows 8 and another windows 7.For last one week or so had problems in...
General Discussion
File table rebuilding software?
Ok, i've a 1TB drive, pretty full with music, and its lost both file tables when the system crashed during a defrag :/ Windows reports the drive corrupt and unreadable, and thus, cannot open it. chkdsk reports it as a ntfs drive, but cannot continue. damage is beyond its capabilities. Spinrite...
Hardware & Devices

Our Sites

Site Links

About Us

Find 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 06:28.
Twitter Facebook Google+