margaret

I have written macros for indexers, to copy terms out of a PDF into an indexing program. Usually either they work, or they don't, for a variety of reasons, all of which I have been able to decipher in the past. But now one person is saying that some macros work and some don't. What could account for this? It seemed to happen after she installed some sort of Windows update, but I don't know how a Windows update would product such a result. Thanks, Margaret

I have never used the debug features in Macro Express. Usually I just run the macro and try to figure out the problem myself. Now I'm having a weird problem but I don't seem to be able to use the debug features properly. I followed instructions in the book Macro Express Explained, but I still did not get anything in the debug window. What's happening is that the macro is eliminating one character from some text. I don't know how this is happening. I have never seen this before. Anyway, what is the secret to debugging??? Why can't I see anything in the debug window?

I don't know why partial titles wouldn't work for you, but I use partial window titles in my macros all the time and have never had a problem with it.

If I understand what you're doing, I think you could do "if b2 is not equal to T2...." Otherwise, to compare a variable to an earlier version of itself, I think you'd have to save the earlier version to another variable and then compare that: "if T2 is not equal to T3..."

Thanks, I didn't think there was something like that. I might be able to do a menu of choices earlier in the macro, and then the result variable from that menu would govern what happens when the user presses Enter at the end; after the Enter keypress, I'd have "if variable blabla = such-and-such, then .... " etc. Actually that way I could have more options with what the macro does in general.

I'd like to be able to have a "wait" command that would do one thing if one key is pressed and a different thing if a different key is pressed (there would only be two keys possible, and they can't be alphanumeric because this is right after the uses enters some data -- like it could be Enter or Tab). I don't see anything like that, so I suspect it's not possible. Enter will produce an action in the program into which we're entering data (an action we want to produce), and Tab won't. Sort of a continue yes/no? thing. Or is there something I don't see that would be the equivalent of "if keypress equals..."? Thanks!

It was nothing like that. The problem wasn't in the macros, but in security settings in an application that the user was using.

That would defeat the whole purpose of having the variable editable in the dialog. Meanwhile I wrote to customer support and they told me there's no way to do what I wanted at this time; it's just the way that command works.

I have a macro that prompts the user with an already existing variable. OK, it does this fine, but the user doesn't like the fact that the string is highlighted in the dialog, and wants to know if I can get the macro to display the information unhighlighted so that he can go ahead and type without having to do anything to unhighlight the text so that he won't overwrite it. I'm not seeing anything about options like this, and I don't think I can send a keystroke to the dialog when the dialog opens but before the user does anything - right? Thanks.

I wrote a sequence in which the last two characters of a variable are tested to see if they are what they are supposed to be, and the user is warned if they are not. It worked, but what happens is that even if the variable is what it's supposed to be, you still see a flicker of the dialog that you would see if the test had failed. I've never had anything like this happen before. What could cause this? Thanks, Meg

Meanwhile, I just went about it a different way. If last digit of variable equals five Or If last digit of variable equals zero Else ----- warn the user that his input variable is not a multiple of five End If

I'm afraid this doesn't make sense to me. Isn't dividing by 5 and then multiplying by 5 the same thing as multiplying by 1?? 125 / 5 = 5. 5 x 5 = 125.

I want to test whether a number is a multiple of 5. Is there a way to test whether the result of a division is an even number? I've tried testing whether the last digit is a 0 or a 5 but so far it's not working. Thanks.

False alarm, folks -- after I finished my previous post, I thought: this makes absolutely no sense. How can Macro Express put something into a variable that wasn't there a second ago? What if the problem is somehow in the receiving program? I changed the macro so that it pastes the last string into Notepad. It came out fine. The program I'm pasting into has some autocomplete functions. After I turned that off, everything's working right again. (It still doesn't make sense how the autocomplete could add a character unpredictably, but as long as I know it's not Macro Express's fault, that's all I need for now.) Sorry to waste your time. Thanks, Meg

I'm having a problem with a macro in which, at the end of a series of string manipulations, the final resulting string is pasted into a program. The macro was working fine most of yesterday with many tests. Then suddenly it started adding an extra character to the final string that it pastes in. I put in dialog boxes to test the string throughout the macro (like the dialog tells me "T10 is now %T10%") and I can't find anywhere that this extraneous character shows up. When I test the string just before it's pasted in, it's correct!!! But when it's pasted in, the extra character appears (it is the same as another character in the string). The final string is in the format Smith, J. J. (2005) Last night I was getting Smmith, J. J. (2005) Now I'm getting Smith, J. J. ((2005) The final string is created by appending " (2005)" to "Smith, J. J.". So the extra character is a copy of the second character in one or the other of the last two strings. What the macro is doing is breaking up a long string of names from a bibliography into separate entries. This only happens with the last name in the string; the preceding names come out OK. But I've tested every step of the last loop without finding the problem. And my loops that break up and manipulate the other names don't manipulate the text of the names themselves, only the spaces, periods, and commas in order to calculate where one name ends and another begins, etc. Where do I look for the problem now??