Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

New vs. old version Excel problem

  Asked By: Callum    Date: Sep 02    Category: MS Office    Views: 1279
  

I'm developing using Excel '97. I made the mistake of making some
trivial clean-ups and saving a Workbook using a later version of
Excel (2003) and now, back on Excel '97 with my primary computer,
it always gives me the "You're-gonna-loose-some-features" message
each time I save it with 97. Any ideas if there is a way to reset
something (like ThisWorkBook.Application.Version) to get it to think
it's been made by `97?

Trying to assign a different value to
ThisWorkbook.Application.Version results in a read only error.

Pasting all the sheets from Workbook to Workbook appears to transfer
the named ranges and controls, but for Export / Import of the Macros,
it appears this must be done module by module. Selecting athe whole
project and the Export operation is dimmed.


I poked around MSDN & found little I could use.
http://msdn2.microsoft.com/en-
us/library/microsoft.office.interop.excel._application.version.aspx

Share: 

 

2 Answers Found

 
Answer #1    Answered By: Daniel Costa     Answered On: Sep 02

I would expect that actually saving  it with 97 would get rid of the error.
Are you saying that you get the error when you save with 97, close, load
into 97, save with 97 again? That would be unusual and I've never seen it
(and I do make changes in 2003 then subsequently re-save in 97).

Also, just check that 97's not trying to save as a csv file.

You are correct that copying code from one sheet to another needs to be done
one module at a time. However, just open both sheets and drag the code
modules across to the second sheet in the VB environment. It will assume
"copy" and you only need to drop somewhere on the second sheet's tree view,
so it only takes about 2 seconds each module.

 
Answer #2    Answered By: Grace Ellis     Answered On: Sep 02

> Also, just check that 97's not trying to save as a csv file.

no way! It has all kinds of macros and controls and they are all
still there and functional.



> You are correct ...one module at a time. However, just open both
sheets and drag the code modules across...> Regards, Dave S

Damn! I hate-it when I don't realize drag-n-drop is alive and well!

 
Didn't find what you were looking for? Find more on New vs. old version Excel problem Or get search suggestion and latest updates.




Tagged: