Which should I learn to interact with excel?

Question

0.00/5 (No votes)

See more:

, +

I already know much of Visual Basic for Excel. But for the next project I need to build a GUI for my client to interact with it.

That is in the foreground it will be a GUI (.exe with a software installation) and basically the inputs are Excel sheets and results are also Excel Sheets (which will be saved to the user documents)

What do you think will be the best language to learn to create more projects like this?

What I have tried:

I tried to create GUI in Excel but it is not professional to sell excel sheets instead of software.

Posted 25-Nov-19 23:28pm

ricks21

Updated 26-Nov-19 0:13am

Add a Solution

2 solutions

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)

RickZeeland · Answer 1 · 2019-11-26T00:09:00

Solution 1

You might be interested in the EPPlus library, see example here: Advanced Excels With EPPlus[^]
You can use this library with C# or VB.NET.

Posted 26-Nov-19 0:09am

RickZeeland

OriginalGriff · Answer 2 · 2019-11-26T00:13:00

Definitely not Javascript - that's for Client side browsers and can;t access any file on the client machine directly.

Since you are familiar with VBA, I'd suggest C# - it allows you to develop apps for Windows, Linux, Android, and iOS (with help from Mono and Xamarin) and is completely different to VBA. While VB exists, it is very different from VBA and shares only some common syntax - which means that what you are familiar with looks like it should work, but doesn't.
Make a clean break to C# - which isn't difficult, really - and you don't get the confusion of "but that works in VBA!". And it can interact with Excel, or access Excel sheets, or real databases.