Converting Excel 2003 to Excel 2007?

Question

When opening an Excel 2003 workbook under Excel 2007, it says my VBA MACROS are LOST !
Doen anyone knows why ?
Is there a similar language under Excel 2007 ?

Tim: very good !
I was not aware of the secure locations. Defined my folder as secure.
But ... the error still occurs. Excel 2007 issues a message - after loading and trying to convert my workbook: "this workbook has lost you VBA project, Activex Controls and other resources."
So, there must be something in addition !
Any ideas ?

More detail:

Some one pointed me to this:
http://support.microsoft.com/kb/282847/en-us#appliesto

This says that I excluded VBA support when installing the new Ofiice Enterprise 2007. However, I did NOT do this. In fact, I did NOT see any option for that.

So I removed the Excel 2007, I am usang the Excel 2000.

After the end of month, I will try again, this time installing the full Office 2007 (I did not install Access, Outlook and some Office tools I do not use).

Let's see. ...

Answer 1

VBA macros still exist and should work the same in Excel 2007 (even those that create menus). What do you mean by "it" and "lost?"

Have you set the macro security settings in Excel 2007? They are different than before. If not, then go to the Office Button and click the Excel Options button. Go to Trust Center --> Trust Center Settings --> Macro Settings. Note that the settings apply to worksheets that are "not in a trusted location." So, you need to set up your trusted locations. You can do that from the same dialog, just choose Trusted Locations in the menu on the left.

Make sure that you don't download spreadsheets and save them to a trusted location. That would allow them to run code without your knowledge.

EDIT:

Carlos, it sounds to me like your file may have been corrupted. If it is still in Excel 2003 (or earlier) format, and you haven't saved it after the error message, then can you try opening it on a PC with Excel 2003? Other than that, I'm out of ideas. I HAVE seen this problem recently. Some of my students were using Excel 2007 on a recent exam, and I noticed that my macros had been stripped from the files. However, that didn't happen to all of them, and it hasn't happened to me directly. I'm stumped, and I would love to find a solution.

Devilishblueyes gave some good points. However, the Excel 4.0 macro sheets are still supported in Excel 2007, so that shouldn't be a problem.

Tim
http://www.tvmcalcs.com

Answer 2

Excel 2003 To 2007

Answer 3

With each new version of Microsoft, they try making the version more secure. I can think of only two things that could probably make that happen.

Either your macros were really old and written on datasheets or macro sheets. I can't think of what they are called. But basically, very old VBA macro code was written on sheets that were kept right along with your worksheets. I think those may not be supported any longer in 2007.

The other possibility that I can think of is that you might have what are called unsigned macros. If the macro, isn't password protected you may be able to go in and digitally sign the macro yourself although the macro code is not written by you. A signed macro is Excel's way of saying, this macro is OK and comes from a trusted source. Macros can be written to act like a virus or they actually can be a virus if whoever wrote it wants to be malicious. So Excel tries protecting your computer by making sure in knows where the macro comes from. Check out the website address below for information on the topic.

http://msdn2.microsoft.com/en-us/library/Aa163622(office.10).aspx

If that doesn't answer your question, then I recommend checking out:

http://www.mrexcel.com

That is a very good website for answering difficult Excel questions.

It sounds like Tim provided you with some good info also.

Answer 4

Well one instant thought is to save a document with the macro in it, in Excel 2003 mode. It makes sense that it would convert the macro to 2003 style in doing so. Choose file / save as... and look for the selector box for "save as type..." select excel workbook 2003 If that doesn't work I'm all out of suggestions.

Answer 5

your 2003 may have been a pro version and 2007 could be a standard version, if you were using some controls in the 2003 version, they will not show in the 2007 version or any other 2003 version that wasn't pro, or a higher version, if you have a office version that has access ( which has more vba controls than a version that does not have access) then try to open the workbook with these controls in an office version that does not have access... then there could be problems with not having working macro's, you have not been very clear with what doesn't work....

Answer 6

go online get help from there. goooogle it