VBA + SQL

nulry

請問VBA 點分初,中, 高級?
小弟都係只學到去 email download files, 出 email 連 attachement, copy and paste 個 d 咁

之前一直都覺得唔識去到太叻, 識睇點去改 d path 就 ok, 但做我呢行, 其實都要識 programming, 所以想去學, 同埋學埋 SQL, 唔知如果想去到 中高級 level 要識 d 乜, 同幾耐時間到呢?

thx all~~

ronstudio

When you have the goal in mind for what to achieve, it'll be easier.
I guess sooner or later you'll move away from from VBA and moving towards other scripting language like Perl, Ruby or Python as they are generally more powerful (having more publicly available modules).
"但做我呢行", so which industry do you work in?

nulry

When you have the goal in mind for what to achieve, it'll be easier.
I guess sooner or later you'll  ...
ronstudio 發表於 2017-3-6 22:37

in risk management

nulry

When you have the goal in mind for what to achieve, it'll be easier.
I guess sooner or later you'll  ...
ronstudio 發表於 2017-3-6 22:37

in risk management
what means by scripting language? Seems Pyhton is more well known now

happy_99

學SQL 都要睇你用乜野database, 如果你唔係有application 用到既話好難開始到.

ronstudio

回覆 4# nulry

I thought R programming lang were more popular in your field

nulry

用Excel vba就行到sql啦 仲可以因應唔同情況將variable寫落sql script好大彈性, run完再用vba抽取data同 ...
myricky 發表於 2017-3-7 16:29

Yes, we are using this~

nulry

回覆  nulry

I thought R programming lang were more popular in your field
ronstudio 發表於 2017-3-7 18:13

it deps, my company didnt use it