2016年9月2日星期五
2016年9月1日星期四
MCU 00:初探
2016年7月31日星期日
Lycamobile SIM卡$58 試用
2016年7月14日星期四
Excel VBA 2a:Learning MSXML2.XMLHTTP
Introduction
What is MSXML2.XMLHTTP?
It is an object in Excel VBA for sending request to the server. YOu can use this object to get the response from the website.MSXML2 objects in Excel VBA
There are many object in Excel VBA in the MSXML2There should be a little diference between them, but I really don’t know the difference. Ha, maybe I will know in the future.
Now, 6.0 is the updated version.
So far, I just MSXML.XMLHTTP is work fine for me in Excel2010
Microsoft.XMLHTTP
Microsoft.XMLHTTP.1.0
Msxml2.ServerXMLHTTP
Msxml2.ServerXMLHTTP.3.0
Msxml2.ServerXMLHTTP.5.0
Msxml2.ServerXMLHTTP.6.0
Msxml2.XMLHTTP.3.0
Msxml2.XMLHTTP.5.0
Msxml2.XMLHTTP.6.0
2016年6月18日星期六
JavaScript 03: Create Event
Create Event
Intro:
一個簡單的實習。Click一下 Go button,透過JS code generate 一個click event,去click 一下paragraph1 和paragraph2。
當element被click時,text field就會顯示clicked字眼,一石二烏。
GIF:
Code:
JS Fiddle code: Create Event
2016年5月30日星期一
JavaScript02:Computed Stycle,"getComputedStyle",
原因:
如果想知道某一個element的現時style,就需要用到getComputedStyle(elemnet,xxx) method.第二個參數xxx一定為null或不寫,如想查的是一般的element。
JS Fiddle:https://jsfiddle.net/js_Test4fun/qejv4yd0/17/
2016年5月26日星期四
2016年4月29日星期五
Excel VBA : Copy image from website into Excel
Cause:
Wondering how to copy image from a internet source and paste to Excel using the VBA.There are many examples on the internet if you google "copy image from web vba". However, those are too complicate as I just want to copy from a particular website and particular one image.That's it. No more other things.
So I keep searching on the internet to find a proper method.
One of the method is using "URLDownloadToFile API", it is too complicate for me as I am just a beginner of VBA.....
Then I find a good example from stactoverflow. By using AddPicture(x,x,x,x,) method, it is very easy to copy a image to Excel!
However, you must know the URL of the image first...
Luckily, I know the basic DOM knowlege through my studies on Javascript.
Action:
How to know the URL of the source of the particular image:
訂閱:
文章 (Atom)