Excel, VisualStudio, VBA, ,NET, which way to go?

%3CLINGO-SUB%20id%3D%22lingo-sub-2762569%22%20slang%3D%22en-US%22%3EExcel%2C%20VisualStudio%2C%20VBA%2C%20%2CNET%2C%20which%20way%20to%20go%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2762569%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20Morning%3CBR%20%2F%3EAt%20the%20moment%20I'm%20developing%20an%20excel%20file%20with%20VBA%20and%20forms%2C%20for%20human%20resources%20management%20of%20the%20company%20where%20I%20work.%3CBR%20%2F%3EI%20started%20about%201%20year%20ago%20with%20VBA%20and%20recording%20data%20in%20excel%20sheets.%3CBR%20%2F%3ERight%20now%20I%20need%20to%20improve%20file%20security%20and%20I%20need%20to%20use%20MySQL%20to%20save%20the%20data%2C%20but%20I%20don't%20know%20where%20to%20start%20this%20transformation.%3CBR%20%2F%3EI%20have%20knowledge%20of%20relational%20databases%20and%20I've%20studied%20and%20tested%20a%20bit%20of%20MySQL.%20However%2C%20I%20have%20no%20idea%20how%20to%20relate%20MYSQL%20with%20Excel.%3CBR%20%2F%3EI%20didn't%20want%20to%20start%20from%20scratch%2C%20so%20I%20don't%20know%20if%20it's%20worth%20deepening%20my%20knowledge%20of%20Visual%20Studio%20and%20a%20more%20advanced%20visual%20basic%20now%2C%20or%20if%20I'm%20just%20using%20MySQL%20with%20the%20files%20I%20already%20have.%3CBR%20%2F%3EMaybe%20keeping%20the%20files%2C%20save%20some%20time%2C%20but%20I%20don't%20know%20I%20will%20stop%20having%20the%20reliability%20problems%20that%20excel%20presents%20in%20a%20multiuser%20environment.%3CBR%20%2F%3EUsing%20MySQL%20with%20Excel%2C%20does%20excel%20become%20a%20more%20reliable%20multi-user%20environment%3F%3CBR%20%2F%3EI'm%20confused%20about%20the%20steps%20I%20should%20take%2C%20considering%20that%20I%20have%20to%20continue%20the%20development%20of%20the%20files%20non-stop%2C%20and%20I%20would%20like%20to%20have%20help%20to%20clarify%20my%20doubts.%20Thank%20you%20for%20your%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2762569%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2762895%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%2C%20VisualStudio%2C%20VBA%2C%20%2CNET%2C%20which%20way%20to%20go%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2762895%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1084899%22%20target%3D%22_blank%22%3E%40csoares%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20my%20humble%20opinion%2C%20one%20of%20the%20programs%20that%20would%20use%20corporate%20forms%20would%20be%20Microsoft%20Forms.%3C%2FP%3E%3CP%3EIs%20very%20good%20especially%20for%20forms%20that%20can%20be%20used%20directly%20from%20the%20web.%20You%20can%20edit%20online%20surveys%2C%20questionnaires%2C%20OneDrive%20100%25%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3Ecompatible%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%20%2C%20etc.%3C%2FP%3E%3CP%3EA%20small%20miracle%20weapon%20for%20an%20organization%20%2F%20company%20in%20everyday%20professional%20life.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EEven%20if%20they%20arenot%20Microsoft%20products%2C%20I%20cannot%20ignore%20the%20fact%20that%20Adobe%20Acrobat%20Pro%20DC%20and%20%2F%20or%20Adobe%20LiveCycle%20Enterprise%20Suite%204%20are%20also%20silver%20bullets%20for%20forms.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EFor%20%22simple%22%20PDFs%2C%20Adobe%20Acrobat%20Pro%20DC%20is%20very%20good.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EAdobe%20LiveCycle%20Enterprise%20Suite%204%20is%20very%20suitable%20for%20%22dynamic%22%20PDFs.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EYou%20can%20use%20it%20to%20create%20PDF%20forms%2C%20secure%20them%20as%20required%2C%20incorporate%20electronic%20signatures%20in%20various%20ways%2C%20etc.%3C%2FP%3E%3CP%3EThe%20disadvantage%2C%20you%20would%20have%20to%20deal%20with%20JavaScript%20if%20you%20want%20to%20create%20dynamic%20forms.%3C%2FP%3E%3CP%3EVBA%20is%20not%20possible.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20all%20of%20this%20is%20only%20my%20humble%20opinion%2C%20which%20does%20not%20mean%20that%20only%20these%20solutions%20are%20best.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20wish%20you%20good%20luck%20with%20your%20choice.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20time%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolinoDE%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

Good Morning
At the moment I'm developing an excel file with VBA and forms, for human resources management of the company where I work.
I started about 1 year ago with VBA and recording data in excel sheets.
Right now I need to improve file security and I need to use MySQL to save the data, but I don't know where to start this transformation.
I have knowledge of relational databases and I've studied and tested a bit of MySQL. However, I have no idea how to relate MYSQL with Excel.
I didn't want to start from scratch, so I don't know if it's worth deepening my knowledge of Visual Studio and a more advanced visual basic now, or if I'm just using MySQL with the files I already have.
Maybe keeping the files, save some time, but I don't know I will stop having the reliability problems that excel presents in a multiuser environment.
Using MySQL with Excel, does excel become a more reliable multi-user environment?
I'm confused about the steps I should take, considering that I have to continue the development of the files non-stop, and I would like to have help to clarify my doubts. Thank you for your help.

3 Replies

@csoares 

In my humble opinion, one of the programs that would use corporate forms would be Microsoft Forms.

Is very good especially for forms that can be used directly from the web. You can edit online surveys, questionnaires, OneDrive 100%compatible , etc.

A small miracle weapon for an organization / company in everyday professional life.

 

Even if they arenot Microsoft products, I cannot ignore the fact that Adobe Acrobat Pro DC and / or Adobe LiveCycle Enterprise Suite 4 are also silver bullets for forms. For "simple" PDFs, Adobe Acrobat Pro DC is very good. Adobe LiveCycle Enterprise Suite 4 is very suitable for "dynamic" PDFs.

You can use it to create PDF forms, secure them as required, incorporate electronic signatures in various ways, etc.

The disadvantage, you would have to deal with JavaScript if you want to create dynamic forms.

VBA is not possible.

 

However, all of this is only my humble opinion, which does not mean that only these solutions are best.

 

I wish you good luck with your choice.

 

Thank you for your time and patience

 

NikolinoDE

I know I don't know anything (Socrates)

 

Good morning, thanks for your answer which also turned out to be very interesting and useful, however I meant "Userforms" from VBA and not "Forms" from Microsoft Forms.

@csoares 

Excuse me, in the heat of the moment I only read the first line and then started to spin.

As far as MySQL is concerned, I am not the one to help you, as my knowledge is very limited in this regard.

 

Anyway, here is a link with some info on the MySQL database.

MySQL database

 

Also wish you a lot of success in your project.

 

Thank you for your understanding and patience

 

Nikolino

I know I don't know anything (Socrates)