VBA + SQL

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

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

thx all~~

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?

TOP

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

TOP

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

TOP

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

TOP

學SQL 都要睇你用乜野database, 如果你唔係有application 用到既話好難開始到.
happy_99 發表於 2017-3-7 10:41



用Excel vba就行到sql啦 仲可以因應唔同情況將variable寫落sql script好大彈性, run完再用vba抽取data同執埋個format直出report呢.

TOP

回覆 4# nulry

I thought R programming lang were more popular in your field

TOP

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

Yes, we are using this~

TOP

回覆  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

TOP

Yes, we are using this~
nulry 發表於 2017-3-7 20:48


咁就得啦, 你睇多D功力深厚同事所寫既VBA, 初初以抄改為主, 再慢慢增加自己寫作比重, 好快上手的.  有咩唔明/諗唔掂既, 除左問同事, 亦可以POST上黎, 相信呢度好多C兄樂意比意見的.

TOP