patgenn123

I want to close a file when a program closes, but I don't see it. Can someone help me? -P

Hello all! I have been looking all around for this and can't find it. Maybe it's too late at night. Here is my scenario: I have MANY "Get Control" fields CAPTURED by the "Get Control" ME function. All of them are in order C1, C2, C3 etc. These controls are all field text labels I want a macro to "fire" everytime my mouse clicks on ANY of those controls(C1, C2, C3). This means it has to be based on my moving the mouse on the control and "clicking it". From my understanding, MOUSE CLICK ON CONTROL means that the mouse knows where it's going. The mouse in my situation doesn't know where it's going until it gets there and "clicks the area". Why can't I find anything tonight? Frustrated... Help! -P

<IFOTH:04:2:Microsoft Excel - ACT! Excel ole db><MSTOP><ENDIF><LAUNCHNO3:2:0112ACT! Excel ole db<LAUNCH:C:\Documents and Settings\Pat\Desktop\ACT! Excel ole db.xls3><DIS:<ACTIVATE2:Refresh Query><DIS:<WAITWIN2:000010:000000:Query Refresh><DIS:<GETCONTROL:01:EXCEL.EXE:001:bosa_sdm_XL9Query Refresh><DIS:<SETFOCUS:01><DIS:<MMW2:20,-164><DIS:<CCLICK:T:01:0:T:><DIS:<ZORDER:1:Refresh Query><DIS:<ZORDER:2:Microsoft Excel - ACT! Excel ole db><WHIDE:Query Refresh><IFOTH:03:2:Refresh Query><DIS:<ACTIVATE2:Query Refresh><DIS:<IFOTH:03:2:Refresh Query><DIS:<WHIDE:Refresh Query><TEXTTYPE:<ALTD>e<ALTU>><ENDIF><WHIDE:Microsoft Excel - ACT! Excel ole db><IFOTH:14:1:ACTSAGE.EXE><WSHUT:Query Refresh><WSHUT:Microsoft Excel - ACT! Excel ole db><ENDIF> The last 5 lines don't work. Why? I am assuming that ME makes a run through the macro however many times the window is active, but doesn't hold the last 5 lines in memory. Is there a workaround? -P

That's true. Thanks Kevin for the suggestion. However, I would like the Excel program to not show at all. Not even a flicker. I too am having problem with "Launch" when clicking "hidden'. Is there any way it doesn't show at all? I guess it looks like a VBscript or a Macro within Excel is the only solution? Is this a bug? -P

Hey all, I was wondering if anyone else came across the same problem. A) I want ME to open an Excel file right after a COMPLETELY SEPARATE program launches. I want the Excel file to be hidden when it launches C) The excel file is an OLE DB that connects to a database and refreshes every 30 seconds D) A dialog box called "refresh query" opens up in between the first program and Excel, asking the user to either ENABLE automatic refresh or disable the automatic refresh. There are two problems: 1) Excel does not open hidden. It's probably because of the interim "refresh query". 2)Of course, there is an ALT-E and ALT-D hotkey to cause the window title "refresh query" to close, but how can this all be done hidden? Any suggestions? -P

OK. I apologize, but if you look, this has never happened before. So what I'll do is ask to have the response erased as long as his response is erased also. he made it sound like my english was like sanskrit. It was a "valley girl" response by him. His answer was objectionable and rude also. Where's his apology? he could have said something like this(if he wants to be politically correct): Hey Pat. Can you rephrase your problem so I could understand what you mean? OR I was wondering if you can summarize your issue so I could help you. Goodness that sounds better doesn't it? Compare that with what/how he said and there's the difference. Deal? I apologize Geoff and request to have my response stricken. Would you like to erase yours also? -P Oh, and Paul. Your answer was way over the top also. Please. Compare the way I would have responded/rephrased my reponse and the way he did and you see how a moderator should have responded in the first place. His was not professional and certainly not proper. It really was a simple question. I know. In sports, it's always the person who retaliates that gets into trouble, but never the initiator.

That's all I needed to know. Thank you. The first two or three sentences of my first post summarized everything I wanted to ask. -P

