vze2mss6 Posted April 21, 2007 Report Share Posted April 21, 2007 I am working on a macro that will take data from excel and place them in another application. It is gradebook software for teachers. Are macros just as reliable as other forms of programming? Quote Link to comment Share on other sites More sharing options...
Cory Posted April 23, 2007 Report Share Posted April 23, 2007 Yes and no. First off any program that will interact with an application has the potential for problems but if you are using mouse moves and such you will have a lot of timing issues to weed out. After you fix the timing issues macros can be very reliable. BTW if you are dealing with Excel or any office apps there’s a trick. Instead of moving around in the spreadsheet either export it to a delimited file and use the ACSII File Process command or copy large ranges into a variable via clipboard to process. When you copy tabular data is in a tab separated value format and is easily manipulated in ME. If you do this the macros are extremely reliable because it eliminates all the timing and interface issues. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.