这是怎么了?
以下代码预先修改了被引用工作薄B的工作表窗口重新显示(IsAddin =FALSE),但是当打开B薄后仍然不能正常显示出B薄工作表窗口,仍然还是需要在ThisWorkbook属性窗口先手动IsAddin改为:TRUE,再改为:FALSE后才能生效.但是在ThisWorkbook属性窗口中的IsAddin 确实已经修改=FALSE了.为什么不能生效?
请高手指点并修改一下代码.
Sub 向指定路径工作薄输入数据()
Dim el As Object, sh As Worksheet
Set el = GetObject("E:\B.xls")
Set sh = el.Sheets("Sheet1")
sh.Range("a5") = 12345
sh.Range("B5") = Sheet1.Cells(1, 1)
With el
.IsAddin = False '重新设定被引用工作薄之工作表窗口处于打开状态
.Saved = False
.Save
.Close
End With
Set el = Nothing
Set sh = Nothing
End Sub
- Sub 向指定路径工作薄输入数据()
- Dim el As Object, sh As Worksheet
- Application.ScreenUpdating = False
- Application.DisplayAlerts = False
- Set el = GetObject("E:\B.xls")
- Set sh = el.Sheets("Sheet1")
- sh.Range("a5") = 12345
- sh.Range("B5") = Sheet1.Cells(1, 1)
- Application.Windows(el.Name).Visible = True
- el.Close 1
- Application.DisplayAlerts = True
- Application.ScreenUpdating = True
- End Sub
复制代码
|