cyberchief

I know licensing might be an issue. My concern is that each virtual connection would be running a different library. And I have no idea if this will work or not.

Currently, we have 50+ workstations set up with ME to process multiple projects. Some the same macros, some different. They change all the time depending on the project. Because we are using so many resources (computers) and our projects are growing, the question has come up on whether or not we could run ME off of a server. Specifically, we would lose our actual desktops, and each keyboard/monitor would be directly connected to the server. now, my first thought is that since ME runs off of each individual computer, how would a server react to 60+ sessions logged in all trying to run different macros at the same time. Any thoughts? I am thinking this is not possible, but wanted to get opinions.

I do something similar to Cory... but rather than looking for conditions ON the screen... I set a loop to repeat until a specific Window Title is there. I would think that, unless you are working in mulitple web pages or windows with the same names, this would work a little more efficiently. Something like this: Repeat Start (Repeat 60 times) Variable Set String %T1% from Window Title If Variable %T1% contains "Macro Express Forums" Break End If Delay 1 Seconds Repeat End If Variable %T1% does not contain "Macro Express Forums" E-Mail Send: Know Recipients, Fixed Text, No Attachments Macro Return End If

Actually, we use the "get pixel color" command quite a bit. I find that on a lot of our native applications as well as the web applications, the "boxes" are not built as controls... So, our workaround was to watch the application for color changes specific to that process. Speaking of which... I may have posted this before... but I find that 'wait for webpage to load' does not work on many of our macros very well. The page will show loaded without the information appearing on the screen and causing the macro to continue prematurely. We use the "get pixel color" command twice in a repeat loop on the bottom status bar of the webpage. When you load a page, you get the little colored bar that fills out a section, then disappears again. We use get pixel to wait for the color to change once (showing the page loading) and then wait for it to go back to normal (finished loading). I find this to be more accurate than the 'wait for webpage" command. This DOES require the webpage to be maximized and you would have to modify the macro to match the color of your normal taskbar... but it works quite nicely... Repeat Until %T1% <> %T1% Get Pixel: Screen Coords: 726,703 into %N1% If Variable %N1% <> 13160660 Repeat Until %T1% <> %T1% Get Pixel: Screen Coords: 726,703 into %N1% If Variable %N1% = 13160660 Break End If Repeat End Break End If Repeat End

Agreed with Joe and Cory. We have been running ME for about 3 years. Over 500 working macros. We have installed the version updates as they come out on over 50 machines. Never had to modify any coding due to the upgrades. Not to make any accusations... but sounds like your "expert" may be a little self-concious of his/her own abilities to manage the scripts?

I was trying that yesterday before I posted this, but no go. Still didn't work. I created a work-around by activating the start/run command and using text type with the full file path. That will work I guess.

I am trying to create a extremely simple macro. Launch an excel file and navigate a couple options. Problem is that the excel file is incoded with macros and coding. I am using the program launch command. But it appears that macro sits and waits for the window title... but the excel document is programmed to prompt a user with a yes/no option box (run the imbeded excel macro or not). Macro will not continue running due to the fact that the excel file has not fully launched. The purpose of the macro I am building in ME is to select one of the options in that prompt box. But, again, ME sits and waits for the excel file. Anyone know of a way around this? To get macro to NOT wait for the file? Basically to blindly launch it?

Hey Joe... Another question for you. In the Example "Activate Workbook - Interactive"... Had a question on your coding. You set T11 to the path of the applet... and you set T14 to the applet name. Seems to me like this is a waste of variables. Couldn't you set T14 to be the entire path and application? In my world, variables are at a premium. I need to cut waste wherever I can because some of our programs are stretched to the brink. Let me know your thoughts on why it was programmed this way.

Joe, Working with that applet now. All I can say is... WOW!!! This is exactly what I needed. I can modify this to do quite a few things that I handn't been able to do in the past. Great work!!!

Thanks Joe! Been pretty busy so haven't had much time to post on here. I do read through the threads regularly... but don't always have time to reply. And thanks for making those corrections to the re-direct. Couldn't figure out what was going on. I saw your post before regarding the Excel functions. I didn't go into it deep enough because I thought it had to do with mulitple workbooks rather than worksheets. I am going to give it a look. Thanks!!!

I would be interested in this as well... have run across this a few times. Also in an application.

Joe, Maybe this has been done before... and I am just too lazy to search, but I have a project on my table right now that requires me to view different tabs within an excel file. I need excel to launch a program, and I need to be able to navigate to a specific tab. Have you done this before? I am not an excel expert, but I don't see a way to navigate directly to a specific worksheet.

First off, no reason to feel silly. We get many questions from users that have purchased ME for gaming. Quite honestly, I think using it to enter contests makes more sense than gaming. To point you in the right direction, I would suggest you look into the repeat commands.

