呼叫程序问题 [英] Call Procedure Question

问题描述

我从一个受保护的驱动器调用一系列存储过程，但是当我调用这些过程时，受保护驱动器上的工作簿变为可见，我不能拥有。如何防止工作簿打开？顺便说一句
我在XP和VBA上使用XL2007。

I am calling a series of stored procedures from a protected drive that works quite well, except that when I call the procedures the workbook on the protected drive becomes visible and I can't have that. How do I keep the workbook from opening? By the way I am using XL2007 on XP and VBA.

谢谢。

Mark

推荐答案

标记，我们需要查看您的代码与相关工作簿的交互。通常，您可以使用此方法隐藏您打开的工作簿。

Mark, We need to see your code where your are interacting with the relevant workbook. Usually, you can use this method to hide the workbook that you open.

Sub Sample()
    Dim wb As Workbook
    
    Set wb = Workbooks.Open("C:\MyFile.xlsx")
    
    Windows(wb.Name).Visible = False
End Sub

这篇关于呼叫程序问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！