Chorn Sokun's Weblog

Conquer inner fear, push it to the limit!

Can’t believe I still living coding VBA

leave a comment »

I still love VBA simplify my daily task – lucky me that not perl :))

The code that I need to execute annually. It is a budget allocation process where each commune need to get information about their available budget.

One of my colleague has to works out with Ministry of Finance to come up with the correct budget (various formula) anyway it come out as and excel sheet. I need to transform this into a Microsoft Access table.


Code that I need to execute ~monthly… well this one is World Bank Project where I had forced to take responsible as the last guy to check the data before the report get submit to the World Bank. Well, it not a big task I just grab the data and run a macro again my Sql Server data source – make sure all the record syn.

It works well for the last 3 years, it fast flexible why do I care?

With all the tools available – can’t it be improve? why can’t it be a web enable process? IT mean simplify…

Advertisements

Written by Chorn Sokun

August 24, 2007 at 10:03 am

Posted in Programming

Tagged with ,

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: