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

[µo°Ý] ¶W³sµ²­×§ï°ÝÃD

¦^´_ 1# jimmy510
  1. Sub ex()
  2. Dim Hy As Hyperlink
  3. For Each Hy In Sheet1.Hyperlinks  '©Ò¦³¶W³sµ²´`Àô
  4.   Hy.SubAddress = Replace(Hy.SubAddress, ".xlsx", "xlsm")  '§ó§ï¶W³sµ²¦ì§}
  5. Next
  6. End Sub
½Æ»s¥N½X
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 4# jimmy510

¤å¥ó¦a§}¬OAddress
  1. Sub ex()
  2. Dim Hy As Hyperlink
  3. For Each Hy In ActiveSheet.Hyperlinks  '©Ò¦³¶W³sµ²´`Àô
  4.   Hy.Address = Replace(Hy.Address, ".xlsx", "xlsm") '§ó§ï¶W³sµ²¦ì§}
  5. Next
  6. End Sub
½Æ»s¥N½X
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¡i°µ¤Hªº¶}©l¡j¨C¤@¤Ñ³£¬O¬G¤Hªº¶}©l¡A¨C¤@­Ó®É¨è³£¬O¦Û¤vªºÄµ±§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD