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.

Hello All,

I got the script to finally loop through multiple records. The problem was that I didn’t save the Script Editor Repeat commands after putting them in place in the Scripting Editor.

Brian.

Hello All,

We have Macro Express 3.8a. I have created a macro script to run a set of steps in updating a tax code field in our Hospital database from an excel spreadsheet. This works fine for one record before it stops, however, I tried using the Script Editor's Repeat commands to make this macro run for multiple records and I haven't had any success. Currently, I have a Repeat Prompt Start command in the Insert Before in the script and Repeat Exit in the Add to End in the script yet, the macro only runs one record only. Can anybody advise me how I can get this macro script to repeat over multiple records using the Repeat commands? Bear with me, we just got the tool and it's my first script.

Brian.