OK, then let me explain in 3rd grade words to you and draw pictures. Since underlining is an effective way of "yelling at someone", I will underline to demonstrate to you what already should be known by the owners of this software. I will use the exact same words as my last two posts only I will explain in a 3rd grade level. Have I done a good job explaining myself so far or should I yell at you by underlining my words? It took only 4 frickin times for anyone like you to answer. Maybe you should send an e-mail to yourself and yell at yourself for being so lazy and taking this long to answer or ask a question. You even had the audactiy to post your own post instead of being polite from the beginning. You'll never make it as a teacher. Forum monitors: I apologize in advance but this never should have gotten to this point. Here goes: From the beginning, starting with my words two posts ago(posted May 12th 1:12 PM). Please cross reference. All I need to know is why I cannot simultaneouly capture the data in these "fields" at the same time I am hitting the "OK" button(which I am using as the "trigger" control). As an aside, if I use "windows title" it captures everything in those fields within the form. Broken down for you: A) Please Open the attachment included in this forum thread and look at the form right in front of your eyes called "Schedule Activity". Further clarification: it has a red Window Title that says "Schedule Activity" and it is in front of the main ACT! program. Warning: You don't need ACT! to answer this question. Get Control is a feature in your program under "Windows Controls" that I can use a "bulleye" to capture field data. Yeah, been there done that. Are you with me so far? C) There are about 12 fields in the "Schedule Activity" form(see attachment and count the fields) that I can drag my bullseye to. I can capture the field data dragging the "GET CONTROL" control. D) The "OK" button(see attachment, please see the "OK" button) Do you see it? It's there trust me. E) In your Macro Express program, look at your tab called "Properties". Click on it. There are two features there called "windows title" and Control". I am assuming that those "trigger something else to happen. Here is the hardest part: Let's look at my first sentence together again (like we were in Romper Room) and piece together things that I assumed you(the employee/owner) whoever the heck you are would have known. OR should I be assuming space aliens took over Insight Software and now for the first time a person by the name of Geoff is monitoring these boards? Here we go: u]All I need to know is why I cannot simultaneouly capture the data in these "fields" at the same time I am hitting the "OK" button(which I am using as the "trigger" control). As an aside, if I use "windows title" it captures everything in those fields within the form. [/u] Based on A - E above, it is crystal clear my first sentence. If not, reading post 3 and 4 would help put together my question. Windows title is in the properties tab. If "clicked' and I put the word "schedule activity" in that properties tab, then when "Schedule Activity" pops up, then I would be able to "Get Control" all the other fields and capture them C1, C2, C3, C4 etc and then convert them to text. <SEE MY MACRO I SUBMITTED> PS. You don't need ACT! to figure out what I'm talking about. third graders need not apply. There are 12 text fields in that form called "Schedule Activity" this works like a charm. it captures all the text when the form opens and put them in C1 converts to T1, puts them in C2 converts to T2 etc all the way to C12/T12. Now, when I change the properties tab to "control" and Unclick the "window title", and use "Get Control" to drag the bullseye to the "OK" button, then it doesn't work. the trigger is now a button and NOT a WINDOW TITLE. Capishe? ALL I WAS TRYING TO SAY IS: USING WINDOWS TITLE IN THE PROPERTIES TAB captures all the other fields(that are captured by other controls- c1, c2, c3 ... c12)but it doesn't work with the "control"option in Properties tab. If I use the OK button(as the initiator trigger in the Properties tab), it won't capture those control fields(c1 to c12) before the form disappears. I guess in psychology class, one has to do things three times to get through. Here is is again(for your edification): u]All I need to know is why I cannot simultaneouly capture the data in these "fields" at the same time I am hitting the "OK" button(which I am using as the "trigger" control). As an aside, if I use "windows title" it captures everything in those fields within the form. [/u] In the next installment of our show, I will explain the next sentence: Because the form disappears quickly, is this the reason why it's not catching anything? Better yet, for increased edification I will also explain the last sentence in that post: Has anyone ever done this? The explanation of that last sentence should leave our viewers dazzled after an explantion is done on that one. Until then, as Walter Kronkite used to say "and that's the way it is" So long folks. -P PS. Re-reading sentence 2 and 3 of my very first post, I am sort of stunned. What can I say? You just completely contradicted the notion of keeping it short and sweet with this post. Am I clear enough for you now? Doc1.doc

