Check Excel load completed

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

@anh.nguyen

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

1 Like

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 :frowning: or other form

@anh.nguyen

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.

@anh.nguyen

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

1 Like

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)

@anh.nguyen

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

1 Like