|
楼主 |
发表于 2015-5-2 21:06
|
显示全部楼层
殿堂之上 发表于 2015-5-2 14:33
你看下,这是我这边的啊,我这里用的好好的啊,你怎么用不了?只是最后有个版本不一样出现的那个啊
我用的excel2003和wps excel,执行的结果都是一样的,你用的2007或者更高的吗?会不会里面有些不同啊?请您看一下代码是不是变动了?谢谢!- Sub ql()
- Dim myApp As New Application
- Dim sh As Worksheet
- Set dig = Application.FileDialog(msoFileDialogFilePicker)
- With dig
- .AllowMultiSelect = True
- .Filters.Add "Excel文件", "*.xls", 1
- .InitialFileName = ThisWorkbook.Path
- .InitialView = msoFileDialogViewDetails
- .Title = "打开"
- If .Show = 0 Then
- Exit Sub
- End If
- End With
- For Each f In dig.SelectedItems
- Set sh = myApp.Workbooks.Open(f).Sheets(1)
- n1 = Split(f, "(")(1)
- n2 = VBA.Val(Split(n1, ")")(0))
- Cells(2, n2 + 1) = sh.Range("f2")
- Cells(3, n2 + 1) = sh.Range("f4")
- n2 = n2 + 1
- Next f
- myApp.Quit
- End Sub
复制代码 |
|