converting .xlsm to webpage

[technik]

Hi

Apologies if this question has been asked before (and I hope I'm posting in the correct forum) … but I am trying to create a website which will behave exactly like my .xlsm sheet.

Does anyone know if its possible to "convert" a .xlsm file to a webpage where all the macros are fully functioning? I've looked at software like https://easasoftware.com but although it is pretty much what I need they seem to cater for big companies and its probably expensive.

If anyone can help I'd really appreciate it. Is there an easy (cheap) way?


Thanks

[CK76]

There's no easy way to do this.

If you know, ASP .NET or php, it isn't difficult to write code to emulate what Excel is doing. But this is still manual process of recreating Excel functionality via code.

Other than commercially available apps. I'm not aware of any ready made solution (especially where VBA is involved).

[Kyle123]

How complex is the spreadsheet? Could you upload it?

[Logit]

.
What about using MS OneDrive in combination with your website ?

[technik]

Hi Kyle123/CK76/Logit

Logit - I don't have a website yet.

The idea of my sheet is quite simple & it's not too complex in design/code. I will really quickly explain what it does here:

-I have a group of candidates who after sitting a test, receive back a template sheet showing their scores for each question.
-Any topic they have scored <=50% on, I have created a macro (with help from others) which prints the first 5 topics where the score is <=50%. I am looping through the group so that with one click I get a template sheet and 5 topic sheets for each candidate.

I have attached a toned down version so you can see what I mean.

I just need the a webpage with a few buttons to do this as opposed to an excel VBA sheet.

I have looked at https://www.ipushpull.com/ which I think use your excel sheet as the backend (so no complete converting going on) and display your sheet on the webpage. If I've understood it correctly I think that's quite clever ie. to use the excel VBA sheet almost like a DB and pulling data from there. However, again, it looks expensive and my sheet/issue is a simple one.

Any further help/pointers would be appreciated. Can't believe there's nothing simple out there for the average Jo and it's all for big corps. with million pound spreadsheets!

[Logit]

.

However, again, it looks expensive and my sheet/issue is a simple one.

I believe your goal is worthy but perhaps "lofty" ? As you indicated, your project is simple. I am not certain if there is value in complicating it. Unless I misunderstand your description, you basically want to deliver
the Template & Topics Sheets to the candidate. This can be accomplished via creation / utilizing the existing Excel workbook and posting the items on a "drop box" style site for the candidate to download.

OR ... your could email the results to the candidate with a professional presentation email body and/or cover sheet.

You may find a volunteer on this Excel Forum (or others) that are versed in HTML / CSS / etc programming but ... this is an Excel Forum. What coding I've seen that is internet related to the level you are seeking involves
scraping websites for the information that is already included therein. Not building a website utilizing VBA or including a workbook that can be manipulated real time on the internet .... unless that workbook is posted to
MS One Drive or similar.

And yes ... you could post your workbook on a website and allow others to access it but as you are discovering the cost is prohibitive for an individual.

Perhaps an alternative would be to use Google's online version of "Excel". Is it called 'Google Sheets' or similar ? I do not have experience with it but I understand the coding is very similar to VBA so the learning curve
shouldn't be too steep. Google sheets would accomplish your goal in a single application .... and I believe it's free ?

I hope this helps.

[CK76]

Google script (Apps script) is quite different from VBA, though it isn't hard to learn. It is based on JavaScript. And there are plenty of documentations and code snippets out there.

From Op's description, there are many ways to accomplish this. But none will be automatic and you'll need to build appropriate solution based on your need (or pay someone to do it ).

1. Use local vba to generate individual report/template, upload to OneDrive. Use MS Flow or other process to distribute.
2. If you have IIS server, create report site with login. Then load report via Ajax in json format, loading data based on login.
3. As Logit mentioned, use Google Sheet and Apps script.

[technik]

Thanks Logit/CK76 for your advice.

Where I am at at the moment is a website which asks the user to upload the excel sheet with the only data (no VBA/macro etc). Once the sheet with the raw data is uploaded the web front end displays what you see on the "main" sheet of the spreadsheet. I then am trying to get the programming bit (ie. the macros) to work but obviously that's the sticky bit.

Will keep plugging away but if there is anyone that could help here (ie. the website) I'd be happy to tender this out. (I won't say much more as I'm not sure I should be posting here about paid services so apologies admin if I've overstepped the mark here)

Thanks again guys