Create Dynamic Power Point Presentation Using VB Script/ASP

Background---- Currently every Monday on a weekly basis we provide reports in powerpoint to our clients. We download the data to excel and create a powerpoint slide show with charts updated in each slides with the latest week figures. For Example we track the stock price for IBM, Ebay, etc. 1st Slide - Contains a line chart (IBM & Ebay) with the latest weekly high/low/close added to the weeks before. 2nd Slide - Contains the 200 day moving average of IBM and Ebay We are doing this process manually. Expertise Required---- We would like to automate this process using ASP, VBScript. All data is stored in SQL Server and we have our own dedicated server. What we would like to do is write code (vbscript) in an ASP page that will work with PowerPoint office Component on the server. We would like you to provide vbscript synstax to create dynamic powerpoint presentations thru ASP page like the following for example.... 1) Create powerpoint application object, 2) Declare any global variables (applies to complete presentation) like header, footer, logo, etc (create template with user interface), 3) Create a slide, configure slide properties like title, etc 4) Add a chart, select chart type, configure chart properties (e.g. legends, grid, etc) 5) Load data into source grid from sql server or access 6) Repeat 3,4,5 above for different charts in different slides 7) Once the presentation is created dynamically, offer the user to download and save on their desktop The project requirement is to deliver us a demo. The demo will be an ASP page executing the above explained taking fiction stock data stored in an access database. What we would require is the vbscript/asp code required to create a dynamic powerpoint slide with the charts. You would provide a code template of the process where we can later customize to our needs. ## Deliverables Also you will provide us articles and documentations with respect to methods and properties that can be used and how to use it using ASP/Vbscript. Please only bid if you have worked on VBA, VBScript and Powerpoint. We would like to have this project completed in 21 days so if you cannot deliver by then, then please do not bid and we will not hesitate to cancel the project after 21 days. ## Platform Windows 2003 Server Microsoft Office Components VbScript, Sql Server, ASP