Results 1 to 4 of 4

Thread: Using Excel WebApp In The Forum

  1. #1
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,195
    Articles
    57
    Blog Entries
    14

    Post Using Excel WebApp In The Forum



    Register for a FREE account, and/
    or Log in to avoid these ads!

    At the last MVP summit we were shown some great examples of the new Excel WebApp. After seeing that I immediately went and updated a few pages on my website to make them as interactive as possible.

    Since this is a help forum, I think this could be a very valuable tool to help demonstrate things to our question askers as well.

    One challenge with the WebApp though, is that runs in an iFrame. Due to security, I didn't really want to allow just any iFrame on my site, so I've created some BB Code tags specific to the Microsoft webapp. These tags will allow you to embed a file right into the forum web pages.

    Here's how they work...


    Assume you have uploaded your file to your Windows Live SkyDrive account.
    • Make sure the file is in a shared folder.
    • Navigate in SkyDrive to the file, but don't open it.
    • Hold your mouse over the file name, and a bar should pop up.
    • Navigate to More --> Share --> Embed

    Name:  embed.jpg
Views: 84
Size:  17.3 KB
    • Copy the code from the embed window.
    For this example, we'll assume the code is as follows:
    Code:
    <iframe src="http://r.office.microsoft.com/r/rlidExcelEmbed?su=-8493146133887032856&Fi=SD8A224897002E61E8!258&AllowInteractivity=False" width="402" height="346" frameborder="0" scrolling="no"></iframe>
    What we're going to do is copy everything from between the ?su- and the &Allow. In other words:
    Code:
    8493146133887032856&Fi=SD8A224897002E61E8!258
    Now we'll insert it between [EmbedFile] [/EmbedFile] tags, like this:

    [EmbedFile]8493146133887032856&Fi=SD8A224897002E61E8!258[/EmbedFile]

    Once you submit your post, it will look like this!


    I have also added a set of [EmbedItem] [/EmbedFile] tags if you'd like to show just a specific item from your file. (A defined range, pivot table or chart, for example.)

    The method to get your iFrame code is the same as above. The code below comes from a file that has a chart named "Chart 1":
    Code:
    <iframe src="http://r.office.microsoft.com/r/rlidExcelEmbed?su=-8493146133887032856&Fi=SD8A224897002E61E8!265&AllowInteractivity=False" width="402" height="346" frameborder="0" scrolling="no"></iframe>
    With tags it would look like this:
    [EmbedItem=Chart 1]8493146133887032856&Fi=SD8A224897002E61E8!265[/EmbedItem]

    And when used would yield:


    I will be writing up some articles on how to use Windows Live SkyDrive and the Excel WebApp over the next while. Hopefully you can find this useful!
    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Master your data with Power Query: Purchase your copy of my book M is for Data Monkey today!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  2. #2
    Very cool stuff Ken.

  3. #3
    Seeker XL-Dennis's Avatar
    Join Date
    Mar 2011
    Location
    Östersund, Sweden
    Posts
    12
    Articles
    0
    Nice Ken, very nice :-)

    The following URL point to the MSFT's pages about using WebApps and SkyDrive: http://office.microsoft.com/en-us/we...101231889.aspx

    If I understand it correctly also older versions of the Office suite can communicate with WebApps.
    Kind regards,
    Dennis

    .NET & Excel | 2nd edition PED | MVP

  4. #4
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,195
    Articles
    57
    Blog Entries
    14
    Thanks Dennis!

    Re the webapp, we actually were discussing that over here.
    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Master your data with Power Query: Purchase your copy of my book M is for Data Monkey today!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

Tags for this Thread

Posting Permissions

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