Sledneck21 Posted April 14, 2011 Report Share Posted April 14, 2011 Hello, I've just converted a macro file from ME3 into MEP - The macro has an If statement that checks if a cell in excel is blank - if the cell is blank then the macro stops. If the variable is not blank then it continues with the rest of the code. And also a begining Repeat start for copying info from excel..see below - This code has been shortened and simplified.. Repeat Start (Repeat 9999 times) If variable %T7% = "" Macro Stop Else 'Do the rest of my proccess/code here, Which is several hundred lines long. code code code End If Repeat End The End If is at the very bottom of my code because if that cell(T7) is blank I need it to continue the process on the next line in excel. There is several other If statements and repeat starts/repeat ends in the remaining code but they all match up. - Including the first line of code with the initial repeat start of 9999 times..MEP isn't "seeing" the End If and the Repeat End at the bottom of all my code...But I can run the same macro/code in ME3 and there is no syntax errors or problems - the macro runs great. Is anyone else having problems once converting their macros to MEP and it not reading End Ifs or Repeat Ends? Any help/suggestions would be great. Thanks Quote Link to comment Share on other sites More sharing options...
kevin Posted April 14, 2011 Report Share Posted April 14, 2011 It may be that your macro has a syntax error that Macro Express misses but Macro Express Pro catches. The syntax checking has been improved in Macro Express Pro. I suggest that you copy the macro and then start deleting sections of the macro until the syntax error goes away. As you delete lines make a mental note of what is being removed. If you are not able to resolve the issue that way then send your macro to the Insight Software Solutions support people. If there is an error in the program, we would be very interested in correcting it. 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.