I don't get it. This should be a simple answer. Can Macro Express capture the data in those fields before the OK button is pressed? The OK button is the "Capture Control" and if clicked, captures all other controls in the fields and convert them into text. It's very easy to do this when "window title" is used to trigger the macro, but not so easy when the "OK" button triggers the macro because it "appears" that it cannot capture the field data the moment before the form disappears. I thought Macro Express was super fast? AM I Correct? -P

no takers? All I need to know is why I cannot simultaneouly capture the data in these "fields" at the same time I am hitting the "OK" button(which I am using as the "trigger" control). As an aside, if I use "windows title" it captures everything in those fields within the form. Because the form disappears quickly, is this the reason why it's not catching anything? Has anyone ever done this? -P

Sorry, here is the attachment. -P Doc1.doc

This question is along the same lines as the one posted below, but has a different twist to it. I want an "OK" button to cause the macro to record all control fields values before it disappears and I have run out of options. Here is my macro. This macro works well if the "window title" (in the activation TAB)is set to "schedule activity" (matching the window title), but doesn't work when "control" is used to fire the macro. Activity004:4WindowsForms10.SysTabControl32.app.0.2004eee1WindowsForms10.Win dow.8.app.0.2004eee3WindowsForms10.COMBOBOX.app.0.2004eee1Edit><VARGETCONT:5:5><GETCONTROL2:06:ACTSAGE.EXE:WindowsForms10.Window.8.app.0.2004eeeSchedule Activity004:4WindowsForms10.SysTabControl32.app.0.2004eee1WindowsForms10.Win dow.8.app.0.2004eee21WindowsForms10.COMBOBOX.app.0.2004eee1Edit><VARGETCONT:6:6><GETCONTROL2:07:ACTSAGE.EXE:WindowsForms10.Window.8.app.0.2004eeeSchedule Activity007:4WindowsForms10.SysTabControl32.app.0.2004eee1WindowsForms10.Win dow.8.app.0.2004eee36WindowsForms10.Window.8.app.0.2004eee1WindowsForms10.Win dow.8.app.0.2004eee1WindowsForms10.Window.8.app.0.2004eee1WindowsForms10.Wind ow.8.app.0.2004eee1WindowsForms10.EDIT.app.0.2004eee><VARGETCONT:7:7><GETCONTROL2:08:ACTSAGE.EXE:WindowsForms10.Window.8.app.0.2004eeeSchedule Activity007:4WindowsForms10.SysTabControl32.app.0.2004eee1WindowsForms10.Win dow.8.app.0.2004eee36WindowsForms10.Window.8.app.0.2004eee1WindowsForms10.Win dow.8.app.0.2004eee1WindowsForms10.Window.8.app.0.2004eee1WindowsForms10.Wind ow.8.app.0.2004eee1WindowsForms10.EDIT.app.0.2004eee><VARGETCONT:8:8><GETCONTROL2:09:ACTSAGE.EXE:WindowsForms10.Window.8.app.0.2004eeeSchedule Activity003:4WindowsForms10.SysTabControl32.app.0.2004eee1WindowsForms10.Win dow.8.app.0.2004eee10WindowsForms10.EDIT.app.0.2004eee><VARGETCONT:9:9><GETCONTROL2:10:ACTSAGE.EXE:WindowsForms10.Window.8.app.0.2004eeeSchedule Activity007:4WindowsForms10.SysTabControl32.app.0.2004eee1WindowsForms10.Win dow.8.app.0.2004eee30WindowsForms10.Window.8.app.0.2004eee1WindowsForms10.Win dow.8.app.0.2004eee1WindowsForms10.Window.8.app.0.2004eee1WindowsForms10.Wind ow.8.app.0.2004eee1WindowsForms10.EDIT.app.0.2004eee><VARGETCONT:10:10><GETCONTROL2:11:ACTSAGE.EXE:WindowsForms10.Window.8.app.0.2004eeeSchedule Activity003:4WindowsForms10.SysTabControl32.app.0.2004eee1WindowsForms10.Win dow.8.app.0.2004eee9WindowsForms10.EDIT.app.0.2004eee><VARGETCONT:11:11><GETCONTROL2:12:ACTSAGE.EXE:WindowsForms10.Window.8.app.0.2004eeeSchedule Activity003:4WindowsForms10.SysTabControl32.app.0.2004eee1WindowsForms10.Win dow.8.app.0.2004eee58WindowsForms10.COMBOBOX.app.0.2004eee><VARGETCONT:12:12><GETCONTROL2:13:ACTSAGE.EXE:WindowsForms10.Window.8.app.0.2004eeeSchedule Activity004:4WindowsForms10.SysTabControl32.app.0.2004eee1WindowsForms10.Win dow.8.app.0.2004eee54WindowsForms10.COMBOBOX.app.0.2004eee1Edit><VARGETCONT:13:13><DIS:<ENDIF> I know a lot of people don't use ACT! here. Maybe some do, but the principal is the same. Why are the fields not being captured after the "OK" button is pressed? I need to fill in all necessary info FIRST before I put it all into text (T1, T2 etc.). That's why activating using "window title" won't work. Included is an attachment. Any ideas would help. Thanks in adavnce, -P

