Search found 3471 matches

by JRL
Thu Sep 05, 2024 4:54 pm
Forum: Beginners
Topic: Pause and Resume a Macro?
Replies: 2
Views: 610

Re: Pause and Resume a Macro?

I'd use an OnEvent>key_down that goes to a subroutine that sets a flag variable. When the script is at a point where it can stop, test for the value of the flag variable. If the flag variable is set to pause, go to a modal message that says close this message to continue. Also reset the flag variabl...
by JRL
Thu Sep 05, 2024 2:26 pm
Forum: Beginners
Topic: Cannot Get WaitWindowOpen to work
Replies: 3
Views: 638

Re: Cannot Get WaitWindowOpen to work

:D
by JRL
Wed Sep 04, 2024 3:30 pm
Forum: Beginners
Topic: Cannot Get WaitWindowOpen to work
Replies: 3
Views: 638

Re: Cannot Get WaitWindowOpen to work

Here is a possible replacement for the built in WaitWindowOpen> function. Depends on whether or not your window shows up using GetWindowList>. If you want to wait a long time or forever, enter a big number for the timeout. Modify as needed. //GoSub>srtWaitWindowOpen,Criteria (Case Sensitive),Timeout...
by JRL
Thu Aug 29, 2024 2:15 pm
Forum: Beginners
Topic: Open Application With File
Replies: 4
Views: 1158

Re: Open Application With File

What happens if you rename the file by slapping a .PUB on the end of it then run ExecuteFile> :?:
by JRL
Wed Aug 21, 2024 1:22 pm
Forum: Beginners
Topic: OnEvent
Replies: 8
Views: 2859

Re: OnEvent

Dorian wrote:...and causing Excel to be "busy".
I don't have time to test but if multiple usage is the problem, might SHARING the files alleviate the issue?
by JRL
Thu Aug 15, 2024 1:26 pm
Forum: Enhancement Suggestions
Topic: Run As Administrator
Replies: 0
Views: 1373

Run As Administrator

I find myself writing more and more scripts that require admin privileges to run. After the script is working I will almost always compile it then right click the executable in Windows Explorer and choose the "Run as administrator" menu item. Problem is that while creating the script I have to do th...
by JRL
Wed Aug 14, 2024 3:22 pm
Forum: Beginners
Topic: OnEvent
Replies: 8
Views: 2859

Re: OnEvent

Dorian wrote:Excel can perform custom data verification...
nodochau might have an alternate method to accomplish his task. I'm still curious about why XLGetCell> would crash if it is used to monitor cell input. Seems like this should work.
by JRL
Wed Aug 14, 2024 2:26 pm
Forum: Beginners
Topic: OnEvent
Replies: 8
Views: 2859

Re: OnEvent

nodochau, I did some testing with your script. Based on your comment that it worked in the editor, I suspected a timing issue. Turns out that is not correct. Not being able to get the script to function I started boiling down to the essentials. If you take the script below and rewrite with your exce...
by JRL
Thu Aug 08, 2024 6:37 pm
Forum: Technical / Scripting
Topic: ScreenCapture with Cursor
Replies: 2
Views: 4021

Re: ScreenCapture with Cursor

And that is an AWESOME!!! fake.
by JRL
Fri Jul 26, 2024 3:14 pm
Forum: Enhancement Suggestions
Topic: PDF Display in a Dialog
Replies: 4
Views: 4139

Re: PDF Display in a Dialog

Thank you :D
Looking forward to seeing the new object/method and what we can do with it.
by JRL
Fri Jul 26, 2024 2:23 pm
Forum: Enhancement Suggestions
Topic: PDF Display in a Dialog
Replies: 4
Views: 4139

PDF Display in a Dialog

We can currently display BMPs, PNGs and JPGs within the image object of a Macro Scheduler dialog. I would find it very helpful to also be able to view PDFs in that image object.
by JRL
Fri Jun 28, 2024 9:23 pm
Forum: Technical / Scripting
Topic: Looking for a method to trigger when ANY window opens
Replies: 1
Views: 2497

Re: Looking for a method to trigger when ANY window opens

This could get really complicated, depending on what you want to accomplish. Let's start with easy. Let>msg_xpos=0 Let>msg_Ypos=0 Message>Macro Scheduler Message //Discover current Active Window GetActiveWindow>vTitleA,vXpos,vYpos ///////////////////////////// Label>Loop //Closes the script when the...
by JRL
Thu Jun 27, 2024 2:26 pm
Forum: The Water Cooler
Topic: ChromeDriver vs EdgeDriver
Replies: 0
Views: 8053

ChromeDriver vs EdgeDriver

Does anyone have any experience you can share regarding which of these has been more reliable for you? I hate automating web pages. The pages I've been tasked with automating in the past mostly belong to large customers. They have development teams who can't seem to leave well enough alone. I don't ...
by JRL
Tue Jun 25, 2024 6:22 pm
Forum: Technical / Scripting
Topic: How to hide or remove Windows title bar
Replies: 5
Views: 4506

Re: How to hide or remove Windows title bar

Perhaps SetParent would do what you want. See Marcus' example here . The sample uses Internet Explorer, you will want to use a different browser of your choice. The reason I think SetParent might help is that the browser window can be positioned in the dialog such that the upper portion of the brows...
Sign up to our newsletter for free automation tips, tricks & discounts