Jump to content
Macro Express Forums

Cory

Members
  • Posts

    4,191
  • Joined

  • Last visited

  • Days Won

    59

Everything posted by Cory

  1. I was reading on meproc.exe and although I couldn’t find anything terribly meaty it seems that it was designed to be a stripped down version of ME. So could one use it for user workstations? For instance if I wanted to give users macros who never will need to edit them. Or is this a bad idea.
  2. I'm finding the shared clipboard is a nightmare. The only solutin I've been able to find so far is to is to disable it but this has to be done in the Group Policy Editor and I don't have to have to reboot every time I make a change. I found that if I clear the clipboard every time I use it I don't have problems. Maybe I shoudl do a writeup on this an stick it on my website....
  3. Thanks, I'll try that. I wonder if tabbing and clickin still work...
  4. Genius! I'm so happy I learned something that didn't cause me more work today. Check this out for more description. Also there's a cool Find equivelant. That cold be handy.
  5. I've seen the knowledgebase article and a few posts but most make vague reference to certain things not working. Does anyone have a categorical listing of functional limitations? I can experiment but it would be easier to read about it. I know as long as the TS session is displayed things work fine. I also know that if disconnected some things don’t work. I’m guessing TS doesn’t bother displaying things in effect if there is no audience which might indicate some things that don’t work. I also know that I have large macros that run programmatically, not using the GUI, and they all work fine even if disconnected. But I’m about to write a macro that needs to interact with a program over hours coping, pasting, and navigating and it would be nice if I didn’t have to have the TS window up the entire time to run it. Even if you don’t have such a list but know of some limitation running a macro in a TS session minimized or disconnected I’d love to hear it. Thanks!
  6. There is no sort function in ME. I' supprised that I don't see any in the PGMacros functions library either. Someone may have one though you could borrow. Beyond that you need to do it programmatically. http://en.wikipedia.org/wiki/Sorting_algorithm has some good algorithms you could emulate. You might also consider using the strength of another application. It’s a simple matter to have Excel sort your data so you might consider employing it. This is the cool think about ME. You can use other applications as subroutines. For instance calculation of the square root of something is difficult programmatically. But it’s a breeze to pop open the Windows Calculator and use it.
  7. Yes. Check out ASCII File Begin Process and Text File Begin Process. They work like a repeat sticking each line in variables. To jump in at a certian spot you can use the "Start Processing Record" section and use a variable. Of course you need to prompt the user for this value before.
  8. Kevin: You can replace with "nothing" and avoid the trim. another1one: Isn't this a European postal code? I think you all do it opposite (and more sensibly if you ask me) from the way we plosition it in the US. If it is it's a fixed number of digits and you can simple delete the appropriate number of characters. Also when dealing with different text issues I've found Variable Set to ASCII Value" useful. This way I can do a mathematical comparison. So instead of having a line for each numeric character I can see if a character's ASCII integer value is within a range.
  9. Strathos approaches the problem as I would. He takes the clipboard into a string variable and gets the position of the firs space and saves that to an integer variable. He then decrements the integer once and grabs the text from character 1 to the integer value. And he simply plows on thru parsing the bits between spaces into text variables. But I see a problem here. How does anyone know what is first middle and last? Your rule of 5 versus 4 is the key and your going the right way. First trim the variable from the clipboard and strip CRLF (Carriage Return Line Feed). Many times users accidentally grab spaces or an "Enter" on the end. Then count how many characters there are. Now repeat that many times and grab each subsequent character and increment a counter if it’s a space. I do this in a couple of macros counting tabs so I can tell how many fields there are. Here, let me hack on out quick. Variable Set String %T1% from Clipboard Variable Modify String: Trim %T1% Variable Modify String: Strip CR/LF from %T1% Variable Set Integer %N1% from Length of Variable %T1% Repeat Start (Repeat %N1% times) Variable Modify String: Copy Part of %T1% to %T2% If Variable %T2% = " " Variable Modify Integer: Inc (%N3%) End If Repeat End <TVAR2:01:03:><TMVAR2:01:01:00:000:000:><TMVAR2:04:01:00:000:000:><IVAR2:01:12:1><REP3:01:000001:000001:%N1%:1:02:><TMVAR2:10:02:01:N02:001:><IFVAR2:1:02:1: ><NMVAR:08:03:0:0000001:0:0000000><ENDIF><ENDREP><TBOX4:T:1:CenterCenter000278000200:000:%N3%> As you can see it's pretty simple. So now when you are parsing you can add a condition for the middle name part as weather you append the second middle name.
  10. Cory

    Vb To Db?

    Excellent response Paul. Thanks very much. I'll have to take a look at all this on my next weekend moring with a cup-o-joe and hte laptop.
  11. I already suggested that. You could even have ME arrange them so that no matter which is on top both title bars are visible and a mouse click away. It's crude but it should work. Solutions like that don't appeal to me, it's not elegant enough. What if another window popped up in the mean time or a gazillion other what-ifs. The inability of ME to cope with this is a shortcoming. Hopefully they will address this in the future.
  12. I don't think so. I was even thinking of a Repeat With Windows but if you tell ME to activate window "Calculator" it would probably always give you the first instance. How would you get it to activat the second Calculator? It would be good to know if there is a way.
  13. I too have run into this same problem. For instance eMail messages often have the same title or programs like calculator. If I understand correctly you are re-launching the application as a workaround which is slower. Since almost ever window manipulation in ME relies on the name the only thing I could think of is to use ALT+TAB to go back and forth. Or you could have ME position the two windows in such a way that you could mouse click on either of the visible title bars. You could even get the window position and such at run time in case it changes. Hmmm… There must be a better way though.
  14. Cory

    Vb To Db?

    Wow, you guys are golden gods. <g> Where to start… You confirmed my suspicions that it can be done and it looks fairly lean. I can’t understand the code in your script but it doesn’t look too complicated and I half understand the rest. My feeling is that I can’t simply borrow the script and modify it. Normally if I try to do this I get one little piece of syntax wrong and it won’t work so I think I would need a functional understanding. Otherwise I would rely on you all to write it for me which isn’t fair. Unless I could hire one of you. But if that were to happen I would want more than the script in the way of a mini education. I hate relying on things I don’t understand. So given I don’t know the difference between VB, VBA and VBA and the last language I programmed in was Pascal on a Digital VAX VMS8600 where would I start? Is there some cool online training I can subscribe to or some cool book? I’ve been wanting to learn VB for a long time but I haven’t had a need yet. And how much do I need to know to get done what I need for now? What is WshShell? What is MeProc? I don’t want to pester you script gods but I would appreciate it if you could point me in the right direction to learn so that I can make use of your posts. If you are interested in helping prior to gaining this education I would be willing to hire if inexpensive enough. If you’re like attorneys or Db programmers who get $100+ per hour forget I said anything. <g>
  15. Cory

    Vb To Db?

    Unfortunately even if it were able to access it without opening Excel it wouldn't make any difference. The linked data in a spreadsheet can't be updated until the file is actually opened. I'm curious, does Randall's routine require the file to be open or is it accessing it directly? If it does not maybe he could create an equivelant for Access. Thanks for the suggestion.
  16. ME cannot modify the window title. I doubt any third party program can. I wold think that would eb the doamin of the application.
  17. Yeah it's curious but given this was an odd way to accomplish something no one would ever know or care about it. To be honest I didn't even think it would be possible to get text into a clipboard in this manner! But it is fun to see strange little things like this in action and someday it may be of use. I feel your pain on the front of hidden features. Often one can find a solution buried in another command section and sometimes the organization of the commands categories seem lacking but it's generally pretty good. It just takes time to become familiar with all the commands and their options. What's worse are the tricks in command combinations. For instance if you need to pad an integer as text. I once wrote a mathematical routine so numerical file names would appear in order. Then one day I discovered that one could convert to text, pad left, then substitute zeros (or should I say Zed) for the spaces! Duh! 3 simple lines! I need to put more of these on my website for all. Seeing some of these combinations take chess master intelligence. Of course these forums help a lot!
  18. I have several macros for one client that rely on data in an Access Db. Since ME can’t directly access this they routinely export queries to text files. I know one can access a Db fairly easily with Visual Basic but I am not a programmer. I reckon if one knew VB and ME it would be feasible to create a link between worlds. Has anyone any experience with this? All comments welcome.
  19. I see your problem. I popped open my hex editor and the char is an “End of Text” (hex 03). Have no clue how it got there but I thought I would toss that out in case anyone else knew what it was about. I have no solution to the strange character but I think it odd to use the clipboard this way. If it were me I would set my text to a string var and push that to the clipboard form the String Modify command. <TVAR2:01:01:abc ><TMVAR2:16:01:00:000:000:> More elegant IMHO.
  20. I’m not sure what you are saying but if you’re describing the inability to launch a hotkey macro see if they are running IE7 in Protected Mode. It’s my understanding that this must be disabled for ME to launch from a hotkey even if IE is not open.
  21. Don't we all. Someone told me it's called learning but if that's the case I would be a genius by now and that's clearly not the case. <g>
  22. You might try reinstalling. If that doesn't help contact teschnical support at support@wintools.com. They're very good and responsive.
  23. Uh... It's the "Repeat Start" command in the Repeat group. There is no configuration or whatever to repeat a macro per se unless you have another macro with a repeat which runs the second macro which wouldn't make a lot of sense. It's better to repeat a routine within the macro. Whatever is in your macro now insert a Repeat Strat at the beginning and a Repeat End at the end. FWIW having huge itterations of repeats often cause troubles. Try using the scheduler instead. For instance I have macros that need to effectively run forever but I want to be able to run macros inbetween. So I schedule the macro to run every 60 seconds. Also if you need to repeat indefinately you can use the Repeat Until command and use the condition T1 <> T1. That is T1 not equal to T1. I use this all the time. Then I usually have an If test in there and if it's true issue a break command. Check out the tutorials online, I think there are some cool examples of repeats there.
  24. I would look in the registry for the color depth. I know it's stored in there per user but I'm not sure where. I'm sure if you did a web search you couldfind the key. Also you could try running regmon and changing the color depth and see what happens.
  25. Finally solved. IMHO ME caches control handles and they are never cleared until ME is restarted. Also the “Clear Control Variables” does not work. I’ve tried a gazillion things and put about 6 hours into solving this multiple window problem and I finally found a solution. I tried setting the control window text to a variable and found that it does not work. At some point I tried using the Control Modify Window Title before but about 10% of the time it returned “Control not found” errors. Finally I was able to come up with a combination that appears to work reliably. I first set a string variable T1 to the top window’s title. Then I do a “Get Control” with “ – Message” as a partial match. This could return the control for the top window but often returns the control that is cached thus the bane of my days here recently. You would think you could stuff T1 in there but you would be wrong. <g> Now I use the Variable Modify Control – Modify Top-Level Window Title and set it to T1 and Exact. Now when I Variable Get Control Text I reliably get the control text from the top window. I’m still disappointed with the fact that the clear variables doesn’t do anything and that the ME caches control handles and doesn’t refresh them when one issues a GC command but I’ll save that for another day. I just wanted to post this fix for any future folks who might have the same problem.
×
×
  • Create New...