Private Sub CommandButton1_Click() Dim f As String Dim i As Integer Dim P as String '存放文件的路径 f = Dir(p & "\*.xls") ' 换成CAD文件的扩展名,这里以Excel文件为例 Do While f <> "" i = i + 1 Sheet1.Hyperlinks.Add Sheet1.Cells(i, 1), f f = Dir() Loop End Sub
'那就换个事件,比如SelectionChange,当然也可以用其它合适的事件 Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim f As String Dim i As Integer f = Dir(ThisWorkbook.Path & "\*.xls") '要修改路径及扩展名 Do While f <> "" i = i + 1 'Sheet1.Cells(i, 1).Value = f Sheet1.Hyperlinks.Add Sheet1.Cells(i, 1), f f = Dir() Loop End Sub
ThisWorkbook.Path这个是填路径吗 好像我的没有反应呀 Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim f As String Dim i As Integer f = Dir(ThisWorkbook.Path & "\租赁工作进度周报表.xlt") '要修改路径及扩展名 Do While f <> "" i = i + 1 'Sheet1.Cells(i, 1).Value = f Sheet1.Hyperlinks.Add Sheet1.Cells(i, 1), f f = Dir() Loop End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim f As String Dim i As Integer Dim p as string p="D:\myCAD\" '假定你的AutoCad文件都放在D:\Mycad文件夹中 f = Dir(p & "\*.dwg") Do While f <> "" i = i + 1 'Sheet1.Cells(i, 1).Value = f Sheet1.Hyperlinks.Add Sheet1.Cells(i, 1), f f = Dir() Loop End Sub
Dim f As String
Dim i As Integer
Dim P as String '存放文件的路径 f = Dir(p & "\*.xls") ' 换成CAD文件的扩展名,这里以Excel文件为例
Do While f <> ""
i = i + 1
Sheet1.Hyperlinks.Add Sheet1.Cells(i, 1), f
f = Dir()
Loop
End Sub
我要单击那个单元格就出相应的
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim f As String
Dim i As Integer
f = Dir(ThisWorkbook.Path & "\*.xls") '要修改路径及扩展名
Do While f <> ""
i = i + 1
'Sheet1.Cells(i, 1).Value = f
Sheet1.Hyperlinks.Add Sheet1.Cells(i, 1), f
f = Dir()
Loop
End Sub
忘掉宏吧!!!
好像我的没有反应呀
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim f As String
Dim i As Integer
f = Dir(ThisWorkbook.Path & "\租赁工作进度周报表.xlt") '要修改路径及扩展名
Do While f <> ""
i = i + 1
'Sheet1.Cells(i, 1).Value = f
Sheet1.Hyperlinks.Add Sheet1.Cells(i, 1), f
f = Dir()
Loop
End Sub
Dim f As String
Dim i As Integer
Dim p as string
p="D:\myCAD\" '假定你的AutoCad文件都放在D:\Mycad文件夹中
f = Dir(p & "\*.dwg")
Do While f <> ""
i = i + 1
'Sheet1.Cells(i, 1).Value = f
Sheet1.Hyperlinks.Add Sheet1.Cells(i, 1), f
f = Dir()
Loop
End Sub
p="D:\myCAD" '假定你的AutoCad文件都放在D:\Mycad文件夹中
不管我是在模块里写的还是在sheet1里写,就是没用
你试了吗
这是我的邮箱
273527547
这是我的QQ号