After I open the first excel window I keep getting this window below.
在我打开第一个excel窗口后，我一直得到下面这个窗口。
Is there any way I can avoid this? I know the reason is because it can't get the write permission but I need to be able to use a macro across multiple excel files that I have open at the same time. I need to have more than 1 excel file open as it is work.
有什么办法可以避免这种情况吗?我知道原因是它不能获得写权限，但我需要能够在同时打开的多个excel文件中使用宏。我需要打开一个以上的excel文件，因为它是工作。
Is there a solution?
有解决方案吗?
2 个解决方案
#1
1
You can keep multiple files open in the workbooks collection, use it instead of window, or you could just disable notifications.. (http://www.excely.com/excel-vba/disable-alert-warning-messages.shtml)
您可以在工作簿集合中保持多个文件的打开，使用它而不是窗口，或者您可以禁用通知。(http://www.excely.com/excel-vba/disable-alert-warning-messages.shtml)
#2
0
Application.DisplayAlerts = False 'In order to bypass the clipboard prompt
Workbooks.Open filename:=PERSONAL.XLS, notify:=True
#1
1
You can keep multiple files open in the workbooks collection, use it instead of window, or you could just disable notifications.. (http://www.excely.com/excel-vba/disable-alert-warning-messages.shtml)
您可以在工作簿集合中保持多个文件的打开，使用它而不是窗口，或者您可以禁用通知。(http://www.excely.com/excel-vba/disable-alert-warning-messages.shtml)
#2
0
Application.DisplayAlerts = False 'In order to bypass the clipboard prompt
Workbooks.Open filename:=PERSONAL.XLS, notify:=True