Tuesday, March 02, 2010

Macro

Today, I've wrote a program with vba on excel.

I have been writing programs with various languages; c, c#, c++, perl, java, matlab, etc. Actually, the language vba is mostly like c#, because both of them are developed by Microsoft.

I started programming with vba after started to work. So I didn't know how the language is, the vocabulary and the grammer.

Now I studied almost all the basic functions of vba, simple calculation, standard in/out, and system call.

But there are many functions using excel worksheet functions with vba, such as making a table on the spreadsheet, and using complexed analysis, like solver or regression analysis.

I want to study more about vba with utilizing it for market risk.

No comments: