brianr-is

Hi Alan, Does this syntax look correct: 1st line: Wait for Window Title: "Title="End of Report." Partial="FALSE" Wildcards="FALSE" Indefinite="FALSE" Hours="0" Minutes="0" Seconds="300"/> 2nd line: Text Type: Action="0" Text="<ENTER>" It doesn't seem to work right now. I did notice that when doing the steps of the routine manually that pressing the Enter key after receiving the Window Title End of Report works just like clicking the OK button in the Window Title End of Report.

Why do you have 300 seconds in the Window Title line? The amount of seconds varies with each record. Before, I only had the delay at 300 seconds to cover the longest running record loop.

Hi Alan, Should I replace the delay at the end of the loop with a Wait for Text command? Brian.

Hello Alan, At the end of each loop, I immediately get a text message box indicating End of report with an OK button that should be clicked. Brian.

Is there a way to adjust the delay in a macro when looping through each record. For example the first record loop may take 300 seconds, the next record loop may take 30 seconds, the next record may take 60 seconds, etc. So, right now the macro I use has a delay of 300 seconds to accommodate the longest loop but, that applies to all record loops. Brian.

I found a workaround in the application for this topic. There is a select all icon in the NUI version of the application that can be clicked on to highlight all of the records. Thanks anyway. Problem resolved.

There is no additional letter in the keystroke combination. It is strictly holding down the Shift + Right Control keys to highlight all records. I should have specified right control key. Brian.

This keystroke combination is used in our application to highlight several records and that is what I am trying to do. It works fine in the application but, not in the macro. Brian.

Hello, I tried incorporating the following keystroke combination (Shift + Control) into a macro and the macro is halted and doesn't seem to recognize that keystroke combination. Should this be happening? Brian.

Hello All, If a script is running, how am I able to stop it? I tried the same keystrokes that I used to start the script but, that didn't work. Brian.

Hello All, I would like to build a script or scripts to accomplish the following. I have to build a script(s) to login to our medical software, open an Excel spreadsheet with specific data, then copy and paste data from spreadsheet to Medical software routine several times, then logout of the software and close the spreadsheet. I would like to run this script(s) twice daily. Can I do this using the Capture routine in Macro Express 3.8a? Should I build more than one script to do this (i.e. build the login/logout script then build the looping script for the routine)? For example 1. Double click to open Excel Spreadsheet with data on desktop. 2. Login to Medical software from desktop. 3. Go to specific routine 4. Copy and paste data from spreadsheet to Medical Software routine that will loop many times until finished(i.e. at least 15 times) 5. Logout of Medical software. 6. Close Spreadsheet. Brian.

Hello, Is it possible to schedule a macro to run at a particular time of day? If so, what are the steps to scheduling a macro to run? Brian.

Hello All, Is there a limit on the speed of a macro that we create in Macro Express 3.x? I have gone up to 4 X normal speed of a macro but, not any faster. Brian.

Hello All, I figured this out: When copying from a column in Excel, to eliminate trailing spaces in column: 1. Highlight Column. 2. Click on Left Justify. 3. Click on Data\Text to Columns. 4. You're ready to script.

Hello All, When copying from Excel, how do I removed the trailing spaces from cells within a column? Currently when I copy from Excel and paste to a Third Party Software, the paste includes trailing spaces after the mnemonic. For example, I copied PHET25 a drug mnemonic in Excel which has 6 characters but, when I paste into the Third Party Software, I get 12 spaces and as a result the Third Party Software thinks it’s a new item with 12 characters. I only want to paste the contents of the cell (6 characters) and not the trailing spaces. Brian.