Export and analyze your own data in Excel

12467…15

Replies

  • ZealousMissJJ
    ZealousMissJJ Posts: 454 Member
    Bump :)
  • EvgeniZyntx
    EvgeniZyntx Posts: 24,208 Member
    I'm getting an error that says macros are corrupt...the popup never comes up at all. Office 2007 and I have IE 10.

    For those having the macros corrupt message it is likely that VBA is not installed in 2007. This is an option in the office / excel suite.
    See here:
    http://www.excelforum.com/excel-programming-vba-macros/822897-excel-corrupt-macro-message.html


    Can you go to add/remove program in system and modify your installation to enable VBA? It's an optional install.
    Add it and see if that solves the issue.
  • vfowlergt
    vfowlergt Posts: 15
    bump :)
  • susanb_16
    susanb_16 Posts: 131 Member
    bump
  • Razzzzle
    Razzzzle Posts: 40 Member
    bump
  • samammay
    samammay Posts: 468
    Version 9 is still hanging for me.
  • Spartan_1_1_7
    Spartan_1_1_7 Posts: 132 Member
    When I try to download - I keep getting the message "Invalid download link" :( Anybody else face this issue?
  • blackNBUK
    blackNBUK Posts: 58 Member
    Nerd alert

    Naaawh, it's not done in C# ;)

    Now, if he developed web app with a sql database back end and imported the data in on the other hand... ;)

    Nice stuff, though the download link is dead, anyone else upload it please? =)

    New version

    http://bit.ly/HhXhfF

    I've done web apps, and more dev languages than I can think of but I do not want to do this on a web service because I don't want to store people's data.

    I've seen that a few people have issues with exporting the weight data so I will look into that.

    When I discovered that you could get data out through the XML graphs I did wonder about writing a browser extension to do the TDEE calculation. Of course I didn't do anything about it! A browser extension should be able to present a nice UI without needing to store any data anywhere. It might also be able to use the browser's login so entering a username and password wouldn't be necessary.
  • dominiqueruns
    dominiqueruns Posts: 82 Member
    thanks so much for this!
  • Razzzzle
    Razzzzle Posts: 40 Member
    Is it just me that cant get it to work?

    Doesnt pull in any of my food or cals etc?

    Getting:


    20/10/2013
    21/10/2013
    22/10/2013
    23/10/2013
    24/10/2013
    25/10/2013
    - or -
    Username:
    Password:
    Remember me next time
    Forgot password or username?
    Not a member yet? Sign up now!



    I have my username in the setup tab and also leave the browser open and then come back to excel and download
  • KeriA
    KeriA Posts: 3,345 Member
    bump
  • randomtai
    randomtai Posts: 9,003 Member
    Bump to try this as my inner nerd loves graphs and spreadsheets :bigsmile:
  • sympha01
    sympha01 Posts: 942 Member
    Bump.
  • dacspace
    dacspace Posts: 109 Member
    Can't wait to try this out! Thank you for sharing!
  • shrinkinginQualicum
    shrinkinginQualicum Posts: 131 Member
    Bump. Not sure if this is toooooo much info for me, but will check it out. Thanks for sharing your work!
  • moksumike
    moksumike Posts: 30 Member
    Thanks!
  • Lonestar5775
    Lonestar5775 Posts: 740 Member
    Bump
  • nicoleisme
    nicoleisme Posts: 97 Member
    Bump, Great idea!
  • hypallage
    hypallage Posts: 624 Member
    your screen shots look great - i can't download though - will try in ie later
  • SideSteel
    SideSteel Posts: 11,068 Member
    Oh snap.

    Tagging this.
  • FredDoyle
    FredDoyle Posts: 2,272 Member
    Thanks.
    In to look at VBA.
  • EvgeniZyntx
    EvgeniZyntx Posts: 24,208 Member
    Nerd alert

    Naaawh, it's not done in C# ;)

    Now, if he developed web app with a sql database back end and imported the data in on the other hand... ;)

    Nice stuff, though the download link is dead, anyone else upload it please? =)

    New version

    http://bit.ly/HhXhfF

    I've done web apps, and more dev languages than I can think of but I do not want to do this on a web service because I don't want to store people's data.

    I've seen that a few people have issues with exporting the weight data so I will look into that.

    When I discovered that you could get data out through the XML graphs I did wonder about writing a browser extension to do the TDEE calculation. Of course I didn't do anything about it! A browser extension should be able to present a nice UI without needing to store any data anywhere. It might also be able to use the browser's login so entering a username and password wouldn't be necessary.

    Try it. I decided I like working off-line and the meal data is not available through the XML interface.
  • EvgeniZyntx
    EvgeniZyntx Posts: 24,208 Member
    I'm getting an error that says macros are corrupt...the popup never comes up at all. Office 2007 and I have IE 10.

    For those having the macros corrupt message it is likely that VBA is not installed in 2007. This is an option in the office / excel suite.
    See here:
    http://www.excelforum.com/excel-programming-vba-macros/822897-excel-corrupt-macro-message.html


    Can you go to add/remove program in system and modify your installation to enable VBA? It's an optional install.
    Add it and see if that solves the issue.

    If you are having issue, please make sure that VBA is installed in your version of Excel. It is an option.
    Go to add/remove programs and update the Excel Install, choose VBA, yes.

    ETA: Also please set your diary to public during the extract.
  • Ribena145
    Ribena145 Posts: 201 Member
    bumpity bump bump
  • aylajane
    aylajane Posts: 979 Member
    You also have to set your diary to public! If you just get dates and no macros or calories when running, that is likely it! Thanks - this is awesome!
  • alphal0b0
    alphal0b0 Posts: 125 Member
    BUMP!
  • CountryGirl8542
    CountryGirl8542 Posts: 449 Member
    bump
  • darkestdayz
    darkestdayz Posts: 117 Member
    Calories worked in v6 but couldn't get the weight data. No calories in v9 and none of the weight import works. The third button won't even let me log into MFP, just runs a xml code string. The 2nd button just hangs and the 1st does nothing.
  • markdlennon
    markdlennon Posts: 69 Member
    wanting to check this out at home.

    Thanks OP.
  • jeicorsair
    jeicorsair Posts: 7 Member
    You also have to set your diary to public! If you just get dates and no macros or calories when running, that is likely it! Thanks - this is awesome!

    That did the trick for me. Thanks for this great tool, OP!

Categories