- ©«¤l
- 47
- ¥DÃD
- 12
- ºëµØ
- 0
- ¿n¤À
- 70
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- TAIWAN
- µù¥U®É¶¡
- 2010-7-28
- ³Ì«áµn¿ý
- 2021-12-1
|
¦^´_ 5# GBKEE
GBKEE¤j¤j,µ{¦¡×§ï«á¸ê®Æ¬d¸ß¸I¨ì¨S¦³¸ê®Æªº¤é´Á(5/1³Ò°Ê¸`)·|¥X²{¿ù»~¤¤Â_,쥻ªºcode«o¤£·|¦³³oºØ±¡ªp,½Ð°Ý¸Ó¦p¦ó¸Ñ¨M?ÁÂÁÂ~
Qur = "http://www.tdcc.com.tw/smWeb/QryStock.jsp?SCA_DATE=" & strDate & "&SqlMethod=StockNo&StockNo=" & stkno & "&StockName=&sub=%ACd%B8%DF"
If Sheet3.QueryTables.Count = 0 Then
Sheet3.QueryTables.Add "URL;" & Qur, Sheet3.[A3]
Else
Sheet3.QueryTables(1).Connection = "URL;" & Qur
Msg = True
End If
With Sheet3.QueryTables(1)
.Name = "«ùªÑ¤À§G"
.FieldNames = True
.RowNumbers = False
.FillAdjacentFormulas = False
.PreserveFormatting = False
.RefreshOnFileOpen = False
.BackgroundQuery = True
.RefreshStyle = xlOverwriteCells
.SavePassword = False
.SaveData = True
.AdjustColumnWidth = False
.RefreshPeriod = 0
.WebSelectionType = xlSpecifiedTables
.WebFormatting = xlWebFormattingNone
.WebTables = "6,7,8"
.WebPreFormattedTextToColumns = True
.WebConsecutiveDelimitersAsOne = True
.WebSingleBlockTextImport = False
.WebDisableDateRecognition = False
.WebDisableRedirections = False
.Refresh BackgroundQuery:=False
End With |
|