After finishing the above settings, please exit Design mode, and, your specified video is playing now. (2.) Copy and paste your video file path which should include the file extension into the URL field.Ĥ. (1.) In the Alphabetic tab, please select True option from the fullScreen field Then go to the Properties dialog by clicking Developer > Properties, in the Properties dialog, please do the following operations:
In the More Controls dialog box, scroll and select Windows Media Player option, then click OK button to close the dialog, and then drag the mouse to draw a Windows Media Play object, see screenshot:ģ. Click Developer > Insert > More Controls, see screenshot:Ģ. In Excel, there is a useful control - Windows Media Play can help you to play a video file, please do as follows:ġ. It's close to what I was doing, but is not based on time (I'm referring to Bob Bedell's reply).Amazing! Using Efficient Tabs in Excel Like Chrome, Firefox and Safari! Save 50% of your time, and reduce thousands of mouse clicks for you every day! I purchased the "Excel 2007 vba Programmer's Reference" Published by Wrox and came across a similar problem. It actually helped to solve a related problem in another area of the program.
That was a different way of looking at the problem and got me thinking in a new direction. I was on the right track, just in the wrong direction. I was trying to use a time statement to get the program to "wait" before checking an external condition again and again until it was true. The issue I was having is that excel would fail to respond when I trapped the execution in a seemingly endless loop using a 'wait until -> do events' method. The user can now pick a line in the data file to start at and the code will cycle through until it reaches that line. I thought about that and incorporated into into my code in a different context. Sorry for the late reply, it's been super busy here. I have no problems breaking the operation with the Escape key after Excel 'Stops Responding'.Īny ideas? RE: Macro resume based on user condition HarlanJ (Industrial) I'm guessing Windows XP determines that a program is failing to respond if it continues to execute the same code without change for more than 15 seconds. A side effect of this method is that Excel will fail to respond after 10-15 seconds. UserWantsToResume = False 'Right after the user decides to resume code execution, This variable is reset until we need to wait again.Īfter the user clicks the Resume button on the worksheet, "UserWantsToResume" is then True and the code continues as normal.
While timer < Wait + 10 'wait 10 seconds before checking again "UserToldProgramToWait" is the subroutine I'm playing with that would ideally hold execution indefinately like the text box.ĭo Until UserWantsToResume = True 'Until the user clicks the resume button the program will run this loop and pause for 5 seconds before checking again. A textbox is displayed, notifying the user that the macro has been paused, and execution stops until the user closes it. "Pause" is a boolean public variable updated when a command button on the active worksheet is clicked (changes to "true"). Pause = False 'the user decided to continue, so the program is no longer paused Sheets("Start Page").PauseLabel.Caption = "" Pause = False 'The user decided to quit, so the program no longer needs to be paused Continue?", vbYesNo, "Dryer Data Extraction Tool") = vbNo Then ' While timer < Wait + 2.05 'time in seconds to wait while the "Paused" Label is updated Sheets("Start Page").PauseLabel.Caption = "Paused" If Pause = True Then 'if the user wants to pause the output a message box notifies them and asks to continue