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

[µo°Ý] ¬°¦ó³sµ²§ì¤£¨ì??

[µo°Ý] ¬°¦ó³sµ²§ì¤£¨ì??

AÄæ¬OÀɮצWºÙ¡ABÄæ¬O³sµ²¸ô®|
AÄæ±q1~100¡A¸ê®Æ§¨¤ºÀɦW¤]¬O1~100¡C¨Ò:ÀɦW:21.PDF
AÄæ¿é¤J21¡A«hBÄæ¦Û°Ê§ó·s¸ô®|ÂI¤U¥h¥i¶}±Ò21.PDFªºÀÉ®×........

¦ý¬O..§Ú¤£·|¼g.....(¤U­±¬O¿ù»~ªº¥´¤£¶})........³Â·Ð¦U¦ì«üÂI.......

=HYPERLINK("\\ABserver\¦@¥Î\«ü¥Ü\U",A1&".PDF")

¬O¤£¬O¤Ö¤F¤@­Ó&²Å¸¹¸ò­Ë±×½u¡A¦h¤F¤@­Ó,¡H
=HYPERLINK("\\ABserver\¦@¥Î\«ü¥Ü\U",A1&".PDF")
§ï¦¨=HYPERLINK("\\ABserver\¦@¥Î\«ü¥Ü\U\"&A1&".PDF")

TOP

¦^´_ 19# whirlwind963


        ActiveCell.FormulaR1C1 = "Sheet2"
    Range("B1").Select
    ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _
        "Sheet2!A1"
, TextToDisplay:="Sheet2"


    Range("C1").Select
    ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:= _
        "XXXXXXXXXXXXXXXXXXXX", TextToDisplay:="test.txt"


XXXXXXXXXXXXXXXXXXXX=Àɮץؿý+ÀɮצWºÙ+ÀÉ®×°ÆÀɦW

  ¦h°µ¦h·Q¦h¾Ç²ß¡A¤Ö¬Ý¤Ö¿ù¤Ö°g³~

  ¦h°µ=¦h¦h½m²ß¡A¦h¦h½s¼g¡C
  ¦h·Q=·Q·Q¬°¤°»ò¤H®aµ{¦¡­n¨º¼Ë¼g¡A¦pªG´«¦¨¦Û¤v¡A¤S·|«ç¼g¡C
  ¦h¾Ç²ß=¾Ç²ß¤H®aªºµo°Ý¨Ã¸Ñµª¡A¾Ç²ß¤H®aªº¼gªk

  ¤Ö¬Ý=¥u¬Ý¤£°µ¤]ªPµM

TOP

¦^´_ 2# mark15jill
½Ð°ÝTextToDisplay:="C:\Users\user\Desktop\·s¼W¸ê®Æ§¨ (2)\" & Cells(kka, 1) & ".bmp"
¦pªG§ï¯àTextToDisplay:= Cells(kka, 1) ·|¥X¿ù
½Ð°Ý¦³¿ìªk±NÅã¥Ü¥X¨Óªº¤å¦r¥uÅã¥ÜÀɦW¶Ü

TOP

¦^´_ 17# ANGELA


    ¦¬¨ì~·PÁ«üÂI....ÁÂÁ±zªº¦^ÂÐ!:)

TOP

¤@¤dµ§¥Î¨ç¼ÆÀ³ÁÙ¥iÀ³¥I¡A°£«D¹q¸£¤Ó¡CVBA¥i¨ìVBAÑi°Ï´£°Ý¡C

TOP

¦^´_ 14# ANGELA


    Áª©¤j«üÂI:
¦pªG¥i¥H¡A¥i§_¦³­Ó½d¨ÒÅý§Ú¬ã¨s¦A´£¥X¤@¨Ç°ÝÃD.....ÁÂÁ±z¤F!

TOP

¸ê®Æ¶q­n¥ÎVBA¡A¤£µM´N¬O¹q¸£µwÅé¥Î¦n¤@ÂI............
kuoliang

TOP

¦^´_ 13# dakiu


    ³o¬O¨ç¼Æªº­P©R¶Ë¡A¤×¨ä¬O°}¦C¨ç¼Æ¡C­pºâ¶q¤j³t«×¤@©wºC¡A§ï¥ÎVBA·|¤ñ¸û§Ö¡C

TOP

¦^´_ 12# ANGELA


    ª©¤j:
ÁÂÁ«üÂI¡A¸g´ú¸ÕOK¡C
¦ý¬O¸ê®Æ¦h¹F1¤dµ§¡A³o¼Ë©Ô¤U¥h§ä¸ê®Æ®É·|¹y±¼...«ÜºC....¦pªG¥i¥H¬O§_ÁÙ¦³¨ä¥L¤è¦¡???¥ýÁÂÁ¤F...

TOP

        ÀR«ä¦Û¦b : ®É®É¦n¤ß´N¬O®É®É¦n¤é¡C
ªð¦^¦Cªí ¤W¤@¥DÃD