比如我要给 A5 添加"c:\1.jpg"链接
æ°å»ºä¸ä¸ªEXCELè¡¨æ ¼ï¼å¦å为å¯ç¨å®çå·¥ä½è
å¨èåæ ï¼éæ©å¼åå·¥å ·ï¼ç¹å»ä¸Visual Basicåï¼å¯å¨EXCEL VBAã
å¨å¼åå·¥å ·ä¸ï¼éæ©æå ¥-ActiveXæ件ä¸çæé®å·¥å ·ï¼å建ä¸ä¸ªæé®ã
å¨EXCEL VBAä¸ï¼ç¹å»æå ¥-ç¨æ·çªä½ï¼æå ¥çªä½æ件ã
ä¾æ¬¡æ·»å æ ç¾ï¼ææ¬æ¡å2个æé®ï¼
åå»âæå®æ件路å¾âæé®ï¼æ·»å å¦ä¸ä»£ç ï¼
ããDim objShell
ããDim objFolder
ããDim strPath As String
ãã
ããSet objShell = CreateObject("Shell.Application")
ãã
ããSet objFolder = objShell.BrowseForFolder(0, "éæ©æ件ç®å½", 0, 0)
ãã
ããIf Not objFolder Is Nothing Then
ããTextBox1.Text = objFolder.self.Path
ããElse
ããTextBox1.Text = ""
ããEnd If
ãã
ããSet objFolder = Nothing
ããSet objShell = Nothing
ããç¹å»âæ·»å è¶ é¾æ¥âæé®ï¼å å ¥å¦ä¸ä»£ç ï¼
ããDim MyPath, Myname As String
ããDim i, q, n As Integer
ããDim sht As Worksheet
ããMyPath = TextBox1.Text & "\"
ããMyname = Dir(MyPath, vbDirectory) '读åæå®ç®å½ä¸ç第ä¸ä¸ªæ件夹å称
ããSet sht = ActiveWorkbook.Sheets(1)
ããn = ActiveSheet.UsedRange.Rows.Count 'æå®n为æ大è¡æ°
ããIf TextBox1.Text = "" Then MsgBox ("请è¾å ¥å°å")
ãã
ããDo While Myname <> ""
ããFor i = 2 To n
ããIf Myname <> "." And Myname <> ".." Then
ããIf Myname = sht.Cells(i, 1) Then
ããsht.Hyperlinks.Add anchor:=sht.Cells(i, 1), Address:=MyPath & Myname & "\"
ããElse
ããEnd If
ããEnd If
ããNext i
ããMyname = Dir
ããLoop
ãã7. è¿åå°è¡¨æ ¼æ件ä¸ï¼åå»âæ·»å è¶ é¾æ¥âæé®ï¼æ·»å å¦ä¸ä»£ç ï¼å¯å¨çªä½æ件ã
ããUserForm1.Showï¼ä¿åéåºã
ãã8. éåºè®¾è®¡æ¨¡å¼ï¼ç¹å»âæ·»å è¶ é¾æ¥âæé®ï¼æå®æ件路å¾ï¼ç¹å»çªä½ä¸çâæ·»å è¶ é¾æ¥âãå®ææ·»å è¶ é¾æ¥ã
ãã9. ç¹å»æ¯ä¸ä¸ªæ件å称åï¼å°±å¯ä»¥æå¼å ¶å¯¹åºçæ件夹äºã