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

Post a Comment

Popular posts from this blog

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

i have following sample code used pre-decrement void function(int c) { if(c == 0) { return; } else { cout << "dp" << c << endl; function(--c); cout << c << endl; return; } } this function give output input 4 : dp3 dp2 dp1 dp0 0 1 2 3 but when use post decrement void function(int c) { if(c == 0) { return; } else { cout << "dp" << c << endl; function(c--); cout << c << endl; return; } } output goes in infinite loop dp4 can explain me in detail why happens ? this happens because function(c--) called same value of c , when finishes c decremented. recursively called, hence called same value no chance of return , hit stack overflow error. assume this, int x = 1, y = 0; y = x++ result y == 1 , x == 2. if y = ++x , bot x , y 2.
Read more

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

i added new project. made mistake in projectname.conf file in sites-available apache2, led me reinstalling apache2. after reinstalling , re-enabling projects on every page of every project .. <body> run(); </body> .. i've run composer update, restarted service, restarted pc, checked config files, tried disabling new project. there nothing in error log, , access.log: 127.0.0.1 - - [15/may/2015:01:40:47 +0200] "get / http/1.1" 304 181 "-" "mozilla/5.0 (x11; ubuntu; linux x86_64; rv:38.0) gecko/20100101 firefox/38.0" maybe i'm forgetting apache2 reinstall? don't think did different last time installed it. looks haven't setup php correctly. take @ this great guide , maybe you're forgetting link php config apache2.
Read more

php - How can I echo out this array? -

i don't know how go grabbing data in variable , put foreach loop. class tree{ private $info = array( array('name'=>'jim','state'=>'nu','company'=>'nu','phone'=>array('cell'=>'5615111111','office'=>'5611111111'),'email'=>array('primary'=>'exs@example.com','ex@there.com')), array('name'=>'joe smith','city'=>'phoenix','phone'=>'4805551111','email'=>'jsmith@some_email.com'), array('name'=>'john doe','city'=>'chandler','company'=>'doe co.','email'=>array('jdoe@gmail.com','personal'=>'email@email.com'),'phone'=>'6025550002') ); } if you're inside of class, can access private variable using $this->variablename . example, i...
Read more