Kevin, Thanks for the follow up. Pardon my ignorance, but I read the help file and kind of get it, but why are you adding numbers(142 and 567) to N1? I tried your example and don't see where it's going. Pat

Hello! I tried to launch a file/program "hidden", but for about 5 seconds, the file/program opens up "viewable' and then goes to the "hidden" state. Why? If I ask it to be hidden, I want it to be hidden at all times. Kept on trying it in different ways, but it looks like Macro Express is limited. Do I have to go to vbscript or autoit to hide Macro Express' shortcomings? -P

Hello All! I have a simple problem, I think. This might be a simple solution. Whenever I use the "step-through" Macro to view the macro in slow motion, I want to end the process, but the red X and the running man(right clicking on it to stop the macro) doesn't stop it. Why? Is there a way of stopping this right away and why do i have to wait for this to happen? -P

Can I get an example of how this word work? I have never used Repeat with Windows before. I just want ACT! to be unfocused for 2 seconds while the control is capturing the data. I would prefer it not be minimized. Please something simple so I don't take up much of your time. -P

hello everyone! I have three problems with this: #1- there are more than 99 columns #2- I finally figured out how OLE DB works with a database. The information updates every 1 minute from the database to excel VIA OLE DB. Obviously, I could figure something out to transfer this to an ASCII file and I guess I could figure out using VBSCRIPT to tear out columns and/or rows. I know rows with VBscript, but I'll have to find the script to delete columns via VBscript to delete those unneeded columns. #3- I don't want Excel to be seen. So that's where I'm at. -P

Hey Joe! When is it coming out??? -P

I was wondering if Macro Express can extract data from a line or cell(of Word or Excel) if the Excel or Word file is hidden? Worse case scenario, can macro Express extract data from a Word or Excel file that is minimized? I certainly do not want to see it even flash on the screen. Thank You! Pat

I've noticed, and maybe I'm overlooking the answer, that the properties tab will only allow an "OR" situation to trigger the macro. For example, if Windows title and mouse click are checked to perform an action, the macro is triggered if one or the other happens. Why can't the macro be triggered when two things happen at the same time or both situations are satisfied? Using the example above, I would like the macro to trigger ONLY IF I am on a certain window title AND I click on a certain area in the active Window title. Is it something I am overlooking or I am thinking of this correctly? If so, can this be added on to the next version? I am sure it's only a simple dropdown (and/or) that can be added to the properties tab. Thank you, -P

I think I've figured this out. It appears ACT! will allow the capturing of field data from the layout if ACT! Window Title is NOT the active window. I've been looking for a way of making the window title "inactive" before the control captures the text, but I don't see a command in macro Express to make a window 'inactive". I looked in the forums and help menu, but found nothing. Am I missing something? Where is this command? Does this mean I have to make another program/file active and always on top? Thanks! -P

