Hello,
I find on the forum but don’t have the answer.
I use Get Attribute position Column F3:
When my excel loading & done. Size dififrent column F3
How can check Excel load completed. Thank you
Hello,
I find on the forum but don’t have the answer.
I use Get Attribute position Column F3:
When my excel loading & done. Size dififrent column F3
I guess this is not what you need to use…
Can you first tell what you want to do on excel?
Ideally for excel we have activities already to do many things…
If you still want to do from front end…generally excel will show ready at the right bottom of the screen we can try cqpturing that…
But as mentioned earlier…excel has its activities…search in activities with name excel you can find them
Hope this helps
Cheers
Hi,
I need Click Export Excel and waiting load done then run code vba.
This form use VB so can’t use Get Attribute check button or other form
Other than the load…from the bottom bottom of the window are you able to find any statuses? Like ready…running or anything…we can use them
Cheers
Unfortunately the form status has not changed.
Is it possible to show a short video of what happends when you clicka nd what changes are happening …
Or you can also observe if other than column width change if anything else is happening
Cheers
I use Get Postion Cell F3: {X=731,Y=400,Width=695,Height=17}
I want condition Do While: if position is not {X=731,Y=400,Width=695,Height=17} repeat waiting, else
continue (it means Excel load is done)
The condition can be like this
GetPosition.x.Equals(725) And GetPosition.y.Equals(725) And GetPosition.width.Equals(695) And GetPosition.Height.Equals(17)
Hope this helps
Cheers