VIDEO: How to use Xcelsius 2008 with VBA!

Ever wanted to use VBA with Xceslius?  How about pivot tables? Well, you can!

I  put together a video to show you how integrating Xcelsius into Excel and Access, enables you to:

  • Utilize existing Microsoft Office solutions to extend the capabilities of Xcelsius.
  • Utilize familiar Office environment as primary platform
  • Take advantage of core Office features such as PivotTables
  • Extend VBA to your Xcelsius models
  • Simplify the data transfers to your Xceslius models

See video below or click here to see in browser.

If the video is too small in your browser click here to view.

Mike Alexander is the author of several books on advanced business analysis, including Crystal Xcelsius For Dummies. You can find Mike at www.datapigtechnologies.com, where he serves as principle contributor and shares free video tutorials with the Microsoft Office and Xcelsius communities.

Tags: , ,

6 Responses to “VIDEO: How to use Xcelsius 2008 with VBA!”

  1. Don Gibson says:

    This seems like a great solution but the video seems to have a problem. It stops halfway through right when it gets to the good part.

  2. Mico Yuk says:


    We have received similar complaints and we are working to resolve ASAP. Sorry for the inconvenience.


  3. [...] This post was mentioned on Twitter by The Xcelsius Gurus and The Xcelsius Gurus, kalyanverma. kalyanverma said: How to use #Xcelsius 2008 with VBA! [Video] http://tinyurl.com/XcelsiusVBA [...]

  4. Social comments and analytics for this post…

    This post was mentioned on Twitter by XcelsiusGurus: New VIDEO: How to use #Xcelsius 2008 with VBA! – http://alturl.com/hpqg

  5. Diego says:

    Hello, and my best congratulations for your site. I’m young and i discovered xcelsius a few months ago, and i have to thank you your site because, while i was almost getting crazy for xcelsius’ continuous bugs, i discovered that there were patches to fix them. Since then i follow your site with a lot of interest so thank you.

    Concerning the article, it would be fantastic for me to use the functionalities you described, overall VBA. One time i needed to use it, but i couldn’t, giving up in some important feature i wanted to implement. So what i would like to ask, is it possible to have a written (even shorter) guide of what you explain in the video??Being sincere, i neither understood how to import xcelsius dashboard in excel!

    Would you do that?
    Thanks in advance, Diego

  6. Yao Kouadio says:

    so finally what is the solution:
    I have some vb code full of different function calls associated with a workheet
    Code runs to update the workshheet cells.
    At design time, It works but at runtime, Only the cells with hard coded values are updated on the dashboard.

    How can create a swf file that can include and run those VB codes ?

Leave a Reply