ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

½Ð°Ý¬°¤°»ò°õVBA®É¡A°O¾ÐÅé·|¶V¨Ó¶V¤j¡AÅܦ¨³t«×ÅܺC

With WebShtYah.QueryTables.Add(Connection:=YahooURL, Destination:=WebShtYah.[A1])
        .AdjustColumnWidth = False
        .WebSelectionType = xlAllTables
        .WebFormatting = xlWebFormattingNone
        .WebPreFormattedTextToColumns = True
        .WebConsecutiveDelimitersAsOne = True
        .WebSingleBlockTextImport = False
        .WebDisableDateRecognition = False
        .Refresh BackgroundQuery:=False
       .Delete
    End With

TOP

        ÀR«ä¦Û¦b : ¡i°±º¢¤£«e¡A²×µL©Ò±o¡j¤H³£°g©ó´M§ä©_ÂÝ¡A¦]¦Ó°±º¢¤£«e¡FÁa¨Ï®É¶¡¦A¦h¡B¸ô¦Aªø¡A¤]¤FµL¥Î³B¡A²×µL©Ò±o¡C
ªð¦^¦Cªí ¤W¤@¥DÃD