if popup window is from Excel, then this procedure cannot handle? so this procedure can only handle popup windows raised from programs other than Excel?
I thought you were going to explain to get the handle of a child after the button to call it was clicked by the parent. I'm trying to do that and the code stalls after the child window appears.
I am facing a problem.....I want to click ok on pop up message ,that appears on Excel sheet, using vba code..... please tell me command..... thanks in advance
Thank-you for the video. It is very clear you are a great teacher. The code worked great on my computer. I tried to use it on a colleague's computer. And the code froze on the outer loop after 267 handles. His computer processor is not as fast as mine. Is there a change that can me made to the code to accommodate a slower processor?
Bart, my vba is throwing me the next message when i copy the code: "The code in this project must be updated for use on 64-bit systems. Please review and update Declare statements and then mark them with PtrSafe attribute" Can you help me with this??
Hi Alejandro More. The declaration of the API's is slightly different for the 64bit system than the 32bit system. You need to add "PtrSafe" after "Declare".
Hello Bart thank you for you code. It's working perfect, but when file with the same name exist then vba is throwing me the confirmation message "Confirm save as". I tried to develop the "Child3", but vba is freezing on moment confirmation message appears. Thank you:)
Hi Sviatoslav. I've encountered this issue as well in the past. I am not sure where the script is but here is what I did: First, create a vbs script to push the button which loops until the button is found. Next, call the script just before the line where your VBA script stops. If this isn't clear enough then I'll try to explain it in more detail at a later point.
Hi Bart, thank you for reply. I found video on youtube explaining the idea you described - ruclips.net/video/G-2khNFYQl8/видео.html . But I'm just wondering is there way loop for intial window "save as" as well and do it in one vbs script.
Hey, amazing video
if popup window is from Excel, then this procedure cannot handle? so this procedure can only handle popup windows raised from programs other than Excel?
Thank u so much. I love you bro
I thought you were going to explain to get the handle of a child after the button to call it was clicked by the parent. I'm trying to do that and the code stalls after the child window appears.
I am facing a problem.....I want to click ok on pop up message ,that appears on Excel sheet, using vba code..... please tell me command..... thanks in advance
Please share the code
Thank-you for the video. It is very clear you are a great teacher. The code worked great on my computer. I tried to use it on a colleague's computer. And the code froze on the outer loop after 267 handles. His computer processor is not as fast as mine. Is there a change that can me made to the code to accommodate a slower processor?
Sorry we were having network problems and that appears to have been the cause of the problem.
Bart, my vba is throwing me the next message when i copy the code:
"The code in this project must be updated for use on 64-bit systems. Please review and update Declare statements and then mark them with PtrSafe attribute"
Can you help me with this??
Hi Alejandro More. The declaration of the API's is slightly different for the 64bit system than the 32bit system. You need to add "PtrSafe" after "Declare".
Hello Bart thank you for you code. It's working perfect, but when file with the same name exist then vba is throwing me the confirmation message "Confirm save as". I tried to develop the "Child3", but vba is freezing on moment confirmation message appears. Thank you:)
Hi Sviatoslav. Is the problem that VBA doesn't go to the next line of code until the extra popup disappeared?
Hello Bart, thank you for reply. Yes, correct. Can you advice some workaround?
Hi Sviatoslav. I've encountered this issue as well in the past. I am not sure where the script is but here is what I did: First, create a vbs script to push the button which loops until the button is found. Next, call the script just before the line where your VBA script stops.
If this isn't clear enough then I'll try to explain it in more detail at a later point.
Hi Bart, thank you for reply. I found video on youtube explaining the idea you described - ruclips.net/video/G-2khNFYQl8/видео.html . But I'm just wondering is there way loop for intial window "save as" as well and do it in one vbs script.
Can u share code pl
muy bueno,, go on.