+ Reply to Thread
Results 1 to 2 of 2

Help using external data - ics

  1. #1
    Registered User
    Join Date
    04-19-2019
    Location
    Netherlands
    MS-Off Ver
    Office 365
    Posts
    1

    Question Help using external data - ics

    Hi there!

    I'm currently trying to establish a data connection to an online ICS calendar file. So far, all I've been able to retrieve is the actual text that's in the ICS file, but not the appointments contained within. Unfortunately I don't have the abaility to change the way this calendar is published, so I can't just change it to a CSV or something along those lines. Downloading the file and converting it is not an option since the data changes all the time.

    Does anyone know of any solutions to this? Any add-ons that might load the calendar data easily? Or can it be achieved using native excel features?

    Thanks in advance!

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,780

    Re: Help using external data - ics

    PowerQuery, maybe?

    This is for PowerBI, but the M code should work in the PQ editor in Excel 365: https://community.powerbi.com/t5/Des...ar/td-p/494667
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Cell variable in external external link (hlookup fuction)
    By DorianGrim in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-16-2016, 03:11 AM
  2. External Data from Microsoft Query - Excel File - Causes external file to open.
    By lee1000d in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-25-2015, 02:25 PM
  3. Replies: 0
    Last Post: 09-09-2013, 10:44 AM
  4. Excel 2007 : External Data Warning but there is no External Data
    By Cass_makeitfun in forum Excel General
    Replies: 2
    Last Post: 09-13-2010, 11:53 AM
  5. Replies: 0
    Last Post: 04-05-2006, 06:10 AM
  6. Need advice : consolidating data from multiple CSV files in Excel - External data handling
    By Matthieu Gaillet in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-01-2005, 05:10 AM
  7. [SOLVED] “Import External Data:Import External Data
    By Jeff in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-03-2005, 06:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1