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

[µo°Ý] WebDisableRedirections¤§³]©w

[µo°Ý] WebDisableRedirections¤§³]©w

ActiveSheet.QueryTables.Add¡@¤U¸üºô­¶¸ê®Æ®É
.WebDisableRedirections¡@¸T¥Î­«·s©w¦V
½Ð¤j¤j«üÂI¡A ¦ó¿× [­«·s©w¦V]¡H

­Y³]©w¬° True »P False ®t²§¦b­þ¡H¡I
.WebDisableRedirections = False         
.WebDisableRedirections = True         

ÁÂÁ¡I

¦^´_ 1# HSIEN6001


¦]¬°¤Óµæªº°ÝÃD,¨S¤H­n¦^µª§Ú¶Ü?!

§ä¨ì³o­Ó
http://www.excelpx.com/home/show.aspx?id=8740&cid=15

°Ñ¾\À³¥Î©ó¥Ü¨Ò¯S©Ê
¦pªG¸T¥Î QueryTable ª«¥óªº Web ¬d¸ß­«©w¦V¥\¯à¡A«h¸Ó­È¬° True¡C¹w³]­È¬° False¡CBoolean Ãþ«¬¡A¥iŪ¼g¡C
expression.WebDisableRedirections
expression      ¥²»Ý¡C¸Ó¹Bºâ¦¡ªð¦^¡§À³¥Î©ó¡¨¦Cªí¤¤ªºª«¥ó¤§¤@¡C
¥Ü¨Ò
¦b¥»¥Ü¨Ò¤¤¡AMicrosoft Excel ½T©w¤u§@襤²Ä¤@±i¤u§@ªíªº Web ¬d¸ß­«©w¦Vªº³]¸m¡C¥»¥Ü¨Ò°²©w QueryTable ª«¥ó¦ì©ó²Ä¤@±i¤u§@ªí¤W¡A§_«h±N¥X²{¹B¦æ¿ù»~¡C
Sub CheckWebQuerySetting()

    Dim wksSheet As Worksheet

    Set wksSheet = Application.ActiveSheet

    MsgBox wksSheet.QueryTables(1).WebDisableRedirections

End Sub

========================
©|¥¼²z¸Ñ,ÁÙ¦b°Ñ®©¤¤¡C¡C¡CO__Q¡C¡C¡C¡C

TOP

        ÀR«ä¦Û¦b : ÁÀ¨¥¹³¤@¦·²±¶}ªºÂAªá¡A¥~ªí¬üÄR¡A¥Í©Rµu¼È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD