Jump to content
Macro Express Forums

patgenn123

Members
  • Posts

    371
  • Joined

  • Last visited

Posts posted by patgenn123

  1. Hello everyone!

     

    I am having a somewhat difficult time trying to figure out a simple thing.

     

    I want to Get a control and force a change in the field without having it gain focus. I am using Variable Modify Control to try to force the switch, but it's not working.

     

    It works well when you have to GET CONTROL/GET CONTROL TEXT/FOCUS CONTROL/BACKSPACE/TEXT TYPE TO CONTROL(Send Text Directly to Control).

     

    What I really want to do is to force the change using Variable Modify Control without having the text "highlight" in blue that it's focused on.

     

    In other words, is there anyway of making this seemless without the evidence that a macro is doing the work behind the scenes?

     

    Am I thinking this through correctly?

     

    Pat

  2. Hello all,

     

    I wanted to know if ME Pro can search the desktop folder for a specific file(using Repeat) and once it comes up with the file, drag the mouse to the file, click once and drag the file(unopened) to another area of the screen?

     

    I have been trying a few things and all have failed me. I am probably missing something.

     

    Here is the sequence:

     

    A)Directory command senses added file to Desktop folder

    B)Repeat through the folder to find the newest file

    C)???? This is the part that I cannot figure out??? How can you drag the mouse to the file?

    D)Single left click and hold down mouse

    E)Keep the left mouse button down

    f)Provide coordinates to where the mouse should go(while the left mouse is held down)

    g)Move mouse with file to coordinate

    h)Release mouse

     

    Pat

  3. Thanks Terry.

     

    I am well aware of that option. I just like to place the option in many places on my desktop or Quick Launch or an Internet Explorer toolbar and it gives me the oppotunity to choose which one I would like to use.

     

    I have been experimenting with this and it does seem like there are fewer "stalls" in the system tray, but the program should work better no matter where you place it not just sometimes in some places, but all the time in all the places.

     

    I am wondering if the problem is that there might be other programs running that has the "lock" in them. I do not use the running man to tell me because it's wildly inconsistent and my mind drifts over there to the system tray sometimes trying to delete the running man when it gets stuck.

     

    I shouldn't have to try to guess which one is running. That would mean I would have to go through over 300 macros to find it. We should have the option in ME Pro where we can run a macro no matter what is running- kind of like a stealth override of over every thing else.

     

    I am not super familiar with ME Pro to tell me that that it does that all by itself because of how weird it acts. It's not 100% up to par yet and it seems like there are oodles of bugs still in it.

     

    I just can't stand the fact that it doesn't work and all these MeProc.exe build up in the Task Manager everytime I click on the shortcut on my desktop or Quick Launch Task bar or an Internet Explorer toolbar as a shortcut. Macro Express Pro has to be terminated and restarted again just to clear all processes.

     

    Pat

  4. Cory,

     

    Right click on the Pop-Up Menu and click "Place on Desktop". Move that shortcut to the Quick Launch Bar. I use "none" as a macro trigger, but, of course, you can use hot-keys etc. I just click on the icon(whether it's on the desktop or has been dragged to the Quick Launch) and 85% of the time, it works. Sometimes, it does not. When it is not working, MeProc.exe start accumulating in Task Manager(everytime I try to click it) until I kill MEPro altogether. Then it starts fresh again and it works. Again, it works most of the time, but sometimes not.

     

    Pat

  5. Regarding the desktop idea and hotkey idea, a majority of the time it works and sometimes it does not.

    I have to kill Macro Express Pro and start over again because I notice in Task Manager a whole bunch of MeProc.exe accumulating after the first time it does not trigger. I keep on clicking the desktop button and hotkey and I see a whole bunch of MeProc's just accumulating.

     

    Weird.

     

    Pat

  6. I use pop up menus, and like Cory, find that they appear almost instantly, even on older PCs with many background processes.

     

    How do you trigger your pop-ups? Maybe the problem you are experiencing relates to the activation method. What happens if you change the activation from, say, hotkeys to ShortKeys to Window Title to Mouse Event?

     

    Have you created (from scratch) and tested simpler versions of the pop-ups? E.g., fewer menu items, default icons, and so on.

  7. Hello all,

     

    I have a problem at times with ME Pro and it is frustrating.

     

    I use the popup macro and use the default view so it looks like a context menu with various submacros to choose from. At times it works, at times it doesn't. At times it's super fast and others it takes a few seconds to pop up. I have memory monitors and CPU monitors watching the system as these macros are triggered. Everything looks fine while I click a choice from the default view. It just seems that ME wants to do it's little things when it wants to with no rhyme or reason.

     

    Has anyone else noticed this?

     

    Pat

  8. Hello all!

     

    I recently experienced a total freeze on a Windows 7 computer using Macro Express Pro. It happened during a test run when Debugging "Showing Variable Values". It happened more than once.

     

    Has anyone else experienced this? It is really frustrating because obviously this is the most important part of ME Pro.

     

    Is there a workaround or anything else that solve this problem?

     

    Thanks!

     

    Pat

  9. Hello all,

     

    I know there are still many bugs that ME Pro needs to work through. However, the most annoying one is the "running man" in the system tray.

     

    I keep on having to reboot or kill to ME process in the Task Manager and start over because of how annoying it is.

     

    Is there any indication as to when this is going to be fixed?

     

    Pat

  10. Mr. Biggz,

     

    You're welcome! The only lines you need to manipulate are:

     

     

    Line #3- This is the name of the Excel file you want to extract info from. If you want it to be kept closed, then change line #5 to False. Find the name of your weeksheet within your Excel file(the tab name- for example, Sheet1)where all your info is. Plug it into ("Sheet1"). If the tab is Sheet1 already, you don't have to do anything. On Line 7, this is your output file in .csv form. Where do you want your output to go? Put it there. Save this text file as .vbs. Click on the .vbs file to test run it and you will see your Excel file converted to comma separated and then code Macro Express to find the information you want.

     

    Now you can run Macro Express to run this using whatever trigger you would like. It outputs to the .csv file overwriting the prior .csv file everytime.

     

    If you have anymore questions, please ask!

     

    Pat

  11. Here you go:

     

    http://blogs.technet.com/heyscriptingguy/archive/2005/03/22/how-can-i-save-a-single-excel-worksheet-to-a-csv-file.aspx

     

    Const xlCSV = 6
    
    Set objExcel = CreateObject("Excel.Application")
    Set objWorkbook = objExcel.Workbooks.Open("C:\Scripts\Testsheet.xls")
    objExcel.DisplayAlerts = FALSE
    objExcel.Visible = TRUE
    
    Set objWorksheet = objWorkbook.Worksheets("Sheet1")
    objWorksheet.SaveAs "c:\scripts\test.csv", xlCSV
    
    objExcel.Quit
    

     

    Just change obj.Excel.Visible to False and you could extract text from the text file and parse it with Macro Express. Just remember you need to save it as a .vbs extension and have the vbscript run however way you want it.

     

    Pat

  12. Hello Mr. Biggz,

     

    I still don't know how to use Macro Express exclusively to do this. The only other way is to use a VBscript OR use AutoIT/Autohotkey to make the spreadsheet transparent. You can also use VBA in Excel. One other way is to move your open Excel file(using ME to move it) to a corner of your screen and mine your information that way. Most of these ways will show the file minimized in your task bar though. Some people want the file hidden or closed.

     

    Pat

  13. For anyone that is interested, to add a context menu to Internet Explorer, this is the Registry address: HKEY_CURRENT_USER\Software\Microsoft\Internet Explorer\MenuExt.

     

    I am still not able to get it to work with the parameters above. It appears you do not have to add a Command key like the prior forum post, but nonethless, it still does not work.

     

    Is anyone any expert in this? I followed Microsoft's suggestion on theie website and it's still not working. I am dying to find out how this works. It would make my life so much easier.

     

    Thank you in advance!

     

    Pat

×
×
  • Create New...