joe

We do not use Photoshop here, but have you tried using the Repeat with Windows / Repeat End construct to get a list of windows? Not sure if it can grab Photoshop sub-windows.

I don't use the Codebox tags, but I will check with Invision to see if they can help. In the mean time, use the Wrap in code tags icon instead. It is right above this edit box (last in the line). Just move your mouse over the icons and you will see the names of them.

I appreciate the suggestions, but as to deleting posts, well ... it's best to let the system administrator do it.

Also, when you post a reply, it is like going to a new web page: sometimes it will happen instantly while at other times it seems to drag on forever. Either way, just hit the post button once. The status bar at the bottom of your browser should display the progress of the posting.

Mine has always been unchecked, and I never thought to change it.

Your welcome. Rule of thumb for ShortKeys: non-text object = check the box. Life should be so easy hubba-hubba

I am not encountering any problems with either way (mouse or F2). Both work fine for me.

Now, it doesn't work when the Do Not Remove Keystrokes Typed checkbox is not checked. Without checking the box, you are telling Macro Express to backspace over what you just typed. And what happens when you backspace in Windows Explorer? You climb the folder tree, possibly all the way up to your desktop.

WshShell.Run("""E:\Program Files\Macro Express3\MeProc.exe"" /AAccessReturn /VN1:" & RecCount) 'return the singleton result to ME

Nice touch Paul. Very good. Very good, indeed!

Gentlemen, let's not let this discussion get out of hand. I understand what all of you are saying. If there is a problem with ShortKeys and the clipboard, so be it, and vice-versa ... but keep the discussion civil.

Some of you will notice that I've closed a handful of topics to further discussion. This is my first step in bringing civility and common sense back to the forum before it gets too far out of hand.

The next step, which will happen shortly, is to delete some individual posts. Which posts? Well, those that serve no other purpose but to impugn the integrity of others, and those that attempt to thread-jack topics. Neither situation can be tolerated. And they won't be. I've already waited too long to take action.

This forum is unmoderated and I intend to keep it that way for as long as possible.

Please consider the following before posting something:

• The problem you are posting about is important. But it is more important to you than it is to others. Human nature. When creatures from, say, Alpha Centauri start posting, it will no longer be human nature, but for now it is. We all want to help, but not nearly as badly as you want help.
  
• When you post a problem, keep your post as short as possible. Again ... human nature. Long posts tend to get ignored ... too much work involved, I guess.
  
• Rule of thumb: one post equals one problem. The best way to confuse an issue is to mix other problems with it.
  
• The answer or suggestion you get back may not be to your liking. Or it might be. Who knows? The point is, someone is trying to help and you should respect that.
  
• Most people cannot read minds. This is a *very* fortunate thing. So, if you think that people don't understand your particular problem, then maybe the problem needs to be stated differently.
  
• Personal attacks. On any forum you will find people that will grate your nerves because you don't think they understand your problem. Your choices are to ignore them, ask for a clearer answer, or attempt to win them over to your point-of-view. Your choices DO NOT include, impugning their integrity, questioning their heritage, or ... fill in the blanks. You get the idea.
  

After this, I will no longer give a warning before deleting a post. However, I will give you fair warning if you are about to be banned.

This community has grown exponentially since its meager beginnings back in 2004, when it was converted from a mailing list to a forum. My intention is to keep it growing. The more participating members there are, the better for everyone involved. So, don't make be ban anyone.

This post is closed to further discussion.

Pandora? Ah, Zeus' punishment to mankind for obtaining fire ... the first woman. Hey! c'mon everyone, relax. It's just a fable, right?

does it return the contents of the object in one variable or is there some way to plow thru records as we might do with ASCII File Repeat?

In your case, yes. I say that only because it appears that you have no problem using the Macro Express's file processing commands, and that's great. They do a real fine job, and I prefer them (mostly) over internal scripts. In reality, ADO returns SQL-style record sets. However, a script can convert them to CSV or text files easy enough.

So do you think you could give me a simple sample to play with?

Yes and no. I can give you something to wet your appetite for Excel, but not Access. Maybe, you could take it from there. Or if someone else here has any Access database experience, that would be great, too!

Can VBS query an MDB table that has been secured?

I do not know, but the ADO Open command (which you would use as part of the script), allows for a User ID and Password.

1. Ummmm Yesss… Sort of ... Clear as mud?

Well, yes, it's clear as mud. What I'm thinking is it almost sounds like you could query the Access table for information when you need it as Macro Express is processing the data. Does this sound correct?

This can be done with VBScript and ADO commands. Let me point out however, that we've done this sort of thing with Excel, but never with Access. I can't imagine, though, that it would be that different.

From what I'm reading, you have an Access database that contains data required by some macros in order to run. Furthermore, this data changes periodically, and when it does, you need to run these macros again using the new data.

1. Is this correct?
   
2. Do these same macros ever need to write the data back?
   

But i already heard this is secret MS-Shit.

Watch the language. Save it for other forums, not this one.

Basically I have a set of commands I want to execute. Then I want to REPEAT it again but of course more efficiant to NOT copy/paste 20 commands all over again.

You'll need to look at the Repeat/Repeat End commands.

... a coon's age!

Wow! a double entendre ... we are rollin' now

so in order to quit the macro i have to quit the program (?), whats not easy with my current macro -.-" because it runs wihtout decent pauses and it needs to be so.

Er, what?

What i need is something like this |If Mouse Click|. Means i.e. in a Loop it should Repeat until i click with the mouse the left or right click (in my case the left one).

Although there are Wait for (Left, Middle, Right) Mouse Click commands, there is not one that allows you to loop as you are waiting. These simply stop the macro until a mouse button is clicked.

I then noticed that these hotkeys cannot be disabled, only changed.

I'm fairly certain this is by design. The system macros cannot be changed, disabled or deleted, so it makes sense that their HotKeys cannot be removed.

Does this also mean that every macro needs to have a hotkey assigned?

No. Absolutely not. Macros that you create are not required to have a HotKey.

I understand it is really intended to mean "Not assigned in Macro Express"

I've no dog in this hunt, Insight can change it if they want, but it seems that since you understood what was meant by "available", it makes no sense to change what it says.

"... there is not a way to prevent caching command line activations.

"

Thanks for the reply Kevin.

Can you explain what you mean by this?

Kevin means that MeProc.exe /A**MEX Name** is a command-line execution. These cannot be prevented from being cached.

Topic bumper.

Sorry, not sure where to put this

Macro Express Feature Request page. I like the idea, Rustywinger

I realize I'm breaking about a hundred posting rules with this one, but I'm desperate for help!.

Well, I'm not sure which posting rules those would be.

If a .mxe macro is running, can it be stopped/changed without causing problems or error messages that need to be cleared before ME can launch a different macro? (Or better yet, can ME run more than one macro at a time?)

You would need to build something into the macro to stop it automatically. Something like:

"Hey, if this file, or Registry Value, or Environment Variable exists now, then I quit. Otherwise, I will loop again."

And no, with Macro Express 3 only a single macro can be run at any given time. Floyd and I have, in the past, gotten two to run, but that was through VMWare sessions. It may be a possibility for you.

While I would LOVE for this to work, there are too many variables coming too quick and toggling screens to do this has repeatedly built up errors that eventually cause: ME/Excel program failure or a system crash.

I'll assume that you've already attempted some stability with this approach.

Can Macro Express write directly to the Sub Sheet Excel file without opening it, and if so, HOW?

Not directly. It can, however control a VBScript that does. Two things I've got to tell you right off the bat: 1) We (er, Professional Grade Macros) are working on an Excel/Macro Express interface that will do exactly what you want, but it won't be ready for a while yet. 2) Most of the work I do for one particular client is all Excel/Macro Express/VBScript. it's beautiful to see in action. What you need to learn is Excel's DOM (document object model). You may already know this, I am not sure.

I saw an old posting (back in 2005) that said it was possible, but that you need ---new "ExcelComWIZ"; And only the "exe" in MEX directory from the zip; {_ExcelComWIZ}.mxe, MEbasicWizard.zip"--- Are these files still available?

No. Randall disappeared. Randall and his website disappeared. Randall, his website, and the files you want disappeared. I will say no more about the files except that Randall DID try and some of the work WAS great.

What is the best method for capturing data from of a program that does not respond to key strokes and when the control function (ie. C1) does not return the correct information?

Okay, that question is a setup for: "It depends"

can I pause/stop a macro (that is controlling mouse movement to gather the data) when I move the mouse manually?

Absolutely. Use the Macro Pause command.

Is it possible to display a dialog box that displays a message while the macro continues to run in the background behind the dialog box? Same question but now taking into consideration that the program does not respond to keystrokes (only mouse movement and clicks.) If so, is it possible to have this dialog box change its message as certain conditional variables are met through the data being captured in the background? (i.e. captured data shows that N1 > N2, Message displays "Over"; captured data shows that N1 < N2, Message displays "Under"; captured data shows that N1 = N2, Message displays "Equal Distribution" etc.)

Sort of. In Macro Express 3 there is no "Update message box function". You can, however have more than a single message box that simulates what you are asking. Simply display a new Text Box on top of the old one and then use the Text Box Close command to close the old one.

Glad to hear you're safe Cory!

You will need to create an internal Excel VBA macro for the workbook and run it at the point you want to save.

Welcome,

Create a macro with a single line:

Macro Run: Terminate Macro Express

Then set its schedule for whatever time you want it to terminate.

We here at Professional Grade Macros have found the upgrades to be seamless. We change existing client macros to take advantage of features in new releases, but only if there is a real reason to do so, and only if the client is adding to, or changing something in, their macro.