Herry Markowitz
Well-known member
- Joined
- Oct 22, 2015
- Messages
- 46
- Programming Experience
- 1-3
I am wating 10 seconds before xlApp declaration because C:\Book1.xlsx is a very big file and takes long time to open.
I want to replace above code like below code.
Below code need to be repaired.
VB.NET:
Process.Start("C:\Book1.xlsx")
Threading.Thread.Sleep(10000)
Dim xlApp As Excel.Application = Nothing
xlApp = CType(GetObject(Nothing, "Excel.Application"), Excel.Application)
I want to replace above code like below code.
Below code need to be repaired.
VB.NET:
Process.Start("C:\Book1.xlsx")
Do While SOMETHING
Application.DoEvents()
Loop
Dim xlApp As Excel.Application = Nothing
xlApp = CType(GetObject(Nothing, "Excel.Application"), Excel.Application)