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

[µo°Ý] ½Ð±Ð¤@¤U vba¼´ªÑ²¼¼Æ¾Ú°ÝÃD

[µo°Ý] ½Ð±Ð¤@¤U vba¼´ªÑ²¼¼Æ¾Ú°ÝÃD

½Ð¯q¦U¦ì°ª¤â G¤j

        ¬°¦ó¦bwin10 excel 2016,¬°¦ó¦b°õ¦æ³o¬qcode·|»¡«¬ºA¤£²Å,¦bwin10  excel2013«o okªü
   code¬O¦b win10 excel 2016¼gªº 20171113.zip (11.97 KB)
20171113.JPG
2017-11-13 13:59
yvonne

¦^´_ 2# afu9240


«Øij§â      Dim sPageHTML As Long

§ï¬°      Dim sPageHTML

¸Õ¸Õ¬Ý

TOP

¤Ó±j¤F~~~¬°¤°³Â·|³o¼Ë ¥i¥H¤À¨É¶Ü???
yvonne

TOP

¦^´_ 4# afu9240


    Dim sPageHTML As Long
³]©w¤F sPageHTML ³o­ÓÅܼƬ° ªø¾ã¼ÆªºÃþ«¬
¦ý  sPageHTML = ......  .response.txt ¬Ý¨Ó¬O­n¨ú±o "¤å¦r¦ê"ªºÃþ«¬¡F §Ú¤£½T©w
¥¦ÅãµMÅܼÆÃþ«¬¤£¤@­P¡A ©Ò¥H«Øij¤£­n±Ä¥Î ¸U¥ÎÃþ«¬ ¥ý¸Õ Dim sPageHTML
¤]³\¥i¥H ³]¬° Dim sPageHTML$ ¤å¦rÃþ«¬¸Õ¸Õ¬Ý

°Ñ¦Ò°Õ

TOP

¦^´_ 4# afu9240


    "¥¦ÅãµMÅܼÆÃþ«¬¤£¤@­P¡A ©Ò¥H«Øij¤£­n±Ä¥Î ¸U¥ÎÃþ«¬ ¥ý¸Õ Dim sPageHTML"
¼g¿ù¤F¡A ­n§ï¬°¡G
    "¥¦ÅãµMÅܼÆÃþ«¬¤£¤@­P¡A ©Ò¥H«Øij­n±Ä¥Î ¸U¥ÎÃþ«¬ ¥ý¸Õ Dim sPageHTML"

TOP

s¤j  ¥i¥H½Ð±Ð§A¤@­Ó¼´ªÑ²¼ªºcode¶Ü??
yvonne

TOP

¦^´_ 1# afu9240
Dim sPageHTML
§A¤]¥i¥H±N¥¦­×§ï¦¨¡G
Dim sPageHTML As Variant
·í§A¤£½T©w¶Ç¦^­È¬°©M«¬ºA®É¡A§A¥i¬OµÛ¨Ï¥Î«Å§i Variant «¬ºA¡C

TOP

¦^´_ 6# afu9240


1. §â°ÝÃD ¼g¥X¨Ó¡A³o­Ó½×¾Â¦³«Ü¦h°ª¤â³£«Ü¼ö¤ß
2. ¤¬°Ê¦^µª½Ð«ö "¦^´_" ¡A¹ï¤è¤~·|³Q³qª¾

ÁÂÁÂ

TOP

        ÀR«ä¦Û¦b : ¤Hªº¤ß¦a¬O¤@²¥¥Ð¡A¤g¦a¨S¦³¼½¤U¦nºØ¤l¡A¤]ªø¤£¥X¦nªºªG¹ê¡C -
ªð¦^¦Cªí ¤W¤@¥DÃD