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

[°ÝÃD] Web ¶W³sµ²¾É¤J

[°ÝÃD] Web ¶W³sµ²¾É¤J

­Ó¤H·|¨Ï¥Î Excel ±qºô¯¸¤W¡A滙¤Jªí³æ¸ê®Æ¦Ü Excel ªí®æ¡D

¦ý­ì©l Web ªí³æ¸Ìªº³¡¥÷¤å¦r¡A¦³¶W³sµ²¡A

­n¦p¦ó¡¨´£¨ú¡¨¨º¤å¦rÁô§tªº¶W³sµ²¸ê®Æ©O¡H

¦^´_ 1# alumi
  1. Sub ExtractHL()
  2.     Dim HL As Hyperlink
  3.     For Each HL In ActiveSheet.Hyperlinks
  4.         HL.Range.Offset(0, 1).Value = HL.Address
  5.     Next
  6. End Sub
½Æ»s¥N½X

TOP

¦^´_ 2# genes

   ·PÁ±z¡A«Üºë²ªºµ{¦¡½X¡D

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡¦pÆp¥Û¡j®É¶¡¹ï¤@­Ó¦³´¼¼zªº¤H¦Ó¨¥¡A´N¦pÆp¥Û¯ë¬Ã¶Q¡F¦ý¹ï·M¤H¨Ó»¡¡A«o¹³¬O¤@§âªd¤g¡A¤@ÂI»ù­È¤]¨S¦³¡C
ªð¦^¦Cªí ¤W¤@¥DÃD