Can't run macros from Excel 2003 in Excel2007

**bijan999** · 07-15-2010, 03:05 PM

Hi, I have a problem that I can't run a spreadsheet made in Excel 2003 with macros when I open it with Excel 2007. In all the cells it gives me errors. I already have enable all the macros and security options in 2007. Even the safe location to open it. Is there something new in 2007 that won't let the macro run? Here is the macro just in case:

Please Login or Register  to view this content.

Thanks

**romperstomper** · 07-15-2010, 03:11 PM

Hi and welcome to the forum.

In future, when posting code, please include it in code tags (I have done it for you this time)

Are you by chance getting #NAME errors?

**bijan999** · 07-15-2010, 03:45 PM

Hi, thanks for the advise. Yes, I'm getting that kind of erros "#NAME". Any thoughts?

**romperstomper** · 07-15-2010, 03:46 PM

The functions you are using (nomcta, salmul and salacmul) are not built-in functions - they are written in code and I would suspect that they are located in an add-in which you do not have installed in your 2007 setup.

**bijan999** · 07-15-2010, 04:31 PM

Hi Romperstomper, checking Microsoft Visual Basic in Excel, I found this other code. (this Excel worksheet was made by a former worker and he already left the company)

Please Login or Register  to view this content.

**romperstomper** · 07-15-2010, 04:37 PM

Can you post the workbook that doesn't work?

**bijan999** · 07-15-2010, 04:50 PM

Originally Posted by romperstomper

Can you post the workbook that doesn't work?

Yes, I can, but the problem is that it has a link to the SQL server in my company. That's what the second code refers to.

**romperstomper** · 07-15-2010, 04:52 PM

That should not be relevant to the #NAME error, so it shouldn't matter.

**bijan999** · 07-15-2010, 05:18 PM

Originally Posted by romperstomper

That should not be relevant to the #NAME error, so it shouldn't matter.

I'll try to upload it as soon as possible. There seems to be a problem with the site. (The Excel Help Forum database has encountered a problem).

Thanks.

**bijan999** · 07-16-2010, 10:59 AM

Originally Posted by bijan999

I'll try to upload it as soon as possible. There seems to be a problem with the site. (The Excel Help Forum database has encountered a problem).

Thanks.

Here is the file. You will have to rename it to .rar because I couldn't compress it with winzip belowe 1 mb. Thanks.