Excel Web Site Development

[MTrumble]

I am a self taught Excel/VBA Business Systems Analyst who has built numerous Excel cost modelling, planning, forecasting and scheduling systems over the past 10 years. I would now like to develop a web-site to promote some of these Systems. Where possible, I would like to develop the site using Excel? I have seen a website (zoho.com zoho sheet) that enables users to utilise certain excel functions and VBA on-line. Can you please advise if there are any addins or products available that provide this type of functionality?

 

[Domski]

Speaking as very much a novice when it comes to web site development...

Never come across it before but Zoho looks like it provides much the same functionality as Google Documents in the you can create spreadsheets on-line with no software installation, access them any time and collaborate with others on them.

Having played with Google Sheets a while back much of the functions work the same as Excel but there were bugs and porting whole models from Excel into a Google Sheet meant that you pretty much always some some kind of functionality.

I have seen a demo of Excel Services which lets you upload functioning Excel spreadsheets to a Sharepoint server and allow users to use the spreadsheet as if they were in Excel but this again is different from how most people share files on normal web sites.

I reckon if you really want to promote yourself you would be better creating the website using one of the numerous web authoring toold out there and then have screenshots of you example models and downloadable files for people to access.

Just my thoughts and someone else may well disagree.

Dom

 

[MTrumble]

Thanks Dom - The thing that impressed me most about zoho sheet was the fact that you could write VBA code and trigger it when users select cells, followed hyperlinks etc.. and I just wondered if this functionality was available elsewhere as a 3rd party product or add-in.

 

[SydneyGeek]

Build the site using a dedicated application; you get a better result with less work. Then load up the samples / articles and go from there.

I currently use Expression Web and it's good. You can build static or database-driven pages, the templates are useful and can be adapted, and the output is standards-based.

Denis

 

[MTrumble]

Thanks Denis - I will take a close look at Expression Web.
Regards
Mick