|
楼主 |
发表于 2013-10-22 11:06
|
显示全部楼层
laicaiqian12 发表于 2013-10-22 11:02
但问题是我并不是所有的工号都在D2单元格,貌似我测试也能正确命名的? - Sub a()
- Set dig = Application.FileDialog(msoFileDialogFolderPicker)
- With dig
- .InitialFileName = ThisWorkbook.Path
- .InitialView = msoFileDialogViewDetails
- .Title = "保存"
- If .Show = 0 Then
- Exit Sub
- End If
- End With
- Do While Sheets.Count <> 0
- st = Sheets(1).Name
- For i = 2 To Sheets.Count
- If InStr(Sheets(i).Name, Sheets(1).Name) Then
- st = st & "," & Sheets(i).Name
- End If
- Next
- ar = Split(st, ",")
- If Sheets.Count > UBound(ar) + 1 Then
- Sheets(ar).Move
- ActiveWorkbook.SaveAs dig.SelectedItems.Item(1) & "" & Split(Sheets(1).Range("d2"), ":")(1)
- ActiveWorkbook.Close True
- Else
- ActiveWorkbook.SaveAs dig.SelectedItems.Item(1) & "" & Split(Sheets(1).Range("d2"), ":")(1)
- ActiveWorkbook.Close True
- End If
- Loop
- End Sub
复制代码 这里有用到D2单元格,意思是说新生成的文件用对应表格中D2单元格的工号命名么?
但问题是我并不是所有的工号都在D2单元格,貌似我测试也能正确命名的?
|
|