Results 1 to 4 of 4

Thread: Excel integration add-in

  1. #1

    Excel integration add-in



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

    I have been involved in helping create an Excel integration add-in at Metric-X, http://www.metricx.com, and it is called XLhub, http://www.metricx.com/xlhub-excel-integration.

    This tool allows information to be written to a database so it can be shared easily between other users, without the hassle of sending emails, cutting and pasting, and having to save multiple versions of the same file. This works because data from Excel is saved into a database where multiple users can connect, save, and retrieve information that has been stored. Each time a version is saved to the database, or hub as we call it, it is immediately available to all authorized users, so the most up-to-date information is available, eliminating the worries that a change will be made and not known right before a deadline.

    This data, along with other sources (SSRS, Crystal Reports, etc.) can be pulled into an Excel file, or other BI tool so that forecasting, budgeting,and status reports are up to the minute.

    To see more information go to the http://www.metricx.com/xlhub-excel-integration. A free trial is now available to start using, you can download it at http://www.metricx.com/xlhub-excel-integration/demo.

    What are everyone’s thoughts on this?

    Thanks,
    Martin Perrine

  2. #2
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,189
    Articles
    57
    Blog Entries
    14
    I'm curious to have a look at this one in a little more detail. Sounds kind of like what I've been doing for years with VBA, Access databases and Excel templates, but I'm curious on the "Version control" part that is listed in your graphics.

    I'm a few weeks away from having the time to look seriously at this though. If I don't ping back in it within 3 weeks though, feel free to post back and revive the thread.
    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.

  3. #3
    The version control in XLhub is pretty slick. Have you had a chance to take a peak at it yet? We had been using it here for timesheets. It works really well for forecasting scenarios as well. It's nice to be able to edit the source data, view changes and save a new scenario and always be able to revert back to orginal data or compare several different scenarios with a few clicks.

  4. #4
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,189
    Articles
    57
    Blog Entries
    14
    Haven't had a chance as yet, no.
    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.

Posting Permissions

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