新聞財經娛樂♬資訊 News Economy

it is hard to say my problem that is related to Virus or my VBA program.
After check with virus software there is no any issue.
I found the strange  thing when I'm running my VBA program Subroutine
and set break point at some area by F9  to stop program at  a breakpoint in advance
When VBA program is running and stop at the break pt,   and then I
run explorer.exe to open other  old excel file but I can't open it until  i finish my subroutine
program or reset the VBA program  completely . After complete the subroutine or reset program .
I mouse-click  the old excel file in explorer folder that  can be shown up within the same  Excel application windows.
I never experience this before. Generally for debugging process, sometimes we always  would like to stop VBA program
at breaking point set by F9 at the begining program start, and then open other new/old  EXcel file  that we are
 always no any issue and easy task .

FOr my VBA program, I am doing a lot sending key and sleep like a.sendkey{"enter"} and Sleep(10),
now I suspect those code make a problem or lock the folder directory or ohter Excel file during debugging.

Is there any method to check the old Excel file statue before opening and unlock the file once it is locked
by (or during) other Excel VBA programming ?

Please advise

Duncan

VBA program:Sub DebuggingVBA()Dim a, WScript As ObjectDim waitcont As Integerwaitcont = 5Set a = CreateObject("WScript.shell")a.sendkeys {"enter"}sleep(1000);' Set a breakpoint by F9 before   here  and then go to open other new/old Excel'file  from explorer.exe folder if program is stopped at this breaking pt' but the new/old excel file  can't be opened till going to "ENDSub" statement"DOeventsa.sendkeys {"enter"}End Sub   ' WHen  the VBA program  is coming at this pt by F8  and finished the sub or reset the program , I am able to open the other new/old Excel file....                                  

1:2:3:4:5:6:7:8:9:10:11:12:13:14:15:16:17:18: