johnboy691

Kevin, Thanks so much for your help!! Everything worked great! This has definately been a life saver. Very much appreciated. John

I have set up the email function in a key. The email sends ok, however it doesn't have the attachment on it. I want the key to go to the copy the path into T1 and the file name into T2. Put that information into the attachment section on the email function. Send the email and then go to the next file. I don't know the name of the next file, I just know that all files in a particular folder that I start the key in are jpg files. When I put ADD in the attachment part of the email function it says ADD text or variables. I have tried using %T1%\%T2% and T1\T2 and neither works. There is not a varaible list to choose the variable from like there is in If statement functions, etc. Does anyone know what I may be doing wrong? Thanks, John

If the window focus suggestion doesn't work another1one suggested, try this. I've had the same problem before. Use slow down right above command....or what I like to do is... Text type ALT delay 150 milliseconds (or whatever, maybe even more) Text type e delay 150 milliseconds (or whatever) Hope one of these work for you.

My company has started to get Fatal Errors when keys are run. Insight Solutions discovered this is due to our having old versions of ME. When our tech's do upgrades to the system employee's personal pc's keys can error out fatally. We are having our IT department upgrade each individuals ME program. However, each employee not only has keys made by myself for production and such, but they have also made their own keys at times. What is the best (not necessarily the easiest way) to save the keys on each individuals pc's. I can have them do a Save Macro File As.. or I can have them export each key and then re-import it when the new version is installed on their pc's. With Save Macro File As...wouldn't the new ME then run the keys from wherever they were saved? Versus importing them and having them in ME? IT is going to un-install the old versions of ME before they re-install the updated version of ME. Is this really the appropriate way to go? Thanks for any feedback I can get. John

Roger, Not knowing exactly what your key does before or while it waits, I'm wondering if you could take another approach and use the Test Box Display within If statemetns using the Timed Floating Box? Or possibly other portions of that Command, like Box remains until OK button clicked, etc. Just an idea. John

I develop macros for my company. We have one that is in use by over 100 employees. When I designed the macro I did not password protect it. I have now upgraded this macro and went to delete the older version on an employee's computer and couldn't because it asks for the password. I didn't password protect it and the employee doesn't remember doing it. How can I get the old version off of their computer so I can load the new one using the same hot key? Thanks, John

Paul, thank you very much. After putting this on the bench for a while I finally went back to it and got it to work. Appreciate your help!!!

I do this exact thing in many of my macros. You can have your macro open the excel file go to the line desired by doing a find or by just going line by line. You can then have the macro copy cell, assign to a variable, arrow right, copy next cell, assign to a variable, arrow right, etc. etc. You can then have the macro close the excel file, open or activate your Word or other document and then copy the data into the correct spot by using the variables. I have a macro that takes information line by line off of an excel spreadsheet withover 13000 lines of information and put's it into letters and ten processes that information in our company's billing system.

I have a 13 digit number that I copy to a text variable from excel. I then modifiy it to seperate sections as ME won't calculate numbers larger than 10 characters. I have trouble when I modify these back together. For example: on the number 6590600110158 where 659 is a location, 06 is the year, 001 is the Julian date and 10158 is the sequence number. If I crop it between the end of the Julian date and the begining of the sequence number, increment it and then put it back together, everything is ok. BUT, if the end of the Julian date is like 200 or 210 (has ending zero's) and/or the sequence number is 00098 (beginning zeors). It doesn't put my number back together correctly, it leaves out the zeros. How do I get this to merge back together correctly? For example: copied number 6590636509998 comes back with a value of 659063659999 only a 12 digit number and no zero after the 365. Example below of my scripting. variable modify string: Copy part of %T82% to %T83% THE ABOVE LINE COPYS THE LOCATION, YEAR, JULIAN DATE variable modify string: Copy part of %T82% to %T84% THE ABOVE LINE COPYS THE SEQUENCE NUMBER variable modify string: convert %t84% to integer %N4% THE ABOVE LINE CHANGES SEQUENCE NUMBER TO AN INTGER variable modify integer: Inc (%N4%) THE ABOVE LINE INCREMENTS THE SEQUENCE NUMBER varable modify integer: Convert %N4% to text string %T85% THE ABOVE LINE CONVERTS INTEGER BACK TO A STRING variable modify string: Append %T85% to %T83% THE ABOVE LINE APENDS THE INCREMENTED SEQUENCE NUMBER BACK variable modify string: Append %T83% to %T37% THE ABOVE LINE CHANGES THE VARIABLE TO THE ONE USED IN THE RES OF THE SCRIPT. Variable modify string: Trim %T37% Thanks for any help you can give. John