Gabriel

One issue I can think of is that the CTRL + key short keys are used by a lot of programs so we tend to stay away from that combination. Try changing the hotkey and see if it makes a difference. Do you have exactly 9 pieces of data you need to copy and paste? Is there a reason you need to copy all the variables first and then paste all after? If your data is organized in your spreadsheet and the fields on your form remain in the same location you should be able to automate the whole process so at the press of one button you export all the data from your spreadsheet. I don’t have too much detail on the use of you macro but it may be quicker to copy and paste one variable at a time. I use this simple macro to copy data from one window to another (when the data is randomly distributed). Simply use your mouse to highlight the data you wish to copy > press the hotkey > move your mouse into the field of the form you wish to put the data and left click. Good Luck Gabriel <CTRLD><TEXTTYPE:c><CTRLU><DELAY:1><ACTIVATE2:"Add your spreadsheet window name here"><WAITLM:000010000000><CTRLD><TEXTTYPE:v><CTRLU><DELAY:1><TEXTTYPE:<ENTER>><ACTIVATE2:"Add your form window name here">

Each time we run our macro we set variables from an excel spreadsheet (Database) to run the process. The method we currently use is pretty crude, we open up an excel file and copy the variables to the clipboard and then set variables from clipboard. Is there a way to export the excel file as a cvs file and process using ASCII Delimited File Process. We tried to implement the ASCII File Begin Process using, Start Processing Record Value “%N1%” and Process Partial Records Value “1” but couldn’t get it to work the way we intended. We’re hoping we can process that first row of the spreadsheet and then the next time we run the macro process the second, then the third, and so on. Example: Name Age State Sean 25 NY Steve 40 NM Ben 15 VT Each time we run the macro we would like to pull the data from a csv file so: First Run: %T1% = Sean %T2% = 25 %T3% = NY Second Run: %T1% = Steve %T2% = 40 %T3% = NM Third Run: %T1% = Ben %T2% = 15 %T3% = VT If anyone has any suggestions or code that does something similar we’d appreciate the help THX Gabriel

If you would like to disable this feature across all your macros: Under Preferences>Miscellaneous> Check “Clear Error Messages After __Seconds” After the error occurs the error message will display for your specified amount of time and then the macro will stop. We typically will have an “alert macro” which will run to email/send text message to notify us of the error. Good luck Gabriel

It’s hard to give specific advice without more detail; however some tips I give my developers are to: 1)Use tabs instead of mouse moves as much as possible. 2)Use wait for window function before every mouse click. 3)As Pete suggested if you have to use mouse clicks use the “mouse click on control” as much as possible. Even if you can’t get the specific button you want, you can typical move the mouse to the top left corner of the toolbox you hope to get control over. 4)As Pete suggested check to see if the mouse changes state, and use the “wait for mouse cursor” Gabriel

Very cool, exactly how I dreamed it would be (and you are right the "windows default" style looks best). THX Gabriel

The easiest way I’ve found to do this is to simply write a macro that sends you an email or text message on your phone, schedule it to run every minute, and then disable it. Next at the beginning of your macro that “runs all day” add a line that will enable the “email alert macro”. Since only one macro can run at a time the “email alert macro” will only run if the first macro fails, or ends. You will need select the “clear error messages” function under preferences>miscellaneous for this to work properly. Also be sure to include a disable “email alert macro” function at the end of your “email alert macro” otherwise you’ll end up with LOTS of emails. Gabriel

Maybe a nice way to solve this problem (remembering all the hotkeys) would be to have shortcuts via the Me icon in the system tray. If we add a section with similar functionality as the "tools" or "help" sections (accessible by right clicking on the icon) we could quickly and easily move our mouse over a “macros” section which would display the macros within the mex file loaded, and then simply left click to run. With such a simply way to launch your macro you’d only need hotkeys for critical functions. Another solution would be to simply allow the user to create desktop icons which would run a macro when clicked on. I do like the first one better though, since I’m typically not viewing my desktop when I start a macro (I would hate to have to minimize my windows every time, we are trying to be efficient here right). Gabriel