blopib, To copy the command text... select all the code you want to copy, right click and select "Copy Command Text". This will take out the coding for you. Here you go.. Variable Set Integer %N1% to 1 Repeat Start (Repeat 50 times) Variable Set String %T1% "dc" Variable Set String %T2% "%T1%%N1%" // Text Box Display is only to show the result in T2 for example: dc1 Text Box Display: Show the value of %T2% Variable Modify Integer: Inc (%N1%) Repeat End

Rustywinger, Just a small suggestion... because I, like you, like order in my macros... Rather than using Repeat Until %T39% = "8" for infinite loops, I use "Repeat Until %T1% <> %T1%"... basically, repeat until T1 does not equal T1... since T1 will always = T1... it will keep going until another set of requirements have been met. Just a suggestion to keep it clean. I use this quite frequently. And you will never have to worry about using up a variable.

Thanks Kevin... that fix won't work since the additional recipients need to see the MAIN recipient... and the specific email recipient position that we are having trouble with ALSO needs to see the others as well. I have been working on modifying the macro to log the errors, then "process text file" to see if an error appears after the send. If so, then crop the characters around the email address, remove from the list of recipients, and resend to everyone else. After that, clear the email error log with an overwrite. That way, everytime it runs, it is working off of a clean email error log and will only see the most recent error.

We have a few programs that send emails out directly off of the mail server. These are always to internal employees. When a user is no longer in the system, the emails fail. We used to have it throw up a prompt box, but we changed it to just logging the errors so it would not crash the macro. Our problem is that these emails go to multiple people, and if there is 1 user that no longer exists, NO email goes out at all. Is there a way to force macro to still send that email out to the other users?

I run macros from my laptop as well... here is my suggestion... on the main macro toolbar, go to Options, then to Preferences. On the lefthand menu, select "Playback". Here, you can change the keys that will pause or abort a macro. I do not use the abort command, I always use the pause command (it puts up a prompt box to continue or abort). For the Pause Macro Hotkey, I have the "Pause" key selected. Then, on my laptop, I hit the function key and the Pause key at the same time... and that will stop the macro.

This sounds a little weird.... but.... About half of the macros I have built are reliant upon pixel colors or icon positioning to process the commands I have told it to. For example... one macro will wait until a certail area of the screen to turn blue before continuing. This was our last resort because we could not find any other way to time the macro to wait for a new screen to appear (title does not change). Anyway, we have 50 computers set up to run macros. Some of the settings (color preferences) are different by machine. As well, it appears that an icon on one machine does not always appear in the same position as another machine... maybe due to font sizes or something else. Is there a way for Macro to capture the preferences on one computer, save it to some sort of file, and set up the other macros to "read" this setting and change its own settings before continuing? I dont' think there is any way to do this... just kind of a shot in the dark. Thanks!!!

I've been working with the program for much longer and I'm still learning new things! Here's a challenge to all: If you post a cool topic, tip, or macro on the forum we will feature it in the Macro Express News email newsletter. You will get your name in lights (well in the newsletter and on our website) and receive a cool Macro Express T-shirt. The topic, tip or macro will be selected solely by Insight Software Solutions. Preference will be give to an item that that teaches us (Insight Software Solutions people) something new about Macro Express, or items with the broadest appeal. We will accept and consider nominations. If you spot a topic, tip, or macro that you think is deserving of wider publication (and a T-shirt), let us know and we'll consider it. Here are two recent examples of terrific topics that taught us something completely new about Macro Express. Populate a Multiple Choice Menu from a text variable posted by Cory Jackson. This tip will be featured in the next edition of the Macro Express News that should be available shortly (June 2007). Right Click on a File and Run a Macro posted by Paul Thornett. This tip will be featured in an upcoming edition of the Macro Express News. This item will be also posted as a separate topic to make it available to more forum readers. Cool. Do I get a T-Shirt???? Just kidding. Thanks again, Kevin!!!

Uhg... Thanks Kevin! That is what I was looking for. See? Been working with this program for 2+ years and still always learning. Thanks again!

The specific error message states: Exception: 550 5.1.1 <David.Barber383838@email.com>... User Unknown I am guessing that this is due to Macro checking the mail server to see if the user exists. It is a ME error, not a Windows error. I would like to be able to capture that error and have the macro continue running rather than aborting.

I know that the email format is correct... it is just when the specific email address doesn't exist. Macro tries to send an email, but it stops and says "xxx@email.com does not exist" and gives me an OK button to click on. I click OK, and macro aborts. There is no crash.

Is there a way to prevent ME from crashing when it finds a bad email address on the email send command?

Has anyone been successful or found a way to use a new incoming email as an activation? Sepcifically, we receive 2 emails a day that has specific words in the subject line... and I need macro (even on a schedule) to detect that email, open and download attachments, and process the files and archive/move the processed email. Anyone done anything like this before?