Should i go with vb.net or VBA? Mostly working with excel files -


i'm starting new job - first - financial controller. job mean working lot excel files, example formatting document can imported , understood other financial programs sap, or creating charts data in document. there might many specific tasks vb.net/vba can come useful @ it.

my question is, should vb.net through visual studio or vba via excel? understanding can achieve same things both in terms of excel-files, perhaps vba quicker , easier learn , use. vb.net on other hand has better ide through visual studio , learning give me knowledge can more useful elsewhere. correct? instead of trying 1 of them find out after time should have gone other, hope right start.

i use both vba , vb.net recommend learning both.

learning vba easier learning vb.net because there less learn. find vba tutorials easier master because vb.net tutorials seem more concerned demonstrating amazing functionality of vb.net teaching basics of language. once have vba under belt learning curve vb.net not steep.

you access excel workbooks vb.net using interop can read , write excel version 2003 onwards. may able access earlier versions not know 1 uses earlier versions cannot test. interop slow. if program doing nothing manipulate excel worksheets, better using vba.

vb.net's forms have far more controls vba's. if trying create attractive, flexible, adjustable user interface vb.net 1 choose.

vb.net compiled immediate language compiled machine code @ runtime take advantage of capabilities of machine running on. vba compiles immediate language interpreted @ runtime. heavy processing, vb.net programs can thousands of time faster vba macros.

vb.net creates executable programs (myprogram.exe) can run on windows machine making them easy distribute if necessary. vba macros run within excel user need have , open excel run them.

to summarise: start vba try vb.net once have mastered syntax.


Comments

Popular posts from this blog

c++ - Difference between pre and post decrement in recursive function argument -

php - Nothing but 'run(); ' when browsing to my local project, how do I fix this? -

php - How can I echo out this array? -