Excel 2007 : No return() or halt() function message in Excel2007

**penatesz** · 12-22-2010, 04:51 AM

Dear All,

i’m programming a commercial software in matlab environment. The link between this software and matlab is EXCEL. The software can be navigated through Excel therefore all I’m trying to do is creating a dynamic data exchange between Matlab and Excel active (running) worksheet and run the excelmacro of the other commercial software. If I run this macro directly from excel (MenuRunAnalysis) it causes no trouble however if I run it via matlab I get the message:
’No RETURN() or HALT() function found on macro sheet.”
I checked the message and found that it was a bug of previous Excel versions like Excel2000. Originally I used 2003 with SP3 but upgraded to 2007 SP2 to avoid this message, without any effect. Actually the code works fine it does all I need but after every single iteration I get this warning so the matlab code cannot do a whole loop because I always have to intervene and clilck OK.
The VBA code I’m using is:

Please Login or Register  to view this content.

I’m having this problem for several weeks now and running out of ideas. I would really appreciate if someone could help me to come over this obstacle.

**romperstomper** · 12-22-2010, 05:53 AM

Are you using an XLM macro? If so, is there a RETURN() statement in it?

**penatesz** · 12-22-2010, 07:02 AM

Originally Posted by romperstomper

Are you using an XLM macro? If so, is there a RETURN() statement in it?

XLM macro? I’m not really familiar with VBA. I just recorded the macro while starting the other software’s macro and the entire code can be found above. (I did not write return or any other command, just tried to switch off the alert massage)

did I miss something?

**romperstomper** · 12-22-2010, 07:38 AM

What is MenuRunAnalysis?

**penatesz** · 12-22-2010, 08:12 AM

Originally Posted by romperstomper

What is MenuRunAnalysis?

MenuRunAnalysis is a macro created automatically by the commercial software (GC). If I would like to control GC via excel, I give in or change the parameters of the GC model stored in excel cells and with MenuRunAnalysis macro I can run the calculations. I do not have to open GC because the macro runs the simulation behind excel and returns with the output data.

**romperstomper** · 12-22-2010, 08:19 AM

Well it would appear that the issue is not with Excel itself, but with Matlab or GC, or the combination of the two (or three). Since I don't have either of the other two programs, I'm afraid I will have to bow out, but you might want to try their support if you haven't already.

**penatesz** · 12-22-2010, 08:35 AM

Originally Posted by romperstomper

Well it would appear that the issue is not with Excel itself, but with Matlab or GC, or the combination of the two (or three). Since I don't have either of the other two programs, I'm afraid I will have to bow out, but you might want to try their support if you haven't already.

I can run excel macros via matlab with no effort. So the connection between this two should be fine. Also I can control GC via excel as well. The problem I’m having (this warning with return() and halt()) occurs just when I try to combine all three. Do you have any idea or tip what I can do (write into the VBA code) to disable this message?

Otherwise Thanx for bothering with my problem

**romperstomper** · 12-22-2010, 08:48 AM

I don't think there is anything you can put in the code.
Do you by any chance have multiple instances of Excel running when you do this?

**penatesz** · 12-22-2010, 09:36 AM

Originally Posted by romperstomper

I don't think there is anything you can put in the code.
Do you by any chance have multiple instances of Excel running when you do this?

I guess so. I switched on ’share workbook’ and saved the sheet on a different name. Do I need anything else?

**romperstomper** · 12-22-2010, 09:41 AM

Why have you shared the workbook? Shared Workbooks should be avoided if at all possible.

**penatesz** · 12-22-2010, 10:49 AM

Originally Posted by romperstomper

Why have you shared the workbook? Shared Workbooks should be avoided if at all possible.

Sorry I just misunderstood you. I have just one worksheet open. I tried to share the workbook, because I could not come over this problem and thought if GC runs macro in the same worksheet Matlab does, it might helps if I share the workbook however it didn’t go either way.

**romperstomper** · 12-23-2010, 08:26 AM

Continued here.

Excel 2007 : No return() or halt() function message in Excel2007

LinkBack

Thread Tools

Display

No return() or halt() function message in Excel2007

Re: No return() or halt() function message in Excel2007

Re: No return() or halt() function message in Excel2007

Re: No return() or halt() function message in Excel2007

Re: No return() or halt() function message in Excel2007

Re: No return() or halt() function message in Excel2007

Re: No return() or halt() function message in Excel2007

Re: No return() or halt() function message in Excel2007

Re: No return() or halt() function message in Excel2007

Re: No return() or halt() function message in Excel2007

Re: No return() or halt() function message in Excel2007

Re: No return() or halt() function message in Excel2007

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions