How do I create my excel VBA project in web using a database like excel or etc

Question

0.00/5 (No votes)

See more:

Excel-2016

With the help of several people, I created a form in VBA Excel 2016 that can be used to store information in Excel and, if desired, from a date onwards, see the results in a listbox.

My goal is to implement this form on the web.
My question is, where should I start? Is it possible to create a php page that reads and writes data from Excel? Or should I use another program instead of Excel to store and write information?

Someone suggested Angular to me because it has so many features; If this suggestion is correct, where should I start? Is it possible to read information from Excel when using Angular?

File attached in this place.

What I have tried:

I create a Form in excel vba 2016.

Posted 2-Sep-22 16:39pm

niksirat2030

Updated 2-Sep-22 19:01pm

v2

Add a Solution

Comments

Dave Kreskowiak 2-Sep-22 23:58pm

You could use Excel, but you have limitations. Excel interop is not supported in a web application. You would be much better off putting the data in an actual database, like MySql, or the like.

BobbyStrain 3-Sep-22 0:12am

MySql has an Excel add-in that connects to a MySql database on a web server. If you start there, you won't need anything but Excel and VBA in Excel.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Accepted Answer · 2022-09-02T19:01:00

Do yourself a favour, and don't use Excel.

Excel is an excellent spreadsheet, but it isn't a database, and while you can store information in it that';s not something it's good at - it's about presentation and analysis of data for a single user, not multiuser storage of bulk data.

Web solutions are normally multiuser, and while you can get a few people working on the same spreadsheet at the same time, it's not good at it - and Office is almost never installed on web servers for cost reasons (and because they don;t generally have users logged in) so 99% of the time it's not going to be available to your server-based code at all. Even if Office was installed, it'll be installed for a user, but IIS doesn't run under that account, so the chances are it (and thus your server code) can't access it either!

You can't access the client Office implementation at all (assuming he has it installed) for security reasons.

So really, it's a bad idea that is almost certainly doomed to failure from the start: use a multiuser database system (Sql Server or MySql for example) and things start to work much, much better right from the start!