新手求助!为什么分离出来的工作表传到其它电脑上有公式的不能看,可否帮忙更改一下代码,将分离出来的内容不与原表相关联。
Sub s1()
Dim sh As Worksheet
Sheets("日模板").Copy
Set wb = ActiveWorkbook
wb.SaveAs ThisWorkbook.Path & "/1日.xls"
wb.Close True
End Sub
Sub s2()
Dim x As Integer
Dim sh As Worksheet
Dim str As String
For x = 1 To Sheets.Count
Set Sheets(x) = sh
Set sh = ActiveWorksheet
str = Sheets(x).Name
sh.SaveAs ThisWorkbook.Path & "/str.xls"
Exit Sub
Next
End Sub