VBA code/form missing in Excel 2007

[megabite]

In Office 2003, I created an Excel file that includes a small form and some
VBA code. I want to use this same form and code in Excel 2007 - VSTO is not
an option. But when I open the file and go to Developer, Visual Basic, there
is no form and the code is blank.

How do I get this file to function in Excel 2007?

 

[incre-d]

Hi, what do you mean "go to Developer, Visual Basic"

I can't see a menu item for Developer?

 

[megabite]

Excel Options, Popular, check the box labeled "Show Developer tab in Ribbon"

 

[incre-d]

I still don't enjoy this 2007 stuff.

Are you looking in the correct proejct in the Visual Basic...? I just opened
an excel 2003 sheet with form and code, and both show.

 

[megabite]

well that there is the question.
I open the file in 2003 on another computer , the code and form are there.
I open the file in 2007, no code, no form. Why?
Is it a security thing? I think I turned it all off. Compatibility bug?
Something else?

 

[Ron de Bruin]

Do you open the xls in 2007 ?
If you save the xls as a xlsx file in 2007 your code and form are gone.

If you have done that save the xls as xlsm and try it again

 

[megabite]

I open the file in 2007 as xls. I open it from a network drive so I am
opening exactly the same file in 2003 from another computer.

I have not, and will not, save the file in 2007 - I need it to remain
compatible with 2003.

 

[Ron de Bruin]

Do you have the same problem when you open the same file from your desktop

 

[megabite]

yes, that's where it started.

went through all the version, security, network, compatibility issues I
could think of before coming here.

 

[Ron de Bruin]

If you want you can send me the file private.
I will look at it for you this evening

 

[megabite]

If you want you can send me the file private.
I will look at it for you this evening

 

[Ron de Bruin]

I check it out after I come home from the hospital

 

[Ron de Bruin]

Hi megabite

If I open the file in 2003 and 2007 I get this error:
"File error, Some number formats may have been lost"

If I delete the long values in B7:B14 that display like this 1874E+02 (value = 187.379396426012)
and save the file I see the code and form in 2007 when I open it and not see the error in both versions.

 

[megabite]

I saw those errors and was planning to find out why they occurred.

Following your instructions, I deleted the "bad" values in 2003, saved the
file, now I can see the code and form in 2003 and 2007. That's weird.

thanks Ron!

 

[Ron de Bruin]

That's weird.

I will try to duplicate it in a new file this week