patgenn123

Did you use Set Focus? I tried your way and without the Set Focus, mine doesn't work. Pat

Alan, I used Shift Down/Control Down/Arrow Left, but unfortunately it defeats the purpose. I am trying to superimpose the new text ontop of the old text without the focus color blue showing on the field. I cannot understand why I cannot get this to work. Pat

Kevin, I tried to do this, but for some reason, it doesn't superimpose the new text on top of the old rather it places it right before the old text and leaves the old text to the right of the new text. I'll keep experimenting, but if anyone has a solution to this, I wouldn't mind knowing about it. Thanks, Pat

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

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

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

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

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

Alan, I place the pop-up menu on the desktop and then drag it to the quick launch toolbar. However, this is not the only place that gives me problems. It sometimes doesn't work in the system tray either. Maybe I need to get more memory. 1.5 gig doesn't go a long way anymore. Pat

Thanks Cory and Lemming! I am just starting to learn about this version. Sorry for wasting your time. I might as well ask now that I'm at it(to continue to waste your time). I get the concept, but what's an example of how you use it? Pat

It's saying Line 4:Debug error: Undefined variable or the variable is the wrong type. This leads me to believe that %Movies% is not defined. Why am I the only one getting this error? How do you define an array variable? pat

Hello all! I am trying to learn this, but I am not getting the same results. The variable %Movies% is nowhere to be found in the debugging window "Show Variable Values". It's not there. I tried a dialog box, but nothing shows there either. Pat

Cory, Actually, the macros are quite brand new and I don't use any hotkeys to trigger them. There are no conflicts. Just baffling. Pat

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

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

Cory, I have the same version as you do. It's the most recent one posted-4.1.6.1. Why am i having this problem? Pat

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

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

Hello Everyone! Does anyone know how to assign an icon to a playable macro? I would be pretty disappointed if there wasn't a way to do this. I have an icon assigned to the macro itself in Macro Express, but it doesn't transfer the icon when I want to create a playable macro. Pat

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

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

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