|
- Sub 另存工作表保留格式()
- Dim arr, myname$, whname$, st$, shap As Shape
- arr = ThisWorkbook.Sheets(1).[a1].CurrentRegion
- myname = Application.GetOpenFilename("excel文件,*.xls*")
- If myname <> "False" Then
- With Workbooks.Open(myname)
- st = Application.InputBox("请输入要保存的工作表名", "输入")
- .Sheets.Add after:=Sheets(Sheets.Count)
- ActiveSheet.Name = st
- ThisWorkbook.Sheets(1).UsedRange.Copy
- .Sheets(st).[a1].PasteSpecial Paste:=xlPasteFormats
- .Sheets(st).[a1].PasteSpecial Paste:=xlPasteColumnWidths
- .Sheets(st).[a1].Resize(UBound(arr), UBound(arr, 2)) = arr
- .Close True
- End With
- Else
- Exit Sub
- End If
- End Sub
复制代码 |
|