¦p¦ó¤j¶q³sµ²sheet¸ÌªºÀx¦s®æ
¡@¼ÊºÙ: ÀH·ÄÆ¿ºªº¦Ð¤ò ¡@ÀY»Î: [±s¥Î]¼ç¤ô¸¥
°ª¤¤¥Í
- ©«¤l
- 852
- ¥DÃD
- 79
- ºëµØ
- 0
- ¿n¤À
- 918
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows 7 , XP
- ³nÅ骩¥»
- Office 2007, Office 2003,Office 2010,YoZo Office
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¦t©z
- µù¥U®É¶¡
- 2011-4-8
- ³Ì«áµn¿ý
- 2024-2-21
|
¦^´_ mark15jill
·PÁÂmark15jill¤jªº¦^ÂÐ
¤p§Ìªº¸ô®|¸Ì½T¹ê¤Ö¤F¤@Ӥϱ׽u¡A¦ý¤p§Ì¥[¤F¤§«á¦A ...
syuan µoªí©ó 2012-11-6 12:11
©ú©ú¸ô®|¬O"C:\11\"¡A¦ý·Æ¹«´å¼Ð«ü¨ìÀx¦s®æ¦Ó¨q¥Xªº¤p´£¥Ü«o¬Oc:\temp\....... (¤p§Ì±N³oÓexcelÀɲ¾¦Üc:\temp¤º¡^
§AÀɮצb temp ÁÙ¬O 11©³¤U.. |
|
¦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
|
|
|
|
|
- ©«¤l
- 50
- ¥DÃD
- 12
- ºëµØ
- 0
- ¿n¤À
- 143
- ÂI¦W
- 0
- §@·~¨t²Î
- win xp
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- EARTH
- µù¥U®É¶¡
- 2010-5-24
- ³Ì«áµn¿ý
- 2015-5-12
|
¦^´_ 10# mark15jill
·PÁÂmark15jill¤jªº¦^ÂÐ
¤p§Ìªº¸ô®|¸Ì½T¹ê¤Ö¤F¤@Ӥϱ׽u¡A¦ý¤p§Ì¥[¤F¤§«á¦Arun®É¡A¶W³sµ²ªº¸ô®|¨ÌµM¨S§ï¹L¨Ó¡I
²{¦bªº»yªk¦p¤U¡G
Dim A As Range
Dim B
Dim C
Worksheets("sheet1").Activate
For Each A In Worksheets("sheet1").UsedRange
If InStr(A, "JIS ") And A.Value = "" Then
B = "C:\11\"
C = Dir(B, ".PDF")
A.Hyperlinks.Add A, C & A
End If
Next A
©ú©ú¸ô®|¬O"C:\11\"¡A¦ý·Æ¹«´å¼Ð«ü¨ìÀx¦s®æ¦Ó¨q¥Xªº¤p´£¥Ü«o¬Oc:\temp\....... (¤p§Ì±N³oÓexcelÀɲ¾¦Üc:\temp¤º¡^
¦n©_©Ç¡A¤£ª¾þ¸Ì¥X¤F°ÝÃD¡H
ÁÙ±æ¦U¦ì¥ý¶i¤£§[«ü¾É¡AÁÂÁ¡C |
|
¿ú¬O«Ü±I²öªº¡A©Ò¥H·|·Q¿ìªk»E¦b¤@°_¡I
|
|
|
|
|
¡@¼ÊºÙ: ÀH·ÄÆ¿ºªº¦Ð¤ò ¡@ÀY»Î: [±s¥Î]¼ç¤ô¸¥
°ª¤¤¥Í
- ©«¤l
- 852
- ¥DÃD
- 79
- ºëµØ
- 0
- ¿n¤À
- 918
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows 7 , XP
- ³nÅ骩¥»
- Office 2007, Office 2003,Office 2010,YoZo Office
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¦t©z
- µù¥U®É¶¡
- 2011-4-8
- ³Ì«áµn¿ý
- 2024-2-21
|
¦^´_ 9# syuan
B = "C:\11\" |
|
¦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
|
|
|
|
|
- ©«¤l
- 50
- ¥DÃD
- 12
- ºëµØ
- 0
- ¿n¤À
- 143
- ÂI¦W
- 0
- §@·~¨t²Î
- win xp
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- EARTH
- µù¥U®É¶¡
- 2010-5-24
- ³Ì«áµn¿ý
- 2015-5-12
|
¦^´_ 4# Hsieh
Hsieh±z¦n
¤p§Ì¨Ì±z©Òpoªº»yªk´ú¸Õ«á¡Aªº½T¯à³sµ²¨Ã¶}±Ò©ÒÂI¿ïªºÀɮסC
¤£¹L¤p§Ì±N³oÓexcelÀɲ¾¨ì§O³B¨Ã¥[¤Jקï«áªº¸ô®|®É¡A¥¦´NµLªk¶}±Ò©Ò³sµ²ªºÀɮפF¡C
¤]´N¬O»¡³o¬q»yªk¦ü¥G¥u¯à±NexcelÀÉ»P³sµ²ªºÀÉ©ñ¦b¦P¥Ø¿ý¤U¡C
¤p§Ì¼gªº»yªk¦p¤U¡A½Ð°Ñ¦Ò¡C
Dim A as range
Dim B
Dim C
Worksheets("sheet1").Activate
For Each A In Worksheets("sheet1").UsedRange
If InStr(A, "JIS ") And A.Value = "" Then
B = "C:\11"
C = Dir(B, ".PDF")
A.Hyperlinks.Add A, C & A
End If
¤£¹L¤p§Ìµo²{¦pªG±N...... and A.value="" Then§ï¬°......and A.value <>""Then ®É
¨º»òÀx¦s®æªº¦r¦ê·|Åܦ¨¤@¤j¦êªº¸ô®|¡A¨Ò¦p¡GC:\11\aa.pdf
¦ý³o®ÉÂI¥¦®É¡A«o¬O¥i¥H¶}±Ò¶W³sµ²ªºÀÉ®×.........=="
¤p§Ì¤@ª½¦Ê«ä¤£¸Ñ¡A¤£ª¾¨ì©³¬Oþ¸Ì¥X°ÝÃD¡C
ÁÙ±æ¦U¦ì¥ý¶i¤£§[«ü±Ð¡A¥H¤W¡ãÁÂÁ¡C |
|
¿ú¬O«Ü±I²öªº¡A©Ò¥H·|·Q¿ìªk»E¦b¤@°_¡I
|
|
|
|
|
- ©«¤l
- 913
- ¥DÃD
- 150
- ºëµØ
- 0
- ¿n¤À
- 1089
- ÂI¦W
- 0
- §@·~¨t²Î
- win10
- ³nÅ骩¥»
- office 2019
- ¾\ŪÅv
- 50
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2011-8-28
- ³Ì«áµn¿ý
- 2023-7-19
|
¦^´_ 6# mark15jill
¯u¬O¦n¥Îªº³sµ²,¤S¤W¤FÄ_¶Qªº¤@½Ò! |
|
|
|
|
|
|
- ©«¤l
- 50
- ¥DÃD
- 12
- ºëµØ
- 0
- ¿n¤À
- 143
- ÂI¦W
- 0
- §@·~¨t²Î
- win xp
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- EARTH
- µù¥U®É¶¡
- 2010-5-24
- ³Ì«áµn¿ý
- 2015-5-12
|
¦^´_ syuan
TRY IT
ì©l½X
Sub Macro1()
'
' Macro1 Macro
'
' §Ö³tÁä: Ctrl+Shift ...
mark15jill µoªí©ó 2011-11-16 11:13
·PÁÂmark¤j¡ã¡ã
¹ê¦b«Ü©êºp¡A¨ì²{¦b¤~¦^ÂСI
¥Ø«e¤p§Ì¥¿¦b¸ÕµÛ®©³o¬qµ{¦¡¡A«Ý¦³°ÝÃD¦A¨Ó½Ð°Ý±z¡I
¯uªºÁÂÁ±z¡ã¡ã |
|
¿ú¬O«Ü±I²öªº¡A©Ò¥H·|·Q¿ìªk»E¦b¤@°_¡I
|
|
|
|
|
¡@¼ÊºÙ: ÀH·ÄÆ¿ºªº¦Ð¤ò ¡@ÀY»Î: [±s¥Î]¼ç¤ô¸¥
°ª¤¤¥Í
- ©«¤l
- 852
- ¥DÃD
- 79
- ºëµØ
- 0
- ¿n¤À
- 918
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows 7 , XP
- ³nÅ骩¥»
- Office 2007, Office 2003,Office 2010,YoZo Office
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¦t©z
- µù¥U®É¶¡
- 2011-4-8
- ³Ì«áµn¿ý
- 2024-2-21
|
¥»©«³Ì«á¥Ñ mark15jill ©ó 2011-11-16 12:00 ½s¿è
¦^´_ 1# syuan
TRY IT
TEST.rar (104.8 KB)
ì©l½X
Sub Macro1()
'
' Macro1 Macro
'
' §Ö³tÁä: Ctrl+Shift+Y
'
For XX = 1 To 65535
If Range("A" & XX).Value <> "" Then
RQ = Range("A" & XX).Value & Range("B" & XX).Value
Range("C" & XX).Select
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:=RQ & ".xlsx", _
TextToDisplay:=RQ
End If
Next XX
End Sub |
|
|
|
|
|
|
- ©«¤l
- 50
- ¥DÃD
- 12
- ºëµØ
- 0
- ¿n¤À
- 143
- ÂI¦W
- 0
- §@·~¨t²Î
- win xp
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- EARTH
- µù¥U®É¶¡
- 2010-5-24
- ³Ì«áµn¿ý
- 2015-5-12
|
¦^´_ syuan
¼Ó¤W¬O±Ð§A¨Ï¥Î¨ç¼Æ°µ¶W³sµ²¡A¥²¶·¦bÀx¦s®æ¤º¿é¤J¤½¦¡
n¨Ï¥ÎVBA¥i¨Ì¤U¦C¤è¦¡¥[¤J¶W³sµ²
...
Hsieh µoªí©ó 2011-11-9 22:26
·PÁÂhsieh¤jªº¦^ÂСã
¤p§Ì¨Sª`·N¨ì¨º¬O¨ç¼Æªº¥Îªk¡Aµ²ªG¤@ª½¦b¨ºÆp¤û¨¤¦y¡A¯u¬O¤£¦n·N«ä¤F¡ã¡ã |
|
¿ú¬O«Ü±I²öªº¡A©Ò¥H·|·Q¿ìªk»E¦b¤@°_¡I
|
|
|
|
|
- ©«¤l
- 50
- ¥DÃD
- 12
- ºëµØ
- 0
- ¿n¤À
- 143
- ÂI¦W
- 0
- §@·~¨t²Î
- win xp
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- EARTH
- µù¥U®É¶¡
- 2010-5-24
- ³Ì«áµn¿ý
- 2015-5-12
|
°²³]§AªºÀɦW¥s"N00-0000-2004Á³µ·.pdf"
¥i¥H¸Õ¤@¤U
downling µoªí©ó 2011-11-9 10:57
·PÁÂdownling¤jªº¦^ÂÐ
¤p§Ì¸Õ¤F¤@¤U¡Aµ²ªG¥X²{"Åܼƥ¼©w¸q"ªº°T®§¡I
¦Ó¥BHyperlinkªº¦r¦ê³Q¨t²Îµ¹°é¿ï¤F°_¨Ó¡A¤£ª¾¹D¬Oþ¥X¤F°ÝÃD¡I{:2_28:} |
|
¿ú¬O«Ü±I²öªº¡A©Ò¥H·|·Q¿ìªk»E¦b¤@°_¡I
|
|
|
|
|