View Full Version : ASP and Excel VBA

11-26-2003, 09:09 AM
Hi all,
I am trying to write an application about output the Excel VBA report data and chart to web page automatically when user press the update button on web page.And I don't know how to figure it out,even how to start it? Can anyone give me suggestion or advice? Thanks anyway.

Roy Sinclair
12-02-2003, 05:47 PM
I think you need to describe what you want in more detail, I don't understand much from what you've said so far other than you've got a web page and an Excel spreadsheet that you want to connect somehow.

12-04-2003, 10:48 AM
Sorry,i make you confused.
First of all,there will be one web page,and the contents are some numeric data and chart(like barchart,linechart) come from EXCEL spreadsheet.
And how can i link the contents from EXCEL spreadsheet to web page using ASP?

Roy Sinclair
12-04-2003, 05:42 PM
Your ASP page can use the MS Database Access functions (called ADO) to open the spreadsheet like a database and then read various values from the spreadsheet using SQL syntax or you can directly open the spreadsheet as a spreadsheet object and use the VBA (VB for Applications)syntax to access parts of the spreadsheet. Since you want to get some charts and the like (which you'll have to export as images) you'll probably have to use the latter route.

As I've told another today, the macro recording function in MS Office programs provides a great way to manually perform an action and then see what code is required to to do the same thing.

12-05-2003, 07:47 AM
Thanks for your help,Roy!
I have idea how to start my project after read your reply post.
Thank you very much!!:thumbsup: