Converting an Excel VBA spreadsheet to an .asp page

[MiniBlueDragon]

Hi folks,

I have an Excel spreadsheet I've written in VBA to do the following:

- Scrape all data from a website and post each piece of data in a cell on sheet 2.

- Scrape all

data from a different website and again post each piece of data in cells on sheet 3.

- General if statements throughout sheet 1 to make some calculations.

It's not a particularly complicated spreadsheet so I'm convident it can be ported over to an .asp page in VB to be accessible from any of my machines rather than requiring Excel on all my machines.

Does anyone have any ideas on the best place to start looking at how to port it please?

Cheers,

MBD

[Zack]

Do you have a database that you are storing all your information for this spreadsheet? If you do, why don't you just create a grid view that pulls in the data from your database, and then from the gridview, you can save, edit, delete and do whatever you want.

If not, you are going to have to create a connection to the spreadsheet, and then access all the info from there.

Here is an example...

http://www.davidhayden.com/blog/dave/archive/2006/05/26/2973.aspx

[Zack]

Take a look at this link. Has VB code as well.

http://www.dotnetcurry.com/ShowArticle.aspx?ID=138

[MiniBlueDragon]

Thanks Zack. The spreadsheet itself is currently the storage for any data the spreadsheet pulls from websites, however I'm more than happy to set up an SQL database. The links above are not not quite what I'm looking for but I'll have a look through the site and see if there's anything else on there that may be useful.

Thanks for your help. :)

[Zack]

When you are porting over the spreadsheet, do you only want it to be used to see data? You don't want any of your employees to be able to edit the information at all?

If you only want them to view the information, (I know you said the links I sent you weren't what you were looking for, and I'm not trying to be an a-hole) but the second link I sent you should work fine. You can put the data into a gridview and it will look like this...

Well, if you setup a SQL database, you can get rid of Excel and maintain all of your data through the web page. What software are you using for your web application. Are you using Visual Studios, Dreamweaver, or something else? Give us some more details with what you are using and what you want to accomplish with the spread sheet. I don't know if you want the Excel spreadsheet data to look real fancy on the webpage and not have it look like a gridview. At work, we use SQL and Visual Studios 2010 for all our applications. We have got rid of all Excel spreadsheets and use these GridView's for all data to be read,inserted, deleted, and updated.

Just trying to help :)

Zack