Jump to content
Macro Express Forums


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About stevecasper

  • Rank

Contact Methods

  • Website URL
  • ICQ

Profile Information

  • Gender

Recent Profile Visitors

241 profile views
  1. Hey everybody! I know it's been years since I've posted, and I've missed this place a lot. I changed jobs and my new employer didn't want to automate anything. Anyway, I've moved again and now I have a forward-thinking, efficiency-driven employer once again, who has allowed me install MEP on my machine. Not less than 24 hours later I started running into an issue that I'm hoping can be fixed. It's been so long since I had to build a macro from scratch that I may just be missing something obvious, but it also may be a limitation of Windows (or of my machine due to Administrative lockdowns). Here we go: I have a timekeeping program that I have to run at the end of the day. I'm not trying to automate that program, specifically, but I am trying to automate the launching of the program. Here's the process and the problem. I use a Launch command to launch the program. I use a Macro Run command to input the User ID and Password (I have a password macro that enters passwords for me so I don't have to remember all of them as they each have different security level requirments and min/max characters) I have tested to make sure that the macro is not getting stuck in the called "password" macro... it is returning successfully to the parent "launch" macro. At this point, the computer always gives a User Account Control prompt. I can't seem to find any way to eliminate that prompt, and MEP seems to completely ignore that window when I use Wait for Window, Activate Window, or even if I just put in a delay followed by a Text Type <ENTER> to move past that prompt. There are more problems after this one, such as Java prompts that the macro also appears to be ignoring, but this is the one that I need to know right up front if MEP has the ability to manipulate or not. I tried to get a screenshot of the prompt, but for whatever reason I couldn't do that, either. Any thoughts?
  2. Okay, I have found a consistently successful work-around for my problem. And I've got to be honest, I don't know how this could possibly make a difference (if it is my computer and not MEP), but it does. <READ REGISTRY VALUE Key="HKEY_CURRENT_USER\\MEPVariables\\Clipboard001" Destination="%cb%"/> <VARIABLE MODIFY STRING Option="\x10" Destination="%cb%"/> <CLIPBOARD PASTE/> I honestly believe my computer must be contributing to the problem, but I can't help but think there is something wrong with the Text Type > Use Clipboard to Paste function, since the Clipboard Paste command works just fine. Anyway, the work-around is simple, if not quite as elegant as I would like, and for now it seems I only really have to worry about it on my own PC. Thanks to everybody for looking at the issue and giving me pointers.
  3. I was wrong: I was looking at something else that is set at 300. The paste was set at 20. I've now adjusted this, increased it to 300. This definitely slowed the macro down considerably. And yet, I still ended up with: I love my computer... why can't it play nice?
  4. Thanks for the input, Cory. I had thought about that, but the destination application doesn't appear to be the issue in this case. I experience it in Notepad, Excel, IE, Chrome, etc. btw I got your email, when I get a sec I'll take a closer look at the vbscript. Thanks!
  5. ME3 does not experience this issue. It is, however, much much slower
  6. I take it back. Results are similar - if not identical - on other clipboards. I adjusted the paste macro, adding a counter to the repeat and adjusting the pasted text. <REPEAT START Start="1" Step="1" Count="100" Save="TRUE" Variable="%N[1]%"/> <READ REGISTRY VALUE Key="HKEY_CURRENT_USER\\MEPVariables\\Clipboard002" Destination="%cb%"/> <TEXT TYPE Action="1" Text="%N[1]% - %cb%\r\n"/> <END REPEAT/> Clipboard 1: Clipboard 2:
  7. Thanks Kevin. I checked this, and it was set at 300. I adjusted it by multiples of 10 as high as 30,000, with no improvement - in fact I didn't notice any change whatsoever in any of the clipboard-related macros I tried - and before you ask: Yes, I made sure that I saved my changes ) I did however discover something: Apparently I had only tried my "Clipboard 1" macro. I don't seem to be experiencing any problems with clipboards 2-10. I cannot imagine why this is, however, as I have changed the activation for clipboard 1 - originally set to Alt+1, but changed to Alt+Q - without any improvement. Also, the macro actually runs - as demonstrated with the repeat test-version. So the activation itself isn't likely the cause. The application I'm pasting into for the tests is a simple notepad.exe, though I experience it when pasting into anything (Excel, fields in browsers, text boxes like the one I'm typing in right now, etc). It's the most bizarre bug - and I really don't think it's MEP. I'm going to test it in ME3. Will report back.
  8. Ugh, so I just tested it on my wife's laptop (Windows Vista Ultimate 64 - Core 2 Duo - 2.0GHz - 4GB RAM). Works fine on hers. I guess it might be my machine. Any ideas how I could find the source of the error and fix it?
  9. I know I brought this up over a year ago, but can't seem to find the original thread. I use ME for multiple clipboards. Example: COPY <CLIPBOARD EMPTY/> <CLIPBOARD COPY/> <REPEAT UNTIL Variable="%cb%" Condition="\x01"/> <VARIABLE SET STRING Option="\x02" Destination="%cb%"/> <DELAY Flags="\x11" Time="0.5"/> <END REPEAT/> <WRITE REGISTRY VALUE Key="HKEY_CURRENT_USER\\MEPVariables\\Clipboard002" Destination="%cb%"/> PASTE <READ REGISTRY VALUE Key="HKEY_CURRENT_USER\\MEPVariables\\Clipboard002" Destination="%cb%"/> <TEXT TYPE Action="1" Text="%cb%"/> The COPY functions perfectly every time. So I'm not worried about that. The PASTE, however, constantly pisses me off. I run macros that pull information from various files across the network, and stores that information locally so that users can utilize the multiple clipboard function to paste it in wherever necessary. Quick example: Clipboard 1 contains: NAME Clipboard 2 contains: Street Address Clipboard 3 contains: City Clipboard 4 contains: State Clipboard 5 contains: ZIP It would be nice if exercising the paste function would work right. If I change the settings to keystrokes (rather than paste) it works perfectly. And for short things like names and states, it isn't a big difference - however, there are occasions where the amount of data being pasted is a bit larger (nothing the PC can't handle, and nothing ME can't handle), but typing it - even at ME speeds - takes forever by comparison. I've tried changing the storage from the registry to a simple text file in the temp folder - same exact results. I've tried adding delays between the read registry command and the text type command - no improvement. Here is the test I performed, in case anybody wants to try to duplicate my results. Use the following code: COPY <CLIPBOARD EMPTY/> <CLIPBOARD COPY/> <REPEAT UNTIL Variable="%cb%" Condition="\x01"/> <VARIABLE SET STRING Option="\x02" Destination="%cb%"/> <DELAY Flags="\x11" Time="0.5"/> <END REPEAT/> <VARIABLE MODIFY STRING Option="\x11" Destination="%cb%" Filename="C:\\Temp\\Clipboards\\0001" CRLF="FALSE"/> PASTE <VARIABLE SET STRING Option="\x03" Destination="%cb%" Filename="C:\\Temp\\Clipboards\\0001" Strip="FALSE"/> <REPEAT START Start="1" Step="1" Count="100" Save="FALSE"/> <TEXT TYPE Action="1" Text="%cb%\r\n"/> <END REPEAT/> This should paste the copied text 100 times. My results varied from once to 23 times. I can't be the only person experiencing this. FWIW: Windows Vista Ultimate 32 - Intel Core 2 Quad @ 2.66GHz - 4GB RAM
  10. The trick (besides learning VBScript - which I've been planning on doing "someday" forever) is making it happen without opening the worksheet. Example: I have a list of IP addresses 5 columns wide, 2000 rows deep. Column A is dedicated to the store number; B = Router IP; C = Server IP; D = Printer IP; etc. First, the macro prompts for Store Number, provided by the User, or perhaps grabbed from the trouble-ticket. Second, the macro prompts for the specific IP (router, server, etc.) Third, if the file were a .csv, the macro would process the file, locate the store, and provide the required IP. If I could find a way to make MEP process the spreadsheet exactly the same way as it processes text files, my life would be made simple. Even if I could just find a way to have the macro convert and save the file invisibly to a CSV located on the C: drive, that would be fine. ---- I'm thinking that I might just pre-arrange to have the .xls file pre-saved as .csv on my C: drive before the sales-pitch begins, just to keep things smooth. -----
  11. Hello all, Quite some time ago I asked the question: How do I convert an Excel file to a CSV invisibly? The answer pretty well came back in this Earlier Topic that I cannot do so. Ok, that's understandable, if disappointing. It was hinted at, in the above linked post, that I Joe was maybe working on some features for MEP that would make Excel more accessible to MEP. MEP can process the heck out of CSV files, but I can't figure out how to make it dig info from Excel. And I really need it to I'm wondering if there is any status update on that front. Thank you! NB: The key here is that I need it to work invisibly - I know I can have the macro process the Excel information if I open the WB and copy the info, but this would defeat the purpose of the macro I'm trying to build. I need to sell the idea of Macro Express to the Head Honchos, and this particular function should be a no-brainer.
  12. Hi Terry, I don't know if this will answer your question, but I've found that whenever I need a program to be a specific size and in a specific position upon launch, but don't want it to get adjusted every time I focus it (I do this with Notepad a lot - I want it to start in the bottom-right corner, but I may want to move it for various reasons), the easiest thing - for me - is to simply launch it with a macro. That way, it launches, gets sized and positioned, and then I don't have to concern myself with that macro fiddling with my windows anymore.
  13. Accidentally posted this to the ME3 board originally (though ME3 also displays this same behavior). For reasons I won't go into right now, I'm using a repeat command to increment a decimal's value. Because the "Modify Decimal" command doesn't offer an Increment option, I am using a very basic addition routine. %D[1]% starts with a value of .001 and on each run-through it adds .001 to the total. It works fine... until it gets to .072 .071 + .001 (according to MEP) = 0.0720000000000001 This continues until %D[1]%=.1, after that, it gets back to normal: .101, .102, etc. I built the same macro in ME 3.x and got the same result. Here's the relevant MEP Code: Variable Set Decimal %D[1]% to .001 Repeat Start (Repeat 75 times) If Variable %n[1]% Is Greater Than "69" Text Box Display: 1 End If Variable Modify Decimal: %d[1]% = %D[1]% + .001 If Variable %n[1]% Is Greater Than "69" Text Box Display: 2 End If End Repeat <VARIABLE SET DECIMAL Option="\x00" Destination="%D[1]%" Value=".001"/> <REPEAT START Start="1" Step="1" Count="75" Save="TRUE" Variable="%n[1]%"/> <IF VARIABLE Variable="%n[1]%" Condition="\x03" Value="69" IgnoreCase="FALSE"/> <TEXT BOX DISPLAY Title="1" Content="{\\rtf1\\ansi\\ansicpg1252\\deff0\\deflang1033{\\fonttbl{\\f0\\fnil\\fcharset0 Tahoma;}{\\f1\\fnil Tahoma;}}\r\n\\viewkind4\\uc1\\pard\\f0\\fs16 %d[1]%\r\n\\par \\f1 \r\n\\par }\r\n" Left="Center" Top="Center" Width="278" Height="200" Monitor="0" OnTop="FALSE" Keep_Focus="TRUE" Mode="\x00" Delay="0"/> <END IF/> <VARIABLE MODIFY DECIMAL Option="\x00" Destination="%d[1]%" Value1="%D[1]%" Value2=".001"/> <IF VARIABLE Variable="%n[1]%" Condition="\x03" Value="69" IgnoreCase="FALSE"/> <TEXT BOX DISPLAY Title="2" Content="{\\rtf1\\ansi\\ansicpg1252\\deff0\\deflang1033{\\fonttbl{\\f0\\fnil\\fcharset0 Tahoma;}{\\f1\\fnil Tahoma;}}\r\n\\viewkind4\\uc1\\pard\\f0\\fs16 %d[1]%\r\n\\par \\f1 \r\n\\par }\r\n" Left="Center" Top="Center" Width="278" Height="200" Monitor="0" OnTop="FALSE" Keep_Focus="TRUE" Mode="\x00" Delay="0"/> <END IF/> <END REPEAT/> Very strange. Any explanation? I did figure out a simple work-around: Add a second Modify Decimal line: Round to 3 decimal points. That seems to have fixed the issue. Follow-up Oh, and one other thing: If I start with %D[1]% = .018 or higher, the bug doesn't happen. Weird.
  14. Hello all, I haven't been on the forums much in the past year or so, mostly because I changed jobs and - much to my dismay - I now work for a company that automates virtually nothing. On top of that, they are so paranoid about... well, everything that they don't even let us plug stuff into our surge protectors, let alone install software which has not been previously and expressly approved on our machines. It is so bad here that I only very hesitantly asked my supervisor if there were any chance of getting approval for some ME licenses. Surprisingly, she told me to write a proposal, including cost/benefit analysis and she would take it to the powers that be. Getting to the point: I've used Macro Express for years... Originally using Keyboard Express starting in 2000, my company migrated to ME 3.x in '02 or '03, I believe. I have used it ever since, upgrading to MEP when it launched. I understand the benefits of the program very well, and can find a way to get it to do just about anything I need it to do - and when I am stumped, I know I can call on my PGM Forums friends and colleagues for input. The problem is, there are a lot of benefits of MEP that I've never used, which others on the board have. What I would like, if I may ask it, is for anybody reading this post to give me some very basic ideas of what you have been using ME for. Obviously, any tasks requiring boilerplate responses (with or without variables) would fit in this category. Also, if anybody has done any time/benefit analyses or has an effective way to estimate or calculate such a comparison, I would be very interested in something of that nature. To give a brief idea of the areas in my job where it would come in handy: We have a form with about a half-dozen drop down menus. This form must be filled out on every call. For some reason we cannot save preferred settings for these drop downs, even though they almost never change. ME can make this redundant step painless. We send out a number of boilerplate emails in order to update clients on the status of their tickets. Though canned responses are available in the system they say things like "Good <Enter Morning, Afternoon, Evening> <Enter Client's Name>," which is ridiculous and tedious to go through and delete. ME can eliminate the need to hunt down every variable and can fill in the blanks for me. There are a number of tasks where we are required to collect information from a .csv file, organize it, eliminate duplicates, reformat it, and save it to a separate drive. Insanely tedious. Takes about an hour to do the task each day, and with ME I imagine it would take a few seconds. There's more, but that's all that comes to mind immediately. Anyway, I want to thank everybody in advance for your suggestions and ideas.
  15. Thanks Cory. I knew this would be the case... it was more of a hopeful fantasy than an actual hope.
  • Create New...