Best way to read an excel chart or take a snapshot and email to each specific individual user (automation with asp.net).

Hi all,

I need to email charts from an excel spreadsheet to specific users in our organization.  For example, I have a spreadsheet with 120 charts, each chart will need to be automated and emailed to certain users on a daily basis.  I am not sure on the best solution for this?
Can I take a snapshot of the chart save it to disk and then email it to the users?  Should I just import the raw data into SQL Server table and then re-create the charts and then email from there?  could i do this  in Excel using some type of VBA?  Any ideas, samples, example would be appreciated.

thank you!
kouts1Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

grendel777Commented:
I think the best solution, as you noted, is to keep the data in the database, create an SSRS server, and generate the charts as reports. Then you can send them out via daily subscriptions. It's also possible to do this with VBA (see here), but honestly that's more trouble than it's worth, IMHO.

Just get a download of SQL Express and install it somewhere with access to your main datastore. See if you can get the queries that are pulling the data into Excel so you can use them to create the reports.

New Installation (Reporting Services in Native Mode)
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
kouts1Author Commented:
Getting the source of the data or queries will be almost impossible.  I will have to figure out a way to import the data from excel into SQL server first as part of the daily automation process.  I am thinking of creating an SSIS package first and then either ssrs or pure asp.net to chart the data.  Lol, my boss is adamant on having all this ready by Friday this week.  :(

thanks for the help!
0
kouts1Author Commented:
thanks!
0
grendel777Commented:
Oh man, then I recommend an espresso machine or Turkish coffee...good luck!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.