Being the complete nerd that I am, I work with lots of different technologies. But in the end, I always strive to make those technologies work with Excel. One of those is Xcelsius. Xcelsius is a dashboarding application that takes data and spices it up into slick looking flash presentations.
Those of you who have already been asked to create reporting in Xcelsius may have found it a bit difficult to use. No VBA, no easy way to get connections and no pivot tables.
Well for the upcoming Xcelsius Developer’s Workshop, I’ve come up with a technique where you can embed Xcelsius dashboards into Excel and Access applications.
This allows you to get all the flashy benefits of Xcelsius, but still give users a familiar environment where they can use PivotTables, VBA, MSQuery, etc.
It’s too complicated to show with pictures, so I cooked up this video. Enjoy!
RELATED STUFF
- VBE Tips I Wish I Knew 5 Years Ago
- Sending Data to Excel using Access SQL
- Transposing a Dataset in Access
- Why Replace the DOM Interface
- Running an Access Parameter Query from Excel
- Documenting Access Queries in Excel
- Creating a Zoom Box in Excel
- Smart Scroll Bars in Excel
- Clearing Access ImportError Tables
- Excel Zoom Box Font Size Follow Up
Mike…there’s a spelling mistake above. There’s no ‘L’ in ‘sick’.
Although I don’t use Xcelsius it’s interesting to see this approach. I use a similar way to get data dynamically from an ERP system. When a parameter changes some VBA code requests data from the system and places it in an XML file, then the XML map in Excel (and everything connected to it) is refreshed.
Maybe you could do video’s of your workshops and sell them online? I’d be interested
Sounds brilliant, however any help in India?
Can Xcelsius be incorporated in MS Access applications developed and is it royalty free for own applications with Xcelsius to be sold commercially?
Gene: Xcelsisius can be incorporated into MS Access. I’ll put together a video demonstrating how – one of these days.
I’m fairly certain that you can embedd your Xcelsius solutions into Access for commercial purposes. I would, however, read the license agreement for your particular version of Xcelsius.
Dear Pig
I was wondering, how do you filter the information for different months?
I’ve been trying to do this in an easy way but with no success.
I hope you can help me.
Greetings from Peru.
Juan Pablo:
Email me: mike at datapigtechnologies.com.
I’ll send you the working example.
Dear Mike
My email is chepar20@yahoo.es
I sent you an email last friday.
Thanks