I have an excel sheet with a hell of alot of vb code...
I made this a couple of years ago to score different darts games based on the rules of each game.
I would like to "port" this sheet from Microsoft dependant system to something a wee bit more universal. Feom what i can gater java is the obvious choice.
Now my question, would any of you guru type masters be willing to talk me (a complete lamen) through the proses? I now next to nothing about java.
I could upload or ahare the original excel if requested or required.
Please take pity on me...
3. Transfer your data from the spreadsheet to your new application.
Of course those three steps would overlap, but that's what you're looking at. And your Java learning would be led by the idea of writing that application, naturally. It looks like a reasonable project. And it doesn't necessarily matter whether the result is high quality or not because you're the one who is going to use the application -- am I right?
However the idea that you can learn Java via forum posts isn't a good idea. Online tutoring exists but not here. Most of our beginner questions here are like "I wrote this code and it doesn't work", followed by prompts to explain the problem and discussions on what to do. But if you don't have any code because you can't write it yet, then it's really hard to start a conversation. So I'd propose that you take a couple of months to try to learn basic Java. Then at least you might know the questions to ask.
Instead of an all-Java solution, you could also go with a hybrid solution: keep the data in the spreadsheet, and use a Java app to handle calculations and any possible changes based on those. That way you can replace VBS code with Java code, making it platform independent. You would use a spreadsheet app (like Libreoffice) to view and otherwise handle the data. That way, you wouldn't need to learn to write GUI code in Java as well as the basic language.
Alternatively, just convert the VBS code to whatever macro language Libreoffice has. That way you're no longer tied to MS Office.