Cory, That was the last one I tried. I just keeping on trying something to see if anything is working.. No logic behind it. Nevertheless, I also "deactivated" the window activate line and it didn't work. That's the one that is making me mad! I disable the line about activating ACT! and leave MACRO EXPRESS out in front of ACT!. Macro Express is the active window in front. When I click the green "go" button in Macro Express, it picks up the text and writes it to %T1%. It is 100% consistent with Macro Express being the active window in front of ACT! This is really maddening! -P

I guess that prophet is Joe Walsh? Here is my frustration defined even further: I can use "Get Control", use the bullseye and go to a field in the ACT! database and see that it does capture the field value. Now listen: This really gets me mad!!! In my macro routine, I tell my macro that i want to activate the ACT! program window BEFORE the "Get Control" line kicks in. IT DOESN"T WORK. HOWEVER, if I leave Macro Express as the active window IN FRONT of an unactive ACT! program and disable the line(in Direct Editor) that activates ACT! first, then it works. The Macro program is in front of an inactive ACT! program. All I do is click the green arrow in Macro Express to run the macro (DELETING/DISABLING the line that activates the ACT! Window first) and BAM! it captures the field value in %T1%. What?????????? Why does macro Express have to be in front of my main program for it to capture text from a field? I tried many different things to get it to work and nothing works except this. This is just about worthless. Why should macro express be the active window for the "Capture Control" or "Get Control" to work? <DIS:<DELAY:1><DIS:<ACTIVATE2:ACT! by Sage - Personal2008><DIS:<WAITWIN2:000010:000000:ACT! by Sage - Personal2008><DIS:<MSD:500><GETCONTROL2:01:ACTSAGE.EXE:WindowsForms10.Window.8.app.0.2004eeeACT! by Sage - Personal2008008:1WindowsForms10.Window.8.app.0.2004eee1WindowsForms10.Window .8.app.0.2004eee19WindowsForms10.Window.8.app.0.2004eee250WindowsForms10.Win d ow.8.app.0.2004eee1WindowsForms10.Window.8.app.0.2004eee1WindowsForms10.Wind o w.8.app.0.2004eee1WindowsForms10.Window.8.app.0.2004eee1WindowsForms10.EDIT. a pp.0.2004eee><DIS:<CAPCONTROL:F:3:1:000496,000149><DIS:<SETFOCUS:01><CCLICK:F:01:0:T:><VARGETCONT:1:1> Can I get some help as to why it behaves this way. Is the macro running too fast? What is it? -P

Also, That "Contact Detail" on the last line is just an inactive bar that spells out which layout a person is on. The bar is just that, a bar. It does relay to the viewer what layout he is on, but it's a secondary bar to the windows title bar with no activation characteristics as far as I can see. But then why can the "Get control" pick up the text of the bar and why can the "bullseye" capture the edges of the bar/square when the bullseye lands hovers over it? P

Hey Cory! Long time no hear from! I hope all is well. All I am using is this: <GETCONTROL:02:ACTSAGE.EXE:004:WindowsForms10.Window.8.app.0.2004eeeACT! by Sage - Personal2008WindowsForms10.Window.8.app.0.2004eeeWindowsForms10.Window.8.app. 0.2004eeeWindowsForms10.STATIC.app.0.2004eeeContact Detail> Of course, in order to see what I'm getting, I convert C2 to T2 text using <VARGETCONT:2:2> (Variable Get Control using text) When I run the control, I get this: <GETCONTROL2:02:ACTSAGE.EXE:WindowsForms10.Window.8.app.0.2004eeeACT! by Sage - Personal2008003:31WindowsForms10.Window.8.app.0.2004eee2WindowsForms10.Windo w.8.app.0.2004eee1WindowsForms10.STATIC.app.0.2004eee> and it tells me the control doesn't exist??? I see the last line no longer shows up when the macro is run, but why? I used this a few times and it worked, but for some reason, it doesn't anymore. What am I missing?