How exactly would you do this?

I have some basic coding background (C++, HTML, CSS, a little java) and was wondering what would be the best way for taking a workbook that has several macros and converting it into a web application?

We have a quoting tool at my work that is currently just an excel file that is emailed around as it's updated, but it's getting to be too complicated to keep wraps on it. I'd like to build a web app for internal use that would use all of the same features.

7/6/2016 3:36:05 PM

Step 1: Procure a bunch of servers
Step 2: Install a Sharepoint Farm
Step 3: Upload that .xlsx to Sharepoint
Step 4: Pay yourself on the back

7/6/2016 3:46:32 PM

Isn't this what Office 360 basically is? Or convert it to a Google Doc?

7/6/2016 3:46:35 PM

If you have Office 365, you ought to look into this:

https://support.office.com/en-us/article/Embed-your-Excel-workbook-on-your-web-page-or-blog-from-SharePoint-or-OneDrive-for-Business-7af74ce6-e8a0-48ac-ba3b-a1dd627b7773

7/6/2016 3:47:48 PM

I get the impression from the OP that he wants to trash the spreadsheet entirely but maybe not.

Are we talking about something where they just fill in a bunch of fields and one of the pages in the workbook spits out some numbers that the macros computed?
If it is as simple as that I'd just make it an HTML form with a little javascript in the background for whatever computations you need.

If you do end up making this, be prepared for push-back from people who have been using their precious spreadsheet for the last 15 years and don't trust any new fangled ways of doing things .

7/7/2016 5:21:29 PM

I don't think Office 365 can do macros through the browser interface anyways

7/8/2016 7:53:13 AM

^^ yeah, he'll probably want to use a database (but could just use a file-- although this is not recommended) and have the form push the data to the database.

Then write the magical code to parse the data from the DB and do the calculations and stuff.

It's a good project actually, because it will give OP a chance to learn something new, and even if they don't end up using the form, he'll get some kudos. If they DO end up using the form, he just helped automate someone out of a job or pay raise and maybe earned a raise for himself.

[Edited on July 8, 2016 at 12:15 PM. Reason : ]

7/8/2016 12:15:02 PM

if your company has sharepoint , look into Nintex forms. Try to get your sharepoint admin to load it for you.

You can have a sharepoint access DB driven back end powered by a form driven front end pretty efficiently. I believe the form can perform simple math functions for you.

7/13/2016 4:39